Answer to Question #39744 in Perl for Ahmed

Question

i have a .dat file(15 MB) which is basically like text file which has delimiter( | ) separated values(like comma,pipe separated values).I would like this to write these records in an excel file .I am using the Spreadsheet::WriteExcel module and it works fine for small number of records.But I want to generate a single excel file for more than 38000 records.In this case it does not work because of memory management issues and i have to do it using a single excel workbook.Can you suggest some better method.

Answer 1

Dear customer,
Unfortunately, your question requires a lot of work and cannot be done for free.
Please submit it with all requirements as an assignment to our control panel and
we'll assist you.