excel2txt reviews

cpanratings
 

RSS | Module Info | Add a review of excel2txt

excel2txt (0.04) ****

Hi there..as John said.. this is an excellent program that uses Spreadsheet::Parseexcel and it made my project work so easy.. but when you convert the same excel file second or third time it gives some odd names to the newly created files like :

C:\temp>perl excel2txt.pl test.xls
Processing test.xls
Writing 'C:\temp\test-people.txt'
Writing 'C:\temp\test-salaries.txt'
Done, processed 1 Excel file, created 2 data files.

C:\temp>perl excel2txt.pl test.xls
Processing test.xls
Writing 'C:\temp\test-people.txt-1.txt'
Writing 'C:\temp\test-salaries.txt-1.txt'
Done, processed 1 Excel file, created 2 data files.

C:\temp>perl excel2txt.pl test.xls
Processing test.xls
Writing 'C:\temp\test-people.txt-2.txt'
Writing 'C:\temp\test-salaries.txt-2.txt'
Done, processed 1 Excel file, created 2 data files.

like workbook-ws.txt-x.txt (x being no.)and so..

this can be changed to workbook-ws-x.txt by changing the line

( my $base = $out_file ) =~ /${suffix}$/; at line no.133
to

my $base =catfile($out_dir,$out_name);

outpu after changing the line:

C:\temp>perl excel2txt.pl test.xls
Processing test.xls
Writing 'C:\temp\test-people.txt'
Writing 'C:\temp\test-salaries.txt'
Done, processed 1 Excel file, created 2 data files.

C:\temp>perl excel2txt.pl test.xls
Processing test.xls
Writing 'C:\temp\test-people-1.txt'
Writing 'C:\temp\test-salaries-1.txt'
Done, processed 1 Excel file, created 2 data files.

C:\temp>perl excel2txt.pl test.xls
Processing test.xls
Writing 'C:\temp\test-people-2.txt'
Writing 'C:\temp\test-salaries-2.txt'
Done, processed 1 Excel file, created 2 data files.

P.S.(this won't change the way it works or efficiency but makes output file name readable)
Regards,
thehelios..

excel2txt (0.04) ****

This does something hackish. It turns an excel spreadsheet doc into flat text files.
You tell it what the source doc is, optionally what the output dir to spit out the text files to- that *will* be created.
One dot txt file is created for each table.

This is a pretty cool script- not much config options- but if you need to for example, index roughly what is in a bunch of excel files and just need some kind of idea what's in it- this is pretty cool.

excel2txt (0.04) *****

An excellent implementation of an excel2xxx filter program using Spreadsheet::ParseExcel.

This is the way Spreadsheet::ParseExcel programs should be written.

John.
--