06-12-2009
If this entire process must be automated, you may need to write a Perl script to encode the Excel spreadsheet. There are several modules available, at least one of which I've used before on a Solaris platform (I do remember that some are win32-only).
10 More Discussions You Might Find Interesting
1. HP-UX
Dear Members,
How do I create an eqvivalant of Excel sheet in Hp-UX.
Is there any application like the Microsoft Excel on HP-UX.
How do I invoke it.
Regards,
PrasadKVS (5 Replies)
Discussion started by: KVSPRASAD
5 Replies
2. Shell Programming and Scripting
Hi Guys,
I like to create a excel sheet with four tabs.
Is it possible to create it. Acutually i want to apply formulas in fourth tab which uses the three different tabs.
Is it possible to create such a script?
Thanks & regards,
Magesh (3 Replies)
Discussion started by: mac4rfree
3 Replies
3. Shell Programming and Scripting
Hi,
I have 2 sets of data in two different files,say f1 and f2.
I want to create a excel sheet with two tabs whose names will be set at run time(different from excel name)
in a shell script, and the data will be written into those two tabs at run time.Any command in UNIX doing so?
I am... (7 Replies)
Discussion started by: Kishore_1
7 Replies
4. Shell Programming and Scripting
Hi everyone,
I want a shellscript code that takes an pdf as input and returns the data in the pdf into an excel sheet...
Thanks,
C10 (3 Replies)
Discussion started by: Carlton
3 Replies
5. Shell Programming and Scripting
There is a perl scriptwhich will read Excel sheet and create one file(.v) .
Excel sheet:::
A B C D
1 cpu_dailog 2 3 4
Perl will create the file(.v) like thsi :::
assert (cpu_dailog_iso ==2) ;
assert (cpu_dailog_reset ==3);
assert (cpu_dailog_idle... (3 Replies)
Discussion started by: naaj_ila
3 Replies
6. Shell Programming and Scripting
Hi folks,
I have a requirement in perl to print all the hyperlink from the spreadsheet(xlsx).
Spreadsheet contains few lines of hyperlink data (pic attached).
P.S. Hyperlink is behind the data and not visible in excel sheet directly.
Now using perl script I need to copy the hyperlinks in... (3 Replies)
Discussion started by: scriptscript
3 Replies
7. Shell Programming and Scripting
Hi,
I want to format Excel sheet through Unix script.
Format would mean bolding the data in the cell, adding clor to it etc.
Please help me if it is possible through Unix scripting?
Thanks,
Durga (2 Replies)
Discussion started by: Durga Prasad NK
2 Replies
8. Windows & DOS: Issues & Discussions
Hi,
I have a great doubt in Lotus Symphony Spread Sheet (Hope its similar to Excel)
Am new to this Lotus Symphony
Please tell me a formula to compare two columns in Excel (Lotus Symphony Spread Sheet)
The columns contain strings.
Eg., "Column E" and "Column AO" needs to be compared
Like... (1 Reply)
Discussion started by: Priya Amaresh
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
Hello,
I'm trying to write a script to export a txt file to excel. The text file is a delimited with commas
Example:
Report Date,12/12/2014
Report By, Person
Issue, Job Failed
I tried exporting as csv and mailed to my id. But if I open the csv file the data is coming in single... (6 Replies)
Discussion started by: annamalaikasi
6 Replies
LEARN ABOUT DEBIAN
excel::template::container::conditional
Excel::Template::Container::Conditional(3pm) User Contributed Perl Documentation Excel::Template::Container::Conditional(3pm)
NAME
Excel::Template::Container::Conditional - Excel::Template::Container::Conditional
PURPOSE
To provide conditional execution of children nodes
NODE NAME
IF
INHERITANCE
CONTAINER
ATTRIBUTES
o NAME
This is the name of the parameter to test. It is resolved like any other parameter name. (q.v. VAR for more info.)
o VALUE
If VALUE is set, then a comparison operation is done. The value of NAME is compared to VALUE using the value of OP.
o OP
If VALUE is set, then this is checked. If it isn't present, then '==' (numeric equality) is assumed. OP must be one of Perl the numeric
comparison operators or the string comparison operators. All 6 of each kind is supported.
Note: If you want to use < or <=, you must instead use < or <=. This is to make sure it will parse with XML::Parser. You should
not need to use > or >= instead of > and >=, respectively.
o IS
If VALUE is not set, then IS is checked. IS is allowed to be either "TRUE" or "FALSE". The boolean value of NAME is checked against IS.
CHILDREN
None
EFFECTS
None
DEPENDENCIES
None
USAGE
<if name="__ODD__" is="false">
... Children here
</if>
In the above example, the children will be executed if the value of __ODD__ (which is set by the LOOP node) is false. So, for all even
iterations.
AUTHOR
Rob Kinyon (rob.kinyon@gmail.com)
SEE ALSO
LOOP, VAR
perl v5.14.2 2010-06-17 Excel::Template::Container::Conditional(3pm)