data file too large to save in excel

[sheck]

Hi,

I am trying to save my data to an Excel file, but I keep getting a message stating that "not all data was saved".  Does anyone know how to increase the storage size or a way around this?  I saw in the archives that someone mentioned using ".xml" files instead.  But, I haven't had much luck with that either.

Thanks for any help!

Sherri

[Joe_H]

If your data is more than 65536 lines then excel will not accept all of it. I do not know about XML but you could take a look at DIADEM.

[sheck]

Thanks for your response.  What is DIADEM?

Sherri

[Joe_H]

DIADEM is a national instuments sofware product.

You can find more info here.

[sheck]

I see.  I was hoping to find a more immediate and less expensive route...............................  thanks, though.

sherri

[DavidT]

Is there any reason why you need to save to excel. Why not just save to spreadsheet file (e.g. *.txt file)?

You can (i think) use Activex to save your data to different sheets within your excel which would allow you more than the 65000 lines. Or you can save to multiple files.

Hope this helps

[Joe_H]

You could also try the OpenG vi's for large files @ openG.com. Download the commander and you will get a whole new world of labview.

[RaezenKane]

That's www.openG.ORG, by the way.

[DFGray]

If you are saving waveforms, try NI-HWS.  It is free on the driver CD (Aug 2004 and later).  The underlying format is HDF5, a completely open and self-describing 64-bit file format.  Your only data size limit will be your disk drive free space.  Search this forum for more details, if you need them.  HDF5 details can be found on their website.

[sarmin]

Hi,

wondering why u want to save the data in excel. instead u can save the data in csv format (comma separated file). data lines bigger than 65535 would need to be sectioned into two or more files. the csv file can then be opened just like normal excel file. this would lessen the complication of writing directly into excel file. otherwise, more expensive route such as buying labview add-on software would be the alternative.

best wishes,