Hi,
I'm not a perl scripter. I got a project tossed at me and a requirement is to convert a csv to xls. I found your Spreadsheet::WriteExcel solution. I got it working. I created a script using the documentation that creates a 3 tab Excel file with most of the formatting I need.
But I'm stuck trying to escape commas that are in my csv file. One of the columns in my csv files will contain commas. I've tried using field quotes. I've tried using pipes instead of commas. Both blew up on me. Can anyone assist me?
Tom