05-15-2014 12:20 PM
I have 3 different 2d string arrays. How i can write all this to xls file with 1st array on 1st page, 2nd on 2nd page and 3rd on 3rd page?
05-15-2014 02:25 PM - edited 05-15-2014 02:29 PM
The report generation toolkit can do this. You can also achive the same thing with alot of manual work and the ActiveX calls to Excel. You could also get away with making it a TDMS file and then using the converter here to make it an Excel file. If you are using 2013 you may even be able to use the Write Measurement to File express VI which supports XLSX file formats.
EDIT: Okay so I don't think the Write Measurement to File express VI works on multiple workbooks.
Unofficial Forum Rules and Guidelines
Get going with G! - LabVIEW Wiki.
17 Part Blog on Automotive CAN bus. - Hooovahh - LabVIEW Overlord
05-15-2014 03:00 PM
I used NI Report Generation Toolkit and get diferent arrays on diferent pages. But data looks wierd. All what dont start from 0 is corrupted.
s
When its must looks like this
05-15-2014 03:08 PM
I wouldn't call that corruption. I'd call that a localization issue. It looks like you are using this in a country where a comma "," is used as the digit which signifies precision of a number and Excel might be expecting a period "." I'm not quite sure how to go about fixing this because I've never had to write reports for a language that doesn't use the period. I guess you could try to do a search and replace on , and . before sending it to Excel.
Unofficial Forum Rules and Guidelines
Get going with G! - LabVIEW Wiki.
17 Part Blog on Automotive CAN bus. - Hooovahh - LabVIEW Overlord
05-15-2014 04:33 PM - edited 05-15-2014 04:47 PM
But then why all with zero in begin with coma. And when i tried it with example vi its was good.
05-15-2014 04:37 PM
And array from strings, not dbl.
05-15-2014 04:52 PM
I think this is your problem: https://decibel.ni.com/content/docs/DOC-25387
05-15-2014 05:04 PM
did you succed to make each array in a different page of the same excel workbook,if yes can you show me the VI,because i have the same problem
thanks
05-15-2014 05:21 PM
Replacing coma dont help
I think its Excel issue, coz in first moment all looks good, but in next momet all document flashing and i get that.
05-15-2014 05:41 PM
are you getting each row in a different worksheet