1.11M Members

Import .csv files

 
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 ?

 
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.

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: