08-17-2010
Try out the Win32::OLE Perl module at CPAN.
Win32::OLE - search.cpan.org
Values in the 2nd column would be: $sheet->Cells($row,2)->{Value}
tyler_durden
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am running a script, the output of which is needed to be filled in .xls file. I am doing this manually now, i mean I am writing the output of the script to Excel file manually. How to redirect the output of the script to .xls file? Please help me out!!!
Thanks much,
Scriptlearner. (6 Replies)
Discussion started by: scriptlearner
6 Replies
2. Shell Programming and Scripting
Hi everybody
I have some problems with PERL programming.
I have a file with two columns, both with numeric values.
I have to extract the values > 50 from the 2nd columns and sum them among them.
The I have to sum the respective values in the first column on the same line and, at the end, I... (6 Replies)
Discussion started by: m_elena
6 Replies
3. Shell Programming and Scripting
Hi Everyone!
I have a problem in reading a specific column from .xls file using perl language and then manipulating on given criteria.
Detailed Description of the problem::
I have one .xls file, in which i have to populate two columns based on Period_date column which is in same file.
My... (1 Reply)
Discussion started by: kvth
1 Replies
4. Shell Programming and Scripting
Hello Gurus
I have a source file which has the first line as header and the rest are the records
I need to extract the first column from the second line to extract a value
I/P
... (7 Replies)
Discussion started by: Pratik4891
7 Replies
5. Shell Programming and Scripting
Hi all,
I want to read some specific rows & columns in the .xls file with my script to get the data to be manipulated. Now, I can read the .xls file correctly & i can go to the specific sheet that I want but i have a problem to specify the specific rows & columns. I mean, I want to get the info... (0 Replies)
Discussion started by: Yohannita
0 Replies
6. 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
7. Shell Programming and Scripting
Hi,
I am trying with the below Perl one-liner using regular expression to extract the first and second column of a text file:
perl -p -e "s/\s*(\w+).*/$1/"
perl -p -e "s/\s*.+\s(.+)\s*/$1\n/"
whereas the text file's data looks like:
Error: terminated 2233
Warning: reboot 3434
Warning:... (3 Replies)
Discussion started by: royalibrahim
3 Replies
8. 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
9. Shell Programming and Scripting
Hi,
I want to extract first column from a file and redirect the output to another file in perl.
I am able to do this from command line by executing below commands.
perl -anle 'print $F' Input.dat > Output.dat
perl -ne '@F = split("\t", $_); print "$F\n";' Input.dat > Output.dat
perl -anE... (7 Replies)
Discussion started by: Neethu
7 Replies
10. Shell Programming and Scripting
Hi all.
I am working on the below requirement of generating .xml file from .xls file which i have , can someone please help me or in writing the perl script for the same:
The xls file format is as below which has two columns and number of rows are not fixed:
Fixlet Name ... (12 Replies)
Discussion started by: omkar.jadhav
12 Replies
LEARN ABOUT DEBIAN
runxlrd
RUNXLRD(1) General Commands Manual RUNXLRD(1)
NAME
runxlrd - extract data from Microsoft Excel spreadsheet files
SYNOPSIS
runxlrd [options] command [input-file-patterns]
DESCRIPTION
This manual page documents briefly the runxlrd command.
runxlrd offers a commandline interface to the Python xlrd module; it extracts data from Microsoft Excel spreadsheet files.
OPTIONS
-h, --help
Show summary of options and exit.
-l logfilename
Contains error messages.
-v verbosity, --verbosity=verbosity
Level of information and diagnostics provided.
-p pickleable, --pickleable=pickleable
1: ensure Book object is pickleable (default); 0: don't bother.
-m mmap, --mmap=mmap
1: use mmap; 0: don't use mmap; -1: accept heuristic.
-e encoding, --encoding=encoding
Encoding override.
-f formatting, --formatting=formatting
0 (default): no fmt info 1: fmt info (all cells) 2: fmt info (margins trimmed).
-g gc, --gc=gc
0: auto gc enabled; 1: auto gc disabled, manual collect after each file; 2: no gc.
-s onesheet, --onesheet=onesheet
Restrict output to this sheet (name or index).
COMMANDS
Valid commands are
o dump
o count_records
o version
o hdr
o ov
o show
o 2rows
o 3rows
o bench
o names
o name_dump
o labels
o xfc
o hotshot
o profile
See the xlrd API documentation for the meaning of these commands.
EXAMPLES
To show the first, second and last rows of each sheet in each file, run
$ runxlrd 3rows *blah*.xls
Run
$ runxlrd -e koi8_r 3rows myfile.xls
to explicitly pass the needed codepage to xlrd, e.g. if the codepage record is missing, or if it exists but is wrong.
SEE ALSO
The xlrd API documentation, shipped in the file xlrd.html.
The xlrd website <http://www.lexicon.net/sjmachin/xlrd.htm>.
AUTHOR
runxlrd was written by John Machin.
This manual page was written by Joost van Baal <joostvb+debian@uvt.nl>, for the Debian project (but may be used by others).
xlrd 0.6.1a4 2007-05-24 RUNXLRD(1)