10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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... (2 Replies)
Discussion started by: nans
2 Replies
2. Shell Programming and Scripting
Hi,
Anyone can help I am just converting the excel file to csv using python, I can get the conversion output but the date not display exactly.
test.xlsx date format
167 1588 risks/SCS JP CAMPANA & CIE.pdf SCS JP CAMPANA & CIE 2 1 1 0 2015-03-16 16:56:25
167 1146 risks/AirBNB... (1 Reply)
Discussion started by: fspalero
1 Replies
3. Shell Programming and Scripting
Hi All,
I have created a BI Publisher report in Oracle apps R12.
It has generated the output with *.EXCEL file extension. I have a shell script to mail this output. in my shell script I have copied this file and saved as *.xls file.
But the R12 generated *.EXCEL file is not a real excel... (5 Replies)
Discussion started by: kalidoss
5 Replies
4. Shell Programming and Scripting
Hi all,
I need to find a way to convert excel file into csv or a text file in linux command. The reason is I have hundreds of files to convert. Another complication is the I need to delete the first 5 lines of the excel file before conversion.
so for instance
input.xls
description of... (6 Replies)
Discussion started by: johnkim0806
6 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I have to convert the excel file which will be placed in the Unix box to a CSV file using a shell script.
Please Advise.
Thanks & Regards,
Kumar66 (1 Reply)
Discussion started by: kumar66
1 Replies
6. Shell Programming and Scripting
Hi
I have a excel file in unix machine and have to convert it into a .csv file.I have to do this from a unix script.How do we do this?
Thanks
Abhinav (3 Replies)
Discussion started by: akashtcs
3 Replies
7. UNIX for Advanced & Expert Users
Hello All,
I have a sql report with 50 columns and 1000 rows result in a file ( txt / csv). is there is any way that we can move them to excel in KSH.
Thanks,
Sateesh (7 Replies)
Discussion started by: kotasateesh
7 Replies
8. Shell Programming and Scripting
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
9. Shell Programming and Scripting
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
10. Shell Programming and Scripting
I have some text data generated by a perl script and want to put it into an excel sheet. Is there a perl script that can do this for me, i.e, convert text data to excel? (1 Reply)
Discussion started by: Pavankk
1 Replies