How i can write 3 different 2d arrays to different Excel pages

[olderon]

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?

[Hooovahh]

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.

[olderon]

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

[Hooovahh]

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.

[olderon]

But then why all with zero in begin with coma. And when i tried it with example vi its was good.

[olderon]

And array from strings, not dbl.

[stephencox]

I think this is your problem: https://decibel.ni.com/content/docs/DOC-25387

[achfire]

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

[olderon]

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.

[achfire]

are you getting each row in a different worksheet