10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have browsed for the similar requirement i found this
but my problem is i have multiple tabs in xls file having same metadata
I want to convert it into single csv file
any ways to do it pls... (5 Replies)
Discussion started by: joshiamit
2. Shell Programming and Scripting
I am getting data as below for one of my table as below in a .txt format.I am manually opening a xls sheet, and then selecting import data from option and importing the data in to xls and then saving it as .csv file and this .csv file I am using for one of the shell script.
I am... (3 Replies)
Discussion started by: shruthidwh
3. Shell Programming and Scripting
My requirement is to convert the xls to csv file with utf-8 conversion.
Is there any way please suggest me.
Raja (4 Replies)
Discussion started by: cnraja
4. Shell Programming and Scripting
Please give me the solution to the following ASAP.
1) Converting the .xls into .csv
Script i tried,
mv hello.xls hello.csv
The above given script converting the .xls file into .csv successfully. But after i run the below unix command I am no able to open the .csv file, its giving... (4 Replies)
Discussion started by: velava
5. UNIX for Advanced & Expert Users
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
6. Shell Programming and Scripting
I just want help in coding a simple shell script since i am a newbie for UNIX and i started learning unix and shell scripting basics recently.
I am having a data like this in .txt file.
Product Name : XYZ
Price : 678.1
Best Buy Price : 600
Product Name : ABC
Price : 465... (3 Replies)
Discussion started by: vasanth_123
7. Shell Programming and Scripting
i don't know anything about PERL. Can anyone help me providing PERL scripts for
1. converting XLS to CSV (and vice-versa)
2. converting DOC/RTF to TXT
Prvn (1 Reply)
Discussion started by: prvnrk
8. Shell Programming and Scripting
I need to take the totals from my script and input them into a excel spreadsheet. Right now, I just copy and paste. Is there an easier way?
is the total jobs in ABEND state
is the total jobs in SUCC state
is the total jobs in HOLD state (1 Reply)
Discussion started by: wereyou
9. Shell Programming and Scripting
Can we convert an xls file into csv format in Unix
Suresh (1 Reply)
Discussion started by: sureshg_sampat
10. Shell Programming and Scripting
Can anyone tell the option to change the file type in unix.
i.e. if a file is in csv(Comma Separating Values) format, it should be changed to xls(ordinary MS-Excel) format. But renaming command is not changing to correct file format.
Thanks in advance,
Milton. (1 Reply)
Discussion started by: miltony