Exporting Data to Excel

[GerdW]

Hi Jon,

here's a picture (of your vi, containing some Rube-Goldberg code) to illustrate Raven's answer... Please give us the correct vi!

Why not change your sampling schem from "10 samples 1000 times a second" to "10000 samples once a second"?

Do you really think the DAQ assistent needs only 1ms to perform all tasks needed? The assistent has to: open & initialize the DAQ device, read the samples, cleanup & close the device! The express vis are nice, but not very fast (and need a lot of memory too...). It's (mostly) always better to do the same using low(er) level functions...


Message Edited by GerdW on 03-27-2008 09:17 AM

[jh5638]

I told you it had been a long day... A case of doing lots of modifications without saving them!

I have attached the latest VI where I have changed your cleaned up VI to include how I was trying to write the data to the spreadsheet. This is only one out of three ways I've tried (though none seem to work!)

So using the lower level VI's, is there a tutorial for these? I might have a play in a minute!

Any changes you can see would be a great help!

Thanks

Jon

[GerdW]

Hi Jon,

you should append to the file, when you need all values... There's an additional input at the file-write!

You should also use "Build path" and utilize "Format into String" more extensively.

[jh5638]

Sorry I am still confused, I have looked over your VI (and thanks for the improvements) but can't see a change to the fundamental issue of the data loss/writing? I see you have changed it to append to new file (or the other way round) however I am still only getting roughly fifty results through to the spreadsheet? Where am I going wrong? Hopefully its something simple?

Thanks

Jon

[GerdW]

Hi Jon,

I have stripped the attachment to show only the relevant part: generating dummy data and saving to text file...
For me the data is appended to the file, quickly generating a lot of values...

When this runs fine for you too, then the DAQ part has problems:
It seems you don't get as many readings as you think you should. Use the highlight tool and some probes to check this

[Thermocoupler]

Hello, I'm having a problem as well.

I'm using 2-NI9211, interfaced with 2-NI USB-9162 modules measuring 8 thermocouple temperatures.

But I've been trying for quite sometime to wrap my head around exporting the data to excel or at least storing it to a .csv file.

Could someone please help point me in the right direction? Thank you

[Dennis_Knutson]

duplicate post