09-16-2012
Perl: module to convert xlsx to csv
Is there any perl module to convert .xlsx file(excel sheet 2007) to a csv file.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Need urgent help.
I want to use this module Convert::IBM390 but we dont have admin rights on our Unix box so can't login as root.
Is there any other way where we can use this module or can it be converted to a program.
Please help. (1 Reply)
Discussion started by: er_ashu
1 Replies
2. Linux
Hi all,
I am working on USB data monitoring on Fedora Core 9. Kernel 2.6.25 has a built-in module (the one that isn't loadable, but compiles and links statically with the kernel during compilation) to snoop USB data. It is in <kernel_source_code>/drivers/usb/mon/.
I need to know if I can... (0 Replies)
Discussion started by: anitemp
0 Replies
3. Shell Programming and Scripting
Hi all perl gurus,
I need your help to get the desired output in perl.
I have a file which has text in it in the format
Connection request start timestamp = 12/08/2008 00:58:36.956700
Connect request completion timestamp = 12/08/2008 00:58:36.959729
Application idle time ... (10 Replies)
Discussion started by: azs0309
10 Replies
4. Programming
Hi,
I am new to perl. I want to split excel 2007 file to csv. every formula should be evaluated on each field.
Plz help me (1 Reply)
Discussion started by: malikshahid85
1 Replies
5. Shell Programming and Scripting
Hi All,
I need a solution to convert my .xlsx file which has lot of worksheet, convert to separate csv file. Is there any shell script to do this? I can’t use excel macro to do this, since it was password locked.
I need the csv output as an input to my shell script. (1 Reply)
Discussion started by: ranjancom2000
1 Replies
6. Shell Programming and Scripting
Hi Folks,
I have written a perl script that reads data from excel sheet(.xls) using Spreadsheet::ParseExcel module. But the problem is this module doesn't work for excel sheets with extension .xlsx.
I have gone through Spreadsheet::XLSX module with which we can read from .xlsx file directly.... (1 Reply)
Discussion started by: giridhar276
1 Replies
7. Shell Programming and Scripting
I have an Excel 2007 excel sheet on windows machine and using
Spreadsheet::XLSX I had written a script to read the excel sheet and was successful.
My requirement is I need to generate another excel sheet from the old excel 2007 sheet on unix machine.
Now is it possible to read the excel... (2 Replies)
Discussion started by: giridhar276
2 Replies
8. Shell Programming and Scripting
Hi All,
I've got in a situation where I need to convert .xlsx or .xls formatted files into simple text file or .csv file.
I've found many options but doing this using PERL script is the best way I believe.I'm in AIX box.
Perl code should have 2 params while running. i.e
perl... (1 Reply)
Discussion started by: manab86
1 Replies
9. Shell Programming and Scripting
Hi
I am trying one perl script to convert xlsx to xls file but could not able to get all the rows and columns in the xls file . This scriptFILE is basically to convert XLSX to CSV .. I am tweaking the script to convert XLSX to XLS file also
#######################FILE... (3 Replies)
Discussion started by: kshitij
3 Replies
10. Shell Programming and Scripting
Team ,
I am new to perl. Can someone help me out to convert LDIF file to csv format using perl logic ?
LDIF file format contains values :
ID : name/Bose-IND/ORD,cu-150,ou=ends
Connection_Time: 02:12:54 EST
LDAP: yes
Link: ABC Home Page - ABC.com
Expected outcome should with column... (0 Replies)
Discussion started by: Perlbaby
0 Replies
XML2(1) General Commands Manual XML2(1)
NAME
xml2 - convert xml documents in a flat format
2xml - convert flat format into xml
html2 - convert html documents in a flat format
2html - convert flat format into html
csv2 - convert csv files in a flat format
2csv - convert flat format into csv
SYNOPSIS
<xml2|2xml|html2|2html|csv2|2csv> > outfile < infile
DESCRIPTION
There are six tools. Except csv2 and and 2csv they don't take any command-line arguments. They are all simple filters which can be used to
read files from standard input in one format and output it to standard output in another format.
The flat format used by the tools is specific to these tools. It is a syntax for representing structured markup in a way that makes it
easy to process with line-oriented tools. The same format is used for HTML and XML; in fact, you can think of html2 as converting HTML to
XHTML and running xml2 on the result; likewise 2html and 2xml. (Of course, this isn't how the implementation works.)
SEE ALSO
This program does normally not include any documentation in form of manpages. However it has a real excellent documentation online with a
lot of example. In fact this manpage was based on this documentation.
Please find it on:
http://dan.egnor.name/xml2/ref
Examples can be found here:
http://dan.egnor.name/xml2/examples
AUTHOR
xml2 was written by Dan Egnor.
This manpage was written by Patrick Schoenfeld <schoenfeld@in-medias-res.com> for the Debian project, but may be used by others under the
same terms as xml2 is distributed.
BUGS
Bugs can be reported through the Debian Bug tracking system.
7h february 2008 XML2(1)