1,105,352 Community Members

Import .csv files

Member Avatar
ashiiiish
Light Poster
36 posts since Jun 2011
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
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 ?

Member Avatar
2teez
Posting Whiz in Training
224 posts since Apr 2012
Reputation Points: 40 [?]
Q&As Helped to Solve: 38 [?]
Skill Endorsements: 0 [?]
 
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 three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: