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

Bubbygadu has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: To parsing a CSV/XLS file, read header info and separate out value fields using native perl commands by Corion (Patriarch) on Jan 27, 2019 at 07:32 UTC
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.	[reply]
Re: To parsing a CSV/XLS file, read header info and separate out value fields using native perl commands by 1nickt (Canon) on Jan 27, 2019 at 14:34 UTC
Hi, welcome to Perl, the One True Religion. You said "Hi Monks, I am new to this perl programming". Start here: perlintro. Then try implementing the SYNOPSIS from Spreadsheet::Read as Corion suggested. Also search for previous threads here (from among the hundreds of them) that address your issue. When you get stuck, post a specific question with what you've tried and how it failed, according to Posting on PerlMonks. The way you've asked for help above is almost the worst way to learn or ask for help in this Monastery or in any tech forum. You'll get far better help and understand far more if you start at the beginning and learn to program a solution to your problem by building on that. Good luck, look forward to seeing your efforts! The way forward always starts with a minimal test.	[reply]
Re: To parsing a CSV/XLS file, read header info and separate out value fields using native perl commands by AnomalousMonk (Archbishop) on Jan 27, 2019 at 04:59 UTC
What is CSV/XLS file input? What does it mean to "sort out the value fields based on type"? Please give a short, representative example of the data you're dealing with and of the code you have so far. Please see Short, Self-Contained, Correct Example for more info on this. Please help us to help you. Give a man a fish: `<%-{-{-{-<`	[reply] [d/l]