array size limit

[sdflow]

I have continuous running data with a time stamp that gets stored in an 2D array. The array gets printed in an excel sheet using 'append Table to Report.vi' after the data are collected. The problem I have is that the excel table ends at the 3247the data point. Is there a limitation in the array size? I use DBLs in the array. Thanks for your help...

SDFLOW

[mikeporter]

No it's a limitation in Excel. I understand newer versions have a higher limit.

Mike...

[Nick_CH]

Hello,

In LabVIEW, an array can have one or more dimensions and as many as (2^31) – 1 elements per dimension.
The limitation of Excel is 65536 elements/columns.

I make a small test with the following VI and I can give 65536 element per dimension to excel.

Best regards,
Nick_CH

[sdflow]

I am not sure...because there is more than 3247 lines in excel. I am pretty inexperienced in LV, is there a better way to collect data and display them in excel?

Thanks fo your suggestions...

SDFLW

[sdflow]

Hi Nick_CH!

I tried your test app, and it printed all lines... . Could it be the local variable that limits the size?

SDFLOW

[GuenterMueller]

Hi SDFLOW.

LabVIEW does not limit the amount of memory written to the local variable by cropping data or writing an imcomplete set of the data.

If the amount of data exceeds the limit you will get a message like "Not enough memory to complete the operation .." or simply "Memory full ..." or something like this.

Best regards, Guenter