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!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. Shell Programming and Scripting
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
3. UNIX for Dummies Questions & Answers
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
4. UNIX for Dummies Questions & Answers
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
5. Shell Programming and Scripting
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
6. UNIX for Dummies Questions & Answers
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
7. Shell Programming and Scripting
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
8. UNIX for Dummies Questions & Answers
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
9. Shell Programming and Scripting
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
10. UNIX for Advanced & Expert Users
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
LEARN ABOUT DEBIAN
purity-ng
PURITY-NG(6) Games Manual PURITY-NG(6)
NAME
purity-ng - general purpose purity testing software
SYNOPSIS
purity-ng [OPTION]... list|FILE|TESTNAME
DESCRIPTION
Purity is an interactive purity test program with a simple, user interface and datafile format. For each test, questions are printed to
the your terminal, and you are prompted for an answer to the current question. At a prompt, these are your choices:
y Answer "yes" to the question.
n Answer "no" to the question.
b Backup one question, if you answered it incorrectly, or someone is watching you take the test, and you don't (or do) want to admit a different answer.
s Print your current score on the test you are taking.
q Quit the test, and print the current score.
? Print a help screen for the current prompt.
At the end of the test, your score is printed out. For most purity tests, lower scores denote more "experience" of the test material.
OPTIONS
--version
print current version of purity-ng
-h, --help
show the help message and exit
-p print the test without prompting for answers.
-r decrypt the test using the Rot 13 algorithm.
To get a list of all purity tests available globally on your system, run purity-ng list.
AUTHORS
purity was originally written by Eric Lechner in 1989. purity-ng is a reimplementation of purity in Python for modern systems, written by
Simon Fondrie-Teitler and Luke Faraone.
This manual page was written by Luke Faraone.
BUGS
If you find bugs in the application, please report these to <https://bugs.launchpad.net/purity-ng> or to your distribution's distributor.
SEE ALSO
purity(6)
Running purity-ng format provides documentation about the datafile format.
Additional documentation is available online at <http://packages.python.org/purity-ng>.
January 7, 2011 PURITY-NG(6)