9 More Discussions You Might Find Interesting
1. UNIX for Beginners Questions & Answers
i have a problem in my job
i try to convert an excel file (xls extention) to text file (tab delimited), but no result with this comand
cat xxx.xls > xxx.txt
Do you have eny idea?
PS: sorry for my english
Thanks!! (4 Replies)
Discussion started by: frisso
2. Shell Programming and Scripting
I want your help to write a script which will take text file as input and on the basis of delimiter ":"script will create excel sheet.
Output should be an excel sheet like below:
Column... (8 Replies)
Discussion started by: akabhinav18
3. Shell Programming and Scripting
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.
LST_NM... (6 Replies)
Discussion started by: dani1234
4. Shell Programming and Scripting
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
5. 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
6. Shell Programming and Scripting
I need to find a way to convert excel file into csv or a text file in linux command. The reason is I have hundreds of files to convert. Another complication is the I need to delete the first 5 lines of the excel file before conversion.
so for instance
description of... (6 Replies)
Discussion started by: johnkim0806
7. Shell Programming and Scripting
I have to print a excel file in solaris server. I am using lexmark printer with post script printer driver . But the problem is when i am using " lp -d <printer name> <somefile name.xls>" command it is not printing correctly. but for pdf file using the same command it printing correctly.
... (2 Replies)
Discussion started by: Sambuddha
8. UNIX for Advanced & Expert Users
I need to convert a password protected excel file which will be in UNIX server to a comma separated file. For this I need to open the excel file in UNIX box but the UNIX box doesn't prompt for password instead it is opened in an encrypted manner.
I could manually ftp the excel file to local... (2 Replies)
Discussion started by: Devivish
9. Shell Programming and Scripting
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
Excel::Template::Element::Formula(3pm) User Contributed Perl Documentation Excel::Template::Element::Formula(3pm)
Excel::Template::Element::Formula - Excel::Template::Element::Formula
To write formulas to the worksheet
All attributes a CELL can have, a FORMULA can have, including the ability to be referenced using the 'ref' attribute.
This will consume one column on the current row.
<formula text="=(1 + 2)"/>
<formula>=(A1 + <var name="Param">)</formula>
In the above example, four formulas are written out. The first two have the formula hard-coded. The second two have variables. The third
and fourth items have another thing that should be noted. If you have a formula where you want a variable in the middle, you have to use
the latter form. Variables within parameters are the entire parameter's value.
Rob Kinyon (email@example.com)
perl v5.14.2 2010-06-17 Excel::Template::Element::Formula(3pm)