08-06-2007
No there isn't. The data are data, how you choose to format or filter them in Excel is a different matter. Why not just make the top row an auto filter in Excel.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
i am currently using a unix environment and will be constantly receiving documents in excel format(.xls) my question is
is there any tools that will do auto convertion of data in the excel doc into .txt?
ps.. my job are mainly for batch processing. thus it would be great if no manual work is... (2 Replies)
Discussion started by: swakoo
2 Replies
2. 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
3. Windows & DOS: Issues & Discussions
I have a .csv file, when i open it in excel sheet the content is getting displayed in scientific notation (E+e.) , now inorder to remove tht i have appended ' (single quote) infront of the number. This is working fine. But when i open in excel the ' single quote is appearing before the number. My... (1 Reply)
Discussion started by: dvrraju
1 Replies
4. Shell Programming and Scripting
I have file called abc.txt at /usr/abc..
Content of file is as below.
mZ2|uM/KRCNB30103/1|BADR|NLRDC00C/W | |201105|I|2
oZ2|iM/KRCNB30103/1|BADR|NLRDC00C/W | |201105|I|2
pZ2|qM/KRCNB30103/1|BADR|NLRDC00C/W | |201105|I|2... (3 Replies)
Discussion started by: j_panky
3 Replies
5. Windows & DOS: Issues & Discussions
Hello,
I have received very much needed help in the past from this forum and hope that someone can assist me once more. I am in the military and I am tracking classroom specific training for each one of our units per sailor in that unit. I am attaching the spreadsheet for your review. There are... (5 Replies)
Discussion started by: Maggiepie
5 Replies
6. UNIX for Dummies Questions & Answers
Hello everybody. I am new here and hoping someone is willing to help. I just want to know if anyone can tell me how it would be possible to combine two separate rows in excel while adding certain pieces of information and keeping others the same.
Here is what I mean. I want to combine the same... (1 Reply)
Discussion started by: blubiz2
1 Replies
7. 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
8. 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
9. Shell Programming and Scripting
Hi Folks,
Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are
1excel.xslx
2excel.xslx
3excel.xslx
now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies
10. Shell Programming and Scripting
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::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)