only 16-bits' worth of rows in an Excel spreadsheet

[guqunlin]

I write the data to excel sheet but it size not enough when the measuring long time?who can solve this problem?

[tarheel_hax0r]

Remember, you only get 16-bits' worth of rows in an Excel spreadsheet:

http://www.google.com/search?q=maximum+65536+rows+excel

As recently as 1996, you got only 14-bits' worth [16384].

I guess that means that M$FT is due to upgrade to 18-bits at any moment now - in fact, the suspense is so thick you could cut it with a knife!

[SG_ENGINEER]

Hi

Truncate at 65536 and loop again to write to the next excel file or excel tab. alternately can write to .txt with comma delimited to be opened again by excel portions by portions.

Goy

[guqunlin]

how to truncated the file detail?

[chilly_charly]

Your problem may be a false problem : LabVIEW can save files of virtually any size. So the problem is not with LabVIEW, but with Excel.

Are you sure you really need Excel ?

If you have calculations to do on the stored data, why don't you do them with LabVIEW ? LavVIEW is probably 100 time faster than Excel for number crunching.

If you just need to visualize your data, why don't you do it with LabVIEW ?

Even if you wanted absolutely to get Excel style graphs, I'm not sure that plotting more than 65000 points would be usefull : with a standard laser printer, at 400 dots/inch, and assuming 3 points/dot position, such a graph would be 65000/(3x400) = 54 inches wide ! Therefore a solution could be to decimate or to extract the relevant portions of your file before opening it with Excel...

May be you should explain what your problem really is, so someone here could efficiently help you ?