BladeSystem Forums have moved here
To make BladeSystem information easier to find, we have moved the BladeSystem forums here, to Servers and Operating Systems.
Showing results for 
Search instead for 
Do you mean 

Perl script help

Highlighted
Occasional Contributor

Perl script help

[ Edited ]

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.

 

 

 

1 REPLY
Honored Contributor

Re: Perl script help

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:

  1. create a "workbook" (= the Excel file) using the new() method
  2. create a worksheet in the workbook using the add_worksheet() method
  3. 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.

MK