Visit Our UNIX and Linux User 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?

.

Previous Thread | Next Thread
Test Your Knowledge in Computers #505
Difficulty: Medium
An executable statement may not invoke (or call or execute) another procedure (also called subroutine, function, method, etc.),
True or False?

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

Featured Tech Videos