I want to read xls file ussing unix ksh shell.
thanks.
xls is a Microsoft format. As far as I know KSH doesn't have libraries to read it. Maybe PERL does.
Try exporting the .xls file as a csv file. This is plain text and you can then try using awk, sed etc to process it. I don't believe you will be able to do anything with a native .xls file under any unix shell
I have tried to make .xls file to .csv file.
But .csv file could not open.
plz help me if there is any another process.
Thanks in advance.
What did you do to try to open the csv file? Is this a problem of the file contents or of access permissions for example?
I want to store the data of .xls file into database.
For that purpose I want a comma separeted file.
Then I can insert the data into database.
You still haven't answered Rein's question...
What do you mean when you say "But .csv file could not open."
How did you try and open it?
Sorry I forgot to answer.
No, there is no problem with access permission.
I used the command "chmod 777 input.xls"
I have a file input.xls and I want to store the records into database.
So, I want to use "sql loader" to store the data. For that purpose I need any flat file or .csv file. If you use mv or cp command then the .xls file will be renamed .csv, but when I want to see the .csv file using cat oe vi command , it is open with garbage values.
Please suggest me if there is any another process to read one .xls file and then the records will store in te database.
Thanks.
You could use a tool like this:
Excel 2 CSV - Waikato Linux Users Group
(Which uses the Spreadsheet::ParseExcel perl module)
and then parse the comma delimited file for loading into your database.
Cheers,
ZB
Thanks,
but I cann't use it.
You can also use excel or calc (from openoffice) to save the xls file in csv format.
If you can't save the xls in a csv format.
Just try saving as "Plsin Text" and import then.
Why not?
.