06-22-2015 11:08 AM
06-22-2015 11:09 AM - edited 06-22-2015 11:11 AM
I found the solution, it has to do with my Excel region settings (I'm from Chile, Southamerica). The details are on this link: http://feedback.debitoor.com/knowledgebase/articles/248576-when-opening-csv-file-all-data-appears-in...
Thanks for your help.
06-22-2015 11:14 AM - edited 06-22-2015 11:15 AM
@Dennis_Knutson wrote:
If you use the default separator, it makes no sense to call it a csv file. Excel expects a comma as a separator when you do that. Call it a txt file or explicitly tell Excel to use a tab when you import the file.
Agreed. The example given is really a crappy example because it bypasses the array functionality of the spreadsheet VIs. You might as well just write those strings using Write to Text File and just add a line feed each time.
Cheers
--------, Unofficial Forum Rules and Guidelines ,--------
'--- >The shortest distance between two nodes is a straight wire> ---'
06-22-2015 11:14 AM
@Nathacarrasco wrote:
I found the solution, it has to do with my Excel region settings (I'm from Chile, Southamerica). The details are on this link: http://feedback.debitoor.com/knowledgebase/articles/248576-when-opening-csv-file-all-data-appears-in...
Thanks for your help.
Glad you got it figured out!
Cheers
--------, Unofficial Forum Rules and Guidelines ,--------
'--- >The shortest distance between two nodes is a straight wire> ---'