doubt regarding writing to spreadsheetfile.vi

[sukumar]

oh sorry..now i am getting output. i dont what happened there but I am having problem with the last channel..its not responding to any input at all.. and also u had mentioned the time elapse function..i want to use the start button instead of it and also the spreadsheet file look like this. what are all the "#########".

[Dennis_Knutson]

It looks like when I dropped the case statement on the block diagram, the last chart got placed inside. Just move it out.

I placed the elapsed time function there to give you an idea how you could set it to write at an interval. If you want to write whenever you click a button, wire the button to the case statement. If you want to save every waveform that you acquire, don't use a case statement.

I have no idea what you mean by ########. My guess is that you are not importing it into Excel correctly. You gave it a .csv extension but it's not a .csv file.

[GovBob]

The ###### might be there because there is more data in the cell then it can properly display. Try increasing the cell size.

[sukumar]

I am able to get get multiple data values but the time is all the same that is 18:19 as u see in the file I attached. what that mean..and I am trying looking at several examples for doing how to make start button for recording data but was unable to do..can anyone give me an idea. Thanks.

[Dennis_Knutson]

When I run Export Waveforms to Spreadsheet, I get a header and then i  column 1, a timestamp with month/date/year hours:minutes:seconds. I really don't want to look at an Excel file. Look at the original file. It's a text file. Use Notepad.

I already said you could simply connect a front panel Boolean to the case structure. You have not given any kind of description of what this 'Start' button is supposed to do and why you are having such a difficutl time with it.. You might want to go back and review some of those tutorials you were given in an earlier post.

[sukumar]

Actually what I was asking before was, the time of recording is all same. The data it recorded I think was at different time instants but the time it displays is one single time for all values. And regarding start button, as u said earlier that if you want to save data for every second of waveforms dont use case structure, so I am thinking of any other structure. that will make it. The start button I needed is for recording the data. It means, it should start recording only when I press the start button. And i tried putting the start button for the case structure but it didn't work I mean there is no data coming in the graphs. Please suggest me some if u have got any ideas. Thanks.

[Dennis_Knutson]

The time of recording is not the same when I look at a file. It is exactly what I already said - hours:minutes:seconds. You do realize that the setting in the VI I posted was for recording once a minute don't you?

You must have done something very wrong with wiring up the start button. If you would simply replace the Elapsed Time function with a Boolean, there is no way it would affect the display of the data.

[sukumar]

I replaced the elapsed time with the boolean, then it asks for multiple saves. Please look into it.

[Brian_R]

The Elapsed Time express VI will cause a save every 60 seconds.  If you do not specify a path for File Path, the dialog box will pop up and ask for a file path every 60 seconds.  I think this is what you may be seeing.

[Dennis_Knutson]

It will only ask for a file name if you don't provide one. That's why there is a front panel path control. It was in one of your earlier VIs that you added this. If you don't want to use the path control, use a shift register. You will get asked for a path the first fime and then after that, it will use the seleted file. Again, this is pretty basic stuff.

You did not replace anything with anything else in the file you posted. It has the Elapsed Time function.