01-10-2005
Perl - Appending/Modifying Excel files
Hi
I have been using Spreadsheet::ParseExcel and Spreadsheet::WriteExcel to read and write excel workbooks, respectively.
Spreadsheet::WriteExcel can only be used for creating new excel spreadsheets.
I am looking for a module that would/should help me in appending to existing excel files. Adding new rows to the existing worksheets of an excel file is one such typical requirement of mine.
I tried searching in
http://search.cpan.org and came across Spreadsheet::ParseExcel::SaveParser which is supposed to be an integration of ParseExcel and WriteExcel. But this does not help me either.
Could someone help me out here?
Thanks,
Yuga
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi i ahve a loop like this
while(<infile>)
{
($file1,$file2)=split(/=/);
//here i have to appended the file 1 value to array..how can i do it?
}
// cause here i ahve to display entire file1 and file2 values
thanks and regards
vivek.s (7 Replies)
Discussion started by: vivekshankar
7 Replies
2. Shell Programming and Scripting
How do I add 4 columns to an excel file using Perl? The 4 headers for those columns will all have different names? Please help and I greatly appreciate... (1 Reply)
Discussion started by: dolo21taf
1 Replies
3. Shell Programming and Scripting
Hi,
I am trying to find a way to read an excel work book with multiple worksheets.
And write each worksheet into a new excel file using perl. My environment is Unix.
For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies
4. Shell Programming and Scripting
Hi freinds
I have a small problem I want u to help me in, I have a syslog server and configured it to send me email automatically, I get a small perl script to help me in, and tested it to send alerts to root and it worked successfully without any problems
Now I want to send it outside, I... (4 Replies)
Discussion started by: reaky
4 Replies
5. Shell Programming and Scripting
Hello,
I have a large amount of data with the following structure:
Word=Transliterated word
I have written a Perl Script (reproduced below) which goes through the full file and identifies all dupes on the right hand side. It creates successfully a new file with two headers: Singletons and Dupes.... (5 Replies)
Discussion started by: gimley
5 Replies
6. Shell Programming and Scripting
I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix
But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed.
What to do...Please... (7 Replies)
Discussion started by: mud_born
7 Replies
7. Shell Programming and Scripting
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies
8. Shell Programming and Scripting
Hi all,
I am having a slight issue updating a file using perl from the command line I need some help with.
The item is:
DATA_FILE_TYPE=FULL
When I run the below command
/usr/bin/perl -p -i -e "s/DATA_FILE_TYPE=/DATA_FILE_TYPE=APPEND/g" processfile.cfg
It looks to be... (2 Replies)
Discussion started by: kstevens67
2 Replies
9. Shell Programming and Scripting
I have a large database which has the following structure
a=b
where a is one language and b is the other and = is the delimiter
Since the data treats of language, homographs occur i.e. the same word on the left hand side can map in two different entries to two different glosses on the right... (3 Replies)
Discussion started by: gimley
3 Replies
10. Shell Programming and Scripting
Hi Experts,
I am querying backup status results for multiple databases and getting each and every database result in one csv file. so i need to combine all csv files in one excel file with separate tabs. I am not familiar with perl script so i am using shell script.
Could anyone please... (4 Replies)
Discussion started by: ramakrk2
4 Replies
LEARN ABOUT DEBIAN
excel::template::element::cell
Excel::Template::Element::Cell(3pm) User Contributed Perl Documentation Excel::Template::Element::Cell(3pm)
NAME
Excel::Template::Element::Cell - Excel::Template::Element::Cell
PURPOSE
To actually write stuff to the worksheet
NODE NAME
CELL
INHERITANCE
ELEMENT
ATTRIBUTES
o TEXT
This is the text to write to the cell. This can either be text or a parameter with a dollar-sign in front of the parameter name.
o COL
Optionally, you can specify which column you want this cell to be in. It can be either a number (zero-based) or an offset. See
Excel::Template for more info on offset-based numbering.
o REF
Adds the current cell to the a list of cells that can be backreferenced. This is useful when the current cell needs to be referenced
by a formula. See BACKREF and RANGE.
o WIDTH
Sets the width of the column the cell is in. The last setting for a given column will win out.
o TYPE
This allows you to specify what write_*() method will be used. The default is to call write() and let Spreadsheet::WriteExcel make the
right call. However, you may wish to override it. Excel::Template will not do any form of validation on what you provide. You are
assumed to know what you're doing.
The legal types (taken from Spreadsheet::WriteExcel) are:
o COMMENT
Add a comment to the cell
o blank
o formula
o number
o string
o url
o date_time
other write_* methods as defined defined Spreadsheet::WriteExcel would be integrated by request
CHILDREN
FORMULA
EFFECTS
This will consume one column in the current row.
DEPENDENCIES
None
USAGE
<cell text="Some Text Here"/>
<cell>Some other text here</cell>
<cell text="$Param2"/>
<cell>Some <var name="Param"> text here</cell>
In the above example, four cells are written out. The first two have text hard-coded. The second two have variables. The third and fourth
items have another thing that should be noted. If you have text where you want a variable in the middle, you have to use the latter form.
Variables within parameters are the entire parameter's value.
Please see Spreadsheet::WriteExcel for what constitutes a legal formula.
AUTHOR
Rob Kinyon (rob.kinyon@gmail.com)
SEE ALSO
ROW, VAR, FORMULA
perl v5.14.2 2012-04-29 Excel::Template::Element::Cell(3pm)