Import .csv files

[ashiiiish]

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 ?

[2teez]

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.