1) Install Spreadsheet::WriteExcel. How to do this depends on your distribution -- hopefully your distro has a package for it. It ought to, since it's a quite popular extension.
2) Paste this into csv.pl:
3) Set csv.pl executable like chmod +x ./csv.pl
4) Run it like ./csv.pl file1.csv file2.csv file3.csv and watch it generate the file output.xls from that data.
Hi all, I have a script which call a java program, the logging (to log file) in the program is done using log4j. However, as a safety measure, i still choose to direct standard error to another log file as follow
/usr/bin/java -classpath ${classpath} -Xmx128m TestingProgram 2>>... (1 Reply)
Hi,
I would like to list files: ls *.hdf
But I would like a copy of the output directed to the screen, but also APPENDED to a text file: test.txt
I have tried:
ls *.hdf | tee test.txt
However, that will just write over everything already existing in test.txt. How can I append the... (1 Reply)
Hi
i am compiling a source code by make command.
i want to redirect the output of make to a file but at the same time i want to see the output in terminal.
how to do this ?.
please suggest your idea.
thanks in advance.
Saravana
---------- Post updated at 05:24 PM ----------... (2 Replies)
Hi,
What is the syntax to rename excel worksheet present in testing.xls
Suppose my excel name is testing.xls
The worksheet name is sheet1.
I want to change this worksheet name from sheet1 to TAB11.
Thanks in advance. (2 Replies)
Hi all,
I hope this is the right topic for this issue.
I made a list with directories, files, size, ... and i want to export it to a .CSV file.
He does creat my .csv file that i'm asking but i can't read anything of it.
It is all weird symbolics etc. Even when i make a .txt file.
Any... (3 Replies)
I'm trying to get a list of directories with "2012" as one of the sub-directories (ex. ./TRAN/U214OU/IN/2012/03/01). I tried using find like this "find . -name 2012 -type d > list.out" but it won't write to file. What am I doing wrong or is there a better way to do this? (6 Replies)
Hi All,
I need a solution to convert my .xlsx file which has lot of worksheet, convert to separate csv file. Is there any shell script to do this? I can’t use excel macro to do this, since it was password locked.
I need the csv output as an input to my shell script. (1 Reply)
Below script perfectly works, giving below mail output. BUT, I want to make the script mail only if there are any D-Defined/T-Transition/B-Broken State WPARs and also to copy the output generated during monitoring to a temporary log file, which gets cleaned up every week. Need suggestions.
... (4 Replies)
Hi Guys,
I want to redirect the output of 3 scripts to a file and then mail the output of those three scripts.
I used below but it is not working:
OFILE=/home/home1/report1
echo "report1 details" > $OFILE
=/home/home1/1.sh > $OFILE
echo... (7 Replies)
Hi ,
i am generating some data by firing sql query with connecting to the database by my solaris box.
The below one should be the header line of my excel ,here its coming in separate row.
TO_CHAR(C. CURR_EMP_NO
---------- ---------------
LST_NM... (6 Replies)
Discussion started by: dani1234
6 Replies
LEARN ABOUT DEBIAN
excel::template::container::worksheet
Excel::Template::Container::Worksheet(3pm) User Contributed Perl Documentation Excel::Template::Container::Worksheet(3pm)NAME
Excel::Template::Container::Worksheet - Excel::Template::Container::Worksheet
PURPOSE
To provide a new worksheet.
NODE NAME
WORKSHEET
INHERITANCE
Excel::Template::Container
ATTRIBUTES
o NAME
This is the name of the worksheet to be added.
o PROTECT
If the attribute exists, it will mark the worksheet as being protected. Whatever value is set will be used as the password.
This activates the HIDDEN and LOCKED nodes.
o KEEP_LEADING_ZEROS
This will change the behavior of the worksheet to preserve leading zeros.
o HIDE_GRIDLINE
his method is used to hide the gridlines on the screen and printed page. Gridlines are the lines that divide the cells on a worksheet.
Screen and printed gridlines are turned on by default in an Excel worksheet. If you have defined your own cell borders you may wish to
hide the default gridlines.
$worksheet->hide_gridlines();
The following values of $option are valid:
0 : Don't hide gridlines
1 : Hide printed gridlines only
2 : Hide screen and printed gridlines
If you don't supply an argument or use undef the default option is 1, i.e. only the printed gridlines are hidden.
o LANDSCAPE
This will set the worksheet's orientation to landscape.
o PORTRAIT
This will set the worksheet's orientation to portrait.
While this is the default, it's useful to override the default at times. For example, in the following situation:
<workbook landscape="1">
<worksheet>
...
</worksheet
<worksheet portrait="1">
...
</worksheet
<worksheet>
...
</worksheet
</workbook>
In that example, the first and third worksheets will be landscape (inheriting it from the workbook node), but the second worksheet will
be portrait.
o AUTOFILTER
With these attribute, you can add the autofilter to a worksheet. An autofilter is a way of adding drop down lists to the headers of a
2D range of worksheet data. This is turn allow users to filter the data based on simple criteria so that some data is shown and some
is hidden.
Example to add an autofilter to a worksheet:
<workbook>
<worksheet autofilter='A1:D11' />
<worksheet autofilter='0, 0, 10, 3' />
</workbook>
CHILDREN
None
EFFECTS
None
DEPENDENCIES
None
USAGE
<worksheet name="My Taxes">
... Children here
</worksheet>
In the above example, the children will be executed in the context of the "My Taxes" worksheet.
AUTHOR
Rob Kinyon (rob.kinyon@gmail.com)
SEE ALSO
ROW, CELL, FORMULA
perl v5.14.2 2010-06-17 Excel::Template::Container::Worksheet(3pm)