Member Avatar for 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 ?

  • 2 Contributors
  • 1 Reply
  • 186 Views
  • 4 Hours Discussion Span
  • Latest Post Latest Post by 2teez
Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.