02-06-2009
not fer total sure.... but i don't believe it can be done that way...
don't know the soffice xls format...
however, some ideas spring to mind, so...
perl has a module called Spreadsheet::MakeExcel
I've used that to create spreadsheets for Microsoft Excel.
Perhaps there's a similar module.
You'll have to research that one yourself.
here's the link for that one though:
Spreadsheet::WriteExcel - Write to a cross-platform Excel binary file. - search.cpan.org
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am running a script, the output of which is needed to be filled in .xls file. I am doing this manually now, i mean I am writing the output of the script to Excel file manually. How to redirect the output of the script to .xls file? Please help me out!!!
Thanks much,
Scriptlearner. (6 Replies)
Discussion started by: scriptlearner
6 Replies
2. Shell Programming and Scripting
I need to convert an excel file into a text file
and an excel file into a CSV file..
any code to do that is appreciated
thanks (6 Replies)
Discussion started by: bandar007
6 Replies
3. Shell Programming and Scripting
Hello all. I'm a long time browser, first time poster...Be gentle :-)
I don't use csh much, but have been asked to make a small script for our HP-UX systems to search for a report file(s) or summary file and display the result (I was using vuepad, but this probably is just
complicating... (4 Replies)
Discussion started by: neillsm
4 Replies
4. Shell Programming and Scripting
Hi All,
I want to create an xls file using shell script. I mean that I have written one script. It is having sql output. So I want to save that sql output into one xls file and I want to send that file as a attachment to my team MAIL_IDs.
Can You any guy help me in this?
Thanks in... (3 Replies)
Discussion started by: raghu.iv85
3 Replies
5. Shell Programming and Scripting
Can someone tell me why I'm getting error when I try to run this?
#!/bin/csh -f
source ~/.cshrc
#
set SQLPLUS = ${ORACLE_HOME}/bin/sqlplus
#
set count=`$SQLPLUS -s ${DB_LOGIN} << END
select count(1) from put_groups where group_name='PC' and description='EOD_EVENT' and serial_number=1;... (7 Replies)
Discussion started by: gregrobinsonhd
7 Replies
6. Shell Programming and Scripting
Hi
Below command is returning the list of files which having this string "MTL_SYSTEM_ITEMS".
find . -name "*"|xargs grep -il MTL_SYSTEM_ITEMS
Ex: Above command is returing 2 files (Out of 10 files 2 files having this string). ./file1.txt and ./file2.txt
Here I want to append... (3 Replies)
Discussion started by: balajiora
3 Replies
7. Shell Programming and Scripting
Hi there
I'm using this script to convert command line history with Epoch time stamp to human readable. While it works fine with users with /bin/csh shell, it fails to convert for users with /bin/bash shell. Why is this happening? I even changed and added * and after the # but it still didnt... (2 Replies)
Discussion started by: hedkandi
2 Replies
8. Shell Programming and Scripting
Script to take .xls file and read it for each server "/aix/test/$server_pre.xls" and then removes all the disks as provided in the file and then give output as below for each server, but am getting error where it says cannot find directory.
server_name: server1
Disk Cleaned
hdisk1 hdisk1... (2 Replies)
Discussion started by: aix_admin_007
2 Replies
9. Shell Programming and Scripting
Hi
I am trying one perl script to convert xlsx to xls file but could not able to get all the rows and columns in the xls file . This scriptFILE is basically to convert XLSX to CSV .. I am tweaking the script to convert XLSX to XLS file also
#######################FILE... (3 Replies)
Discussion started by: kshitij
3 Replies
10. Shell Programming and Scripting
I have a line like below
a,blank,12,24
I want to add (12+24) at the end of the line or any where in the same line line
output:
a,blank,12,24,36 (2 Replies)
Discussion started by: Anjan1
2 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)