Issues while write Excel using activeX - data missing after column IV

[ELI2011]

Data size is about 400 (col) x 100 (row), while save it to excel using ActiveX, it cut the data only with 256 column, other data from IW .... are missed.

how to fix this in LabVIEW? I save the file with .xlsx format.

[ELI2011 · Accepted solution]

Pls ignore this question as I already fixed the issue, thank you all!

[Bob_Schor]

The answer is that you don't use ActiveX, but use the Report Generation Toolkit.  The Snippet shows a 100 x 400 array with cell (i, j) having the value 1000*i + j (makes it easy to see that the numbers are in the correct cell).  Cell A100 contains 99000, cell OJ100 contains 99399.  The program (which only opens and fills Excel -- doesn't count the time to actually write the file to disk) takes less than a second.

Bob Schor

[RavensFan]

To help people who might see your post in the future, tell us how you solved your problem.  Then mark that post as the solution.  ("I fixed it myself" doesn't qualify as a solution.)

[ELI2011]

the previous subVI was for Excel 2003, which only support 256 columns, now it works fine for Excel 2007 after adjust the number.