UNIX for Dummies Questions & Answers

I have a software which generates excel report with some specific data. The excel file format is .xls (old 2003 format)
The data are in the forms like differenct cells contains numeric, string and alphanumeric data.
The data per cell for specific input data is fixed.
I need to retrive specific cell data using shell or perl script.
Any one have any such script available or help me create one if has the idea about?

So, you are genearting the xls in windows and wants to validate in unix?
Does your xls contain multiple sheets or a sheet?

ya its generated in windows and I have to create a script or module to verify it. It contain single sheet but this sheet is produced by implementing formulae.

ok.Please post the result of

Code:

sed '10q' xls_filename

and explain what you want to validate in that.

after doing sed '10q' asd.xls I'm getting :
��ࡱ�;�� ����`���\p B�a�=
Ӻ
ThisWorkbook���=hKL,�8>@�"��1���A_ia+1���A_ia+1���A_ia+1���A_ia+1���A_ia+1� �A_ia+1���A_ia+1���A_ia+1� �A_ia+1 �A_ia+1���A_ia+1�5�A_ia+1�5�A_ia+1�
�A_ia+1
�A_ia+1�
�A_ia+1� �A_ia+"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)��� � ��� �� ��� �� ��� �� ��� �� ��� �� ��� �� ��� �� ��� �� ��� �� ��� �� ��� �� ��� �� ��� �� ��� �� � � �+�� �� �)�� �� �,�� �� �*�� �� � �� �� �
X �� �
X� �
X �
X� |@ @ 8 �|� � h@ @ � � h@ @ � � h!@ @ � �|!@ @ � � h!@ @ � � h!@ @ � � h!!@ @ � H � H |@ @ 8 |!@ @ 8 � (@ @ � �8@ @ � �8!@ @ � � (!@ @ � � |� �|� �� � (� � h""@ @ � | @ � � h"@@ � � �
"|� � H, �
H, �"X, � H� �
H� �
H� � H � H� �
H � H �
H �|@ @ � �(|@ @ � � `@ @ � � (@ @ � �!X, �� �X �� � l@ @ � �"<@ @ � � p@ @ � �


I dont think its wat u thot..
I want to validate value at a particular (row,column)
ie there is a value 1000 at (48,5)

it seems we are not able to view the content properly. if view it properly as like in windows,then we can proceed with the logic.
How you are doing the export from windows to unix?

@PratLinux,

you need to use perl and use this module

Spreadsheet::WriteExcel - search.cpan.org