Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Convert excel to tab

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Convert excel to tab
# 1  
Old 05-31-2017
Convert excel to tab
Hello,
I have an excel sheet (.xlsx), with 11 worksheets. I need to run my bash scripts on the 1st worksheet and write the output to the 2nd worksheet.
I am currently manually converting the worksheet into a tab delimited to run the script and then pasting it back to excel.
Is there a way to do this in bash as there are several excel sheets to work on ?

Thank you.
# 2  
Old 05-31-2017
You may want to search this Forum
Several posts, including:

How to convert excel file to csv file or text file?
# 3  
Old 05-31-2017
Hello, I have gone through most of the questions on the forums but none of them have quite helped me to what I want. For example, I tried xls2csv but I end up with an error

Code:
xls2csv -b Unannotated S12.xlsx > test.csv
S12.xlsx is not OLE file or Error

as well as gnumeric

Code:
ssconvert -S S12.xlsx test.csv

(ssconvert:28398): GLib-GObject-WARNING **: invalid (NULL) pointer instance

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Trouble reading from a tab delimited excel file

So I have a file1.txt that is tab delimited: e.g. FIELD1 FIELD2 FIELD3 FIELD4 FIELD5 9545641 123 "Neighbor and Labrador,Canada" 54895 'CANADA' 9456465 456 "Neighbor and Labrador,Canada" 54893 'CANADA' 8746512 789 "Neighbor and... (11 Replies)
Discussion started by: dan139
11 Replies

2. 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

3. Shell Programming and Scripting

Adding tab to excel sheet with shell script

(1 Reply)
Discussion started by: sagar_1986
1 Replies

4. UNIX for Dummies Questions & Answers

Convert csv to excel

Hi All, I have a csv file in unix and I need to convert it into excel formate. Please help me out (1 Reply)
Discussion started by: Abhisrajput
1 Replies

5. Shell Programming and Scripting

Shell script - Excel/CSV file - More than one tab

Hi All, Following is my requirement. I have searched the site and found some threads which has same queries, but non of them have any answer. I thought of posting it once more. We are generating different reports through shell script after we finish our data load. Currently there are 7 such... (5 Replies)
Discussion started by: ace_friends22
5 Replies

6. Shell Programming and Scripting

Adding Tab to excel Sheet

Hi, I have 2 sets of data in two different files,say f1 and f2. I want to create a excel sheet with two tabs whose names will be set at run time(different from excel name) in a shell script, and the data will be written into those two tabs at run time.Any command in UNIX doing so? I am... (7 Replies)
Discussion started by: Kishore_1
7 Replies

7. Shell Programming and Scripting

Convert MS Excel file to Tab limiter file in UNIX

Hi, We have a couple of ms excel files in unix server.We need convert the excel files to files TAB limiter format file with using unix script. Could you please advise on this (2 Replies)
Discussion started by: koti_rama
2 Replies

8. Shell Programming and Scripting

convert new line to tab

hey i m newbie i dont know whether this is happining in my terminal or is there any reason behind this here it is when i do 1.) sed -n 's/\t/\n/gp' space > enter #where space is tab seperated file it works fine it give me a outupt that all tab seperated convert into column but when i... (3 Replies)
Discussion started by: narang.mohit
3 Replies

9. Shell Programming and Scripting

Convert each field to excel

Hi Folks!! I would like to convert each and every output of my query to the excel column wise. Let me give you an example The first attachment (cr.jpg) is the one which i am getting out of a query and the fields are delimited with a '|' (pipe) symbol. I would like to convert each field into a... (4 Replies)
Discussion started by: ganga.dharan
4 Replies

10. Shell Programming and Scripting

Convert to excel

Hi to all the tycoons of Shell programming!! I am getting a csv report out of a query and the report is delimited with '|' symbol. I would like to convert this csv report into an xls column wise.. Let me show u an example as below Say a.csv looks like below Number|Description|Cycle|Date... (6 Replies)
Discussion started by: ganga.dharan
6 Replies
Login or Register to Ask a Question