03-16-2013
Quote:
Originally Posted by
Durga Prasad NK
...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?
...
Not sure about a plain shell script, but you could use Perl to format Excel spreadsheets.
Search for the Perl module Spreadsheet::WriteExcel at cpan.org for the details.
Search for Spreadsheet::WriteExcel::Examples in the same website for example programs.
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. Solaris
Hello,
I have an information of about 100 odd file names which i have in my server. I need to attach this information in an excel sheet and sent to the concerned team.
I use uuencode for attaching a text file. But how will i have all the information in attachment. Please assist. Is there... (1 Reply)
Discussion started by: venkidhadha
1 Replies
3. 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
4. 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
5. 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
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. 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
8. 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
9. 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
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::writer::xlsx::package::xmlwritersimple
Excel::Writer::XLSX::Package::XMLwriterSimple(3pm) User Contributed Perl Documentation Excel::Writer::XLSX::Package::XMLwriterSimple(3pm)
NAME
XMLwriterSimple - Light weight re-implementation of XML::Writer.
This module is used internally by Excel::Writer::XLSX.
DESCRIPTION
This module is used by Excel::Writer::XLSX for writing XML documents. It is a light weight re-implementation of XML::Writer.
XMLwriterSimple is approximately twice as fast as XML::Writer. This speed is achieved at the expense of error and correctness checking. In
addition not all of the XML::Writer methods are implemented. As such, XMLwriterSimple is not recommended for use outside of
Excel::Writer::XLSX.
If required XMLwriterSimple can be overridden and XML::Writer can be used in its place by setting an "_EXCEL_WRITER_XLSX_USE_XML_WRITER"
environmental variable:
export _EXCEL_WRITER_XLSX_USE_XML_WRITER=1
perl example.pl
Or for one off programs:
_EXCEL_WRITER_XLSX_USE_XML_WRITER=1 perl example.pl
This technique is used for verifying the test suite with both XMLwriterSimple and XML::Writer:
_EXCEL_WRITER_XLSX_USE_XML_WRITER=1 prove -l -r t
SEE ALSO
XML::Writer.
AUTHOR
John McNamara jmcnamara@cpan.org
COPYRIGHT
X MM-MMXII, John McNamara.
All Rights Reserved. This module is free software. It may be used, redistributed and/or modified under the same terms as Perl itself.
LICENSE
Either the Perl Artistic Licence <http://dev.perl.org/licenses/artistic.html> or the GPL
<http://www.opensource.org/licenses/gpl-license.php>.
DISCLAIMER OF WARRANTY
See the documentation for Excel::Writer::XLSX.
perl v5.10.1 2012-04-02 Excel::Writer::XLSX::Package::XMLwriterSimple(3pm)