07-17-2012 07:38 AM - edited 07-17-2012 07:41 AM
I have some text files and I want to export them into 1 excel file.Let's say text files are like
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
is it possible?
PS:I have downloaded and installed Spreadsheet-WriteExcel-2.37 over my unix perl env.
07-18-2012 05:21 AM
Yes, it is possible.
See the documentation of the Spreadsheet::WriteExcel perl module:
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.