topic Perl script help in Operating System - HP-UX

Perl script help

cemokam — Tue, 17 Jul 2012 14:41:45 GMT

Hello Forum,

I have some text files and I want to export them into 1 excel file.Let's say text files are like

a.txt

b.txt

c.txt

d.txt

What I want to get these text files into an excel file called as "final.xls" and When I open it I want to see the sheets as

a.txt--->sheet1

b.txt--->sheet2

c.txt---->sheet3

d.txt---->sheet4

is it possible?

PS:I have downloaded and installed Spreadsheet-WriteExcel-2.37 over my unix perl env.

Re: Perl script help

Matti_Kurkela — Wed, 18 Jul 2012 12:21:42 GMT

Yes, it is possible.

See the documentation of the Spreadsheet::WriteExcel perl module:

http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.37/lib/Spreadsheet/WriteExcel.pm

The Quick Start lists 3 steps required when creating an Excel file:

create a "workbook" (= the Excel file) using the new() method
create a worksheet in the workbook using the add_worksheet() method
write() to the worksheet. (write_row() or write_col() might be useful too).

When you want to create another worksheet, simply perform the step 2 again using the original workbook object. It will give you a new worksheet object, referring to the next worksheet.