Spreadsheet-ParseExcel - Re: xls2csv How can I change separator to semicolon?

Posted on Wed May 30 14:40:49 2007 by jochenhayek in response to 5267 (See the whole thread of 2)
Re: xls2csv How can I change separator to semicolon?
Can you see this line in the code:
print CSV join(',', @row), "\n";
Change ',' to ';', if you really want the semicolon. The "if" statement above actually attempts to protect the embedded commas and double-quote characters, and you would have have to swap the comma there with a semicolon as well. And the "open" function call further above does not deal with UTF8 Excel files, so I changed it to look like this:
open(CSV , '>:utf8' , "$prefix-Sheet$index.csv");
Write a response