How do I get the binary data file from the "High Speed Data Logger.VI" into an Excel spreadsheet? I don't want it in binary form- I want it converted to ASCII or some readable form.

uscmagz · ‎05-07-2004

I am using Labview 6.1. ActiveX isn't working on the computer I'm using so I can't use that method. Also, do I have to account for the header text at the top?

I have seen a few posts somewhat related to this topic but they have either not helped, or I don't understand the answers given. (So please don't link to another if you don't mind). Thanks for your time!!!

dan bookwalter · ‎05-07-2004

take a look at the high speed data reader.vi... you shoul dbe able to adapt that to do what you want...

Dan

uscmagz · ‎05-07-2004

I took the High Speed Data Reader.VI and added the Write to SpreadSheet.VI. Shouldn't that be able to write the converted data to file? What am I overlooking here. I am attaching a screenshot!

THANK YOU.

Dennis_Knutson · ‎05-07-2004

That should work. Please explain what the problem is. Is the file empty, formatted wrong, or what? Kind of hard to help when you don't say what's broken.

rolfk · ‎05-07-2004

uscmagz wrote:

> I took the High Speed Data Reader.VI and added the Write to
> SpreadSheet.VI. Shouldn't that be able to write the converted data to
> file? What am I overlooking here. I am attaching a screenshot!

Watch out with Excel. As you use the High Speed Recorder to create the
original file you will most probably create quite large files quite
fast. Translating that into an ASCII spreadsheet would work fine in
LabVIEW but Excel has a limitation that it can't open spreadsheet files
above a certain number of rows. I do believe this is around 64k rows but
it does a little vary depending on the number of columns you have.

Rolf Kalbermatter

Rolf Kalbermatter My Blog

DEMO, Electronic and Mechanical Support department, room 36.LB00.390

JD · ‎05-07-2004

If you need to you can download a trial version of Quatro Pro. It will
take over a million rows.

Doug

RolfK wrote:
> uscmagz wrote:
>
>> I took the High Speed Data Reader.VI and added the Write to
>> SpreadSheet.VI. Shouldn't that be able to write the converted data to
>> file? What am I overlooking here. I am attaching a screenshot!
>
>
> Watch out with Excel. As you use the High Speed Recorder to create the
> original file you will most probably create quite large files quite
> fast. Translating that into an ASCII spreadsheet would work fine in
> LabVIEW but Excel has a limitation that it can't open spreadsheet files
> above a certain number of rows. I do believe this is around 64k rows but
> it does a little vary depending on the n
umber of columns you have.
>
> Rolf Kalbermatter

uscmagz · ‎05-10-2004

It's not broken. Please see attachment. Thank you.

Lauren

LabVIEW

How do I get the binary data file from the "High Speed Data Logger.VI" into an Excel spreadsheet? I don't want it in binary form- I want it converted to ASCII or some readable form.

How do I get the binary data file from the "High Speed Data Logger.VI" into an Excel spreadsheet? I don't want it in binary form- I want it converted to ASCII or some readable form.

Re: How do I get the binary data file from the "High Speed Data Logger.VI" into an Excel spreadsheet? I don't want it in binary form- I want it converted to ASCII or some readable form.

Re: How do I get the binary data file from the "High Speed Data Logger.VI" into an Excel spreadsheet? I don't want it in binary form- I want it converted to ASCII or some readable form.

Re: How do I get the binary data file from the "High Speed Data Logger.VI" into an Excel spreadsheet? I don't want it in binary form- I want it converted to ASCII or some readable form.

Re: How do I get the binary data file from the "High Speed Data Logger.VI" into an Excel spreadsheet? I don't want it in binary form- I want it converted to ASCII or some readable form.

Re: How do I get the binary data file from the "High Speed Data Logger.VI" into an Excel spreadsheet? I don't want it in binary form- I want it converted to ASCII or some readable form.

Re: How do I get the binary data file from the "High Speed Data Logger.VI" into an Excel spreadsheet? I don't want it in binary form- I want it converted to ASCII or some readable form.