0

Hi I am generating a summary of useraccounts present on around 160 linux servers. I am retrieving the data through a script and storing around 160 csv files in a directory. I want to import all these 160 csv files to one excel worksheet. Can someone please tell me how to acieve this ?

2
Contributors
1
Reply
8
Views
4 Years
Discussion Span
Last Post by 2teez
0

Hi ashiiiish,

Consider using these modules from CPAN namely:
1. Text::CSV_XS
2. Spreadsheet::WriteExcel

From the directory read each of the CSV using Text::CSV_XS or Text::CSV,
then write to a new Excel Sheet created by Spreadsheet::WriteExcel.

Check examples these modules except you have sample of what to share here.

Hope this helps.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.