Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

Creating multiple worksheets in CSV file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users Creating multiple worksheets in CSV file
# 1  
Old 03-03-2008
Creating multiple worksheets in CSV file
Hello,

I've been tasked with sending 3 types of data (file size, row count, and file name) to a csv file every month for various vendors. I have been asked to put this in one csv or xls file with each vendor being a different tab (or worksheet). Until now, we have been finding and emailing this information out manually, but they would like to have it all put in one place.

Is it possible to do this? And if not all in one file, is there another way to automate this that might require a few extra steps but where the result is the same?

I'm using kornshell...

Thanks
Last edited by tekster757; 03-03-2008 at 04:58 PM.. Reason: I forgot to name the shell
# 2  
Old 03-03-2008
Creating multiple worksheets in CSV file
Well, I have a feeling the answer is "no, it's not possible," or "It might be possible, but will result in so much trouble that it's not worth it."

I'm finding no answers online if I google, and none of my current or former co-workers have done it, plus no answers to similar questions on this site, so I suspect the answer is no.

My co-worker and I surmised that the best probable solution is to create multiple csv files and then use VB (or VBA or html) to put them all together.

Anyone else have any thoughts?

Even if there are none, I still want to thank the moderators for hosting this site - it's great, and I have always been grateful for the answers I get, thanks! Smilie
# 3  
Old 03-03-2008
Hi,

CSV has no notion of separate worksheets. Possibly some applications can load it as set of worksheets.

I dont know I understood your current process of reporting.
Probably you need to produce CSV for every worksheet
and load it manually to Excel.
Also you could produce one CSV with added information about vendor. Once a month you will load it and use macros for distributing entries to proper worksheets.

Regards
# 4  
Old 03-03-2008
Creating multiple worksheets in CSV file
Yes, exactly what I was thinking regarding creating multiple csv files. I hadn't thought of macros though, thank you! I have no experience with macros, but from what I've heard they can do, that might be just the ticket for at least automating the updating of the monthly file. Then, as you said, load each vendor manually into excel.

Well, off I go to learn about macros - is that something that unix can do, or is that strictly a Windows or SAS thing?
# 5  
Old 03-04-2008
If you're familiar with perl, you might try

Spreadsheet::WriteExcel - Write to a cross-platform Excel binary file. - search.cpan.org
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Shell script for dealing with XLS file with multiple tabs/worksheets

Hey Guys , Recently working on a requirement , i had to deal with XLS file with multiple tabs and the requirement was as below : 1. Convert one XLS file with multiple tabs to multiple CSV files. -- As i was working on MAC , so it was quite easy through APPLESCRIPT to deal with this.But... (2 Replies)
Discussion started by: himanshu sood
2 Replies

2. Shell Programming and Scripting

How to split multiple worksheets into multiple files?

Dear all, My source contains excel file with multiple worksheets. As part of project requirement I need to split all the worksheets into multiple files in ETL. For Example, Source File (A.xls) contains multiple worksheets B,C,D then Output should B.xls C.xls D.xls Can anybody help me... (1 Reply)
Discussion started by: Abhisrajput
1 Replies

3. UNIX for Dummies Questions & Answers

Creating a csv file with header in UNIX

I have a flat file that contains dynamic list of variables like a=1 b=2 c=3 . .. z=26 I need to convert the above into a csv file having the format below: a,b,c,..,z 1,2,3,..,26 Please note, I do not want a comma separating the last variable. I tried to refer the post... (4 Replies)
Discussion started by: vkumbhakarna
4 Replies

4. Shell Programming and Scripting

reading a csv file and creating a flat file

hi i have written a script for reading a csv file and creating a flat file, suggest if this script can be optimized #---------------- FILENAME="$1" SCRIPT=$(basename $0) #-----------------------------------------// function usage { echo "\nUSAGE: $THIS_SCRIPT file_to_process\n"... (3 Replies)
Discussion started by: mprakasheee
3 Replies

5. UNIX for Dummies Questions & Answers

Problem in creating CSV file

Hi guys, I am not experienced with Unix, so please dont mind if the question seem to be irrelevant. I have written a simple script, that connects DB & fetches few records from a table. I wanted to get those details as file in .CSV format via mail. -I stored the query o/p in a file. -I... (6 Replies)
Discussion started by: sumitburnwal88
6 Replies

6. Shell Programming and Scripting

creating a csv file from this 1 liner?

I'm trying to create a csv file by running awk and sed on a number of xml files in a directory; I'm using this below: hostname; grep "BuildDate" /dir/ABCD/configuration/*/*.xml | awk -F"/" '{ print $5 }' > /tmp/tempfile.txt; grep "BuildDate" /dir/ABCD/configuration/*/*.xml | awk -F\" '{ print $2... (2 Replies)
Discussion started by: rich@ardz
2 Replies

7. UNIX for Dummies Questions & Answers

Creating a report from csv file.

Hi Gurus, I need your help in transforming the CSV file into some what a report format. My source file looks like below Date,ProdID,TimeID,LevelID 2010-08-31,200,M,1 2010-08-31,201,Q,2 2010-08-31,202,Y,1 2010-08-31,203,M,5 Output required is ... (9 Replies)
Discussion started by: naveen.kuppili
9 Replies

8. UNIX for Dummies Questions & Answers

creating a CSV file for past 7 days

I have a requirement which will select the files with a specific naming convention which got created in past 7 days in a specific directory.Lets say the directory is /data/XYZ and the file names follow the below nomenclature like Daily_File*.txt I just need to create one CSV file which will... (12 Replies)
Discussion started by: dr46014
12 Replies

9. Shell Programming and Scripting

creating a csv file in awk

Hi All I am trying to create a csv file in the korn shell and the script segment is as follows: if then # NEED TO ADD INFO TO THE EMAIL FILE ABOUT THE DRIVE THAT'S FILLING UP echo "$drive $percent% $space "|\ awk '{printf("%d/t"|"%d/t"|"%d/t\n",... (6 Replies)
Discussion started by: Segwar
6 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