in reply to To parsing a CSV/XLS file, read header info and separate out value fields using native perl commands

Have you already looked at Text::CSV_XS and Spreadsheet::ParseExcel and Spreadsheet::ParseXLSX? These implement reading for CSV and Excel files. A good all-in-one interface for them is Spreadsheet::Read.

  • Comment on Re: To parsing a CSV/XLS file, read header info and separate out value fields using native perl commands