Creating multiple worksheets in CSV file Post: 302172440

10 More Discussions You Might Find Interesting

1. 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 ?...

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

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

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

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

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

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

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

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

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

LEARN ABOUT DEBIAN

pocount

pocount(1)						      Translate Toolkit 1.3.0							pocount(1)

NAME

       pocount - Produces word counts and other statistics from a PO file.

SYNOPSIS

       pocount [--csv] [directory|file(s)]

DESCRIPTION

       pocount will count the number of strings and words in a PO file.

       If  no  files  or directories argument are provided, pocount will recurse through all files from the current directory.	Otherwise, it will
       recurse and count all files in the specified directory or in the specified PO files.

OPTIONS

       --csv  changes the output format to CSV (Comma Seperated Values) for import into a spreadsheet.

OUTPUT

       In normal mode the following output is given:

	avmedia/source/viewer.po
	type	       strings words (source) words (translation)
	translated:	  1	     3		     3
	fuzzy:		  0	     0		   n/a
	untranslated:	  4	    22		   n/a
	Total:		  5	    25		     3
	review		  1	     3		   n/a

       In CSV mode the following outut is shown:

	Filename, Translated Messages, Translated Source Words, Translated Target Words, Fuzzy Messages, Fuzzy	Source	Words,	Untranslated  Mes-
       sages, Untranslated Source Words, Review Messages, Review Source Words
	avmedia/source/viewer.po,  1, 3, 3, 0, 0, 4, 22, 1, 3

       Totals are not provided in CSV mode. In normal mode a grand total and file count is provided if the number of files is greater than one.

BUGS

       There are some miscounts related to word breaks.

							      Translate Toolkit 1.3.0							pocount(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

copying the csv file into different worksheets of xls file

Discussion started by: nimish

2. Shell Programming and Scripting

creating a csv file in awk

Discussion started by: Segwar

3. UNIX for Dummies Questions & Answers

creating a CSV file for past 7 days

Discussion started by: dr46014

4. UNIX for Dummies Questions & Answers

Creating a report from csv file.

Discussion started by: naveen.kuppili