Login or Register to Ask a Question and Join Our Community


connvert xls file to any other file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting connvert xls file to any other file
# 8  
Old 10-08-2007
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.
# 9  
Old 10-08-2007
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
# 10  
Old 10-08-2007
Thanks,
but I cann't use it.
# 11  
Old 10-08-2007
You can also use excel or calc (from openoffice) to save the xls file in csv format.
# 12  
Old 10-08-2007
If you can't save the xls in a csv format.
Just try saving as "Plsin Text" and import then.
# 13  
Old 10-08-2007
Quote:
Originally Posted by rinku
Thanks,
but I cann't use it.
Why not?

.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Convert Excel File (xls) to tab delimited text file on AIX

Hi i have a problem in my job i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand cat xxx.xls > xxx.txt Do you have eny idea? PS: sorry for my english Thanks!! (4 Replies)
Discussion started by: frisso
4 Replies

2. Shell Programming and Scripting

Unzipping a file in Solaris - Issue with xls file

Hi, I have an excel file generated by system in windows. I am zipping it, transfering to unix and unzipping there. But i'm getting below output while unzipping. $ /usr/bin/unzip -a 123.zip -d . Archive: 123.zip inflating: ./123/Index.xls When i copy this unzipped xls file to... (0 Replies)
Discussion started by: ajaykumarb
0 Replies

3. UNIX for Advanced & Expert Users

Converting .csv file into .xls file and send it to inbox

Hi All, I wrote a script to extract data from Oracle DB and place it in a text file , and I have coverted .txt file into comma seperated .csv file and I sent it to my mail box . I can get .xls file in my inbox.I am getting all data in same column and in different rows , without column... (1 Reply)
Discussion started by: krthkmuthu
1 Replies

4. AIX

How to convert csv file to xls file

Hi All, I have a java program running in AIX machine which gives me the output in form of .CSV but my clients wants output in the form of .xls When I gave the command mv <filename.csv> <filename.xls> The contents of this .xls file is not exactly in seprate columns as in CSV, the contents... (1 Reply)
Discussion started by: chetu777
1 Replies

5. Shell Programming and Scripting

Conversion of .xls file to .csv file

Hi Folks, I've to convert manually couple of *.xls files to *.csv files everyday :( so i was just wondering if anyone could just help me with a shell script or awk script to automate the process :) PS : Problem is that i cannot use any third party software for the conversion. Thanking... (1 Reply)
Discussion started by: chaturvedi
1 Replies

6. UNIX for Dummies Questions & Answers

To convert a txt file to .xls file

i want to convert a comma seprated file into a .xls file the file contains 3 fields seprated by a comma. i want to convert it into a .xls file with 3 columns and 37 rows DPRPT400,01/15/2009-15:03:06,01/15/2009-15:03:08 DPRPT401,01/15/2009-15:03:15,01/15/2009-15:03:32... (11 Replies)
Discussion started by: manit
11 Replies

7. Shell Programming and Scripting

converting xls file to txt file and xls to csv

I need to convert an excel file into a text file and an excel file into a CSV file.. any code to do that is appreciated thanks (6 Replies)
Discussion started by: bandar007
6 Replies

8. Shell Programming and Scripting

convert a txt file to xls file

How to convert a txt file(tab delimiter) to xls file. Looking forward help. Thanks, Venkatesh. (2 Replies)
Discussion started by: venkatesht
2 Replies

9. UNIX for Dummies Questions & Answers

renaming xls file

I am trying to move and rename an excel file by appending date to it but i am not getting the desired result mv SrcFiles/Sales.xls SrcFiles/SG_Archive/Sales_`date +%Y%m%d%H%M%S`.xls result:- Sales_Ym63HM desired result - Sales_200710171323.xls (2 Replies)
Discussion started by: systemsb
2 Replies

10. Shell Programming and Scripting

copying the csv file into different worksheets of xls file

Hi, I have a script which will generate three csv files. i want to copy the contents of these csv files into a .XLS file but in different worksheets. Can a this be done in the same script? :confused: Can Perl come to my help in coping the csv files into different worksheets of .XLS file ?... (0 Replies)
Discussion started by: nimish
0 Replies
Login or Register to Ask a Question

Featured Tech Videos