10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello All,
I need to execute around 15 queries after which all data should come in Excel format.
Executing 15 queries is not a problem.
Problem is how to present/put data in excel.
kindly suggest me how to start, what to study or what should i do.
thanks, (1 Reply)
Discussion started by: shubham8787
1 Replies
2. Shell Programming and Scripting
Hi,
I am using HP-UX.
I have an output log file which gives me server statistics.
I want to export the contents of the file(last 100 lines) using tail command and then save it into an excel file in my local machine.
The server statistics should be collected every 3 hrs.
So, i wanted the idea... (1 Reply)
Discussion started by: harshaganapathy
1 Replies
3. Shell Programming and Scripting
Hello everyone I'm new here and this is my first post so first of all I want to say that this is a great forum and I have managed to found most of my answers in these forums : )
So with that I ask you my first question:
I have an excel file which I saved as a csv. However the excel file... (3 Replies)
Discussion started by: Spunkerspawn
3 Replies
4. Shell Programming and Scripting
Hi All,
I have created a Unix Shell script whch creates a *.csv file and export it to Excel.
The problem i am facing is that Users wants one of the AMOUNT field in comma separted values. Example :
if the Amount has the value as 3000000 User wants to be in 3,000,000 format.
This Amount format... (2 Replies)
Discussion started by: rawat_me01
2 Replies
5. Shell Programming and Scripting
Friends...This is the first time i am trying the report generation using shell script... any suggestions are welcome.
Is there a way to set the font size & color when i am exporting the data from unix shell script as a CSV file ?
The following sample data is saved as a .csv file in the... (2 Replies)
Discussion started by: appu2176
2 Replies
6. Shell Programming and Scripting
Can someone help me out to export awk output to excel file in different rows? Plzzzz its urgent...:( (4 Replies)
Discussion started by: goutam_igate
4 Replies
7. Shell Programming and Scripting
Hi,
I have a shellscript that produces a csv that can be opened in Microsoft Excel. It has two columns and about 10 rows in each column, so only twenty cells (at the moment). When the user opened the csv, I wanted it so autofilter was already turned on in columns A1 and B1 (and potentially C1,... (1 Reply)
Discussion started by: rainemaida
1 Replies
8. UNIX for Dummies Questions & Answers
I was able to convert my csv file in Unix to xls. I would like to export the converted xls file to a windows environment. I have to manually connect using the following below:
ftp: 192.x.x.x -> username/pass -> cd -> mget *.xls and then confirm.
Could I automate this process into a shell... (4 Replies)
Discussion started by: ravzter
4 Replies
9. UNIX for Advanced & Expert Users
How can we export a file in unix with certain number of columns to an excel sheet.
It's very useful in time saving...... (3 Replies)
Discussion started by: bishweshwar
3 Replies
10. Solaris
i want to export a database (full schema) so that I can import the database to a windows 2000 server. The database is sitting on a unix-sun solaris box ver 8.. What are the commands...
I am a bit rusty at unix at the moment!
Cheers
E (4 Replies)
Discussion started by: etravels
4 Replies
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)