Time Stamped Sreadsheet

[mimran]

Hi

I have managed to generate time stamped excel file which works fine only for only single logging. If I have to do multilpe loggings, then my program does not create a new file. So can anybody have a look at my file and help me out why is it not creating new file everytime when Logging button is pressed

Thanks 

[MikeS81]

Hi mimran,

sorry i can't open your vi at the moment. It should work if you create a new file inside of the button event, or a parallel process triggered from the button press event. You should also generate the filename everytime again, otherwise you overwrite the old file.

Mike

[Dimitrios]

Hi mimran,

I have LV 8.6 can you save your VI as 8.6 and post it again to have a look.

Dimitrios

[mimran]

Hi

Although I am generating seperate file names but I have founf that one of my while loop is not being stopped. Any idea how to stop the final while loop where file is being written to excel file. I have also converted the VI to 8.6 now.

Thanks

[mimran]

Thanks Guys for your help. National Instuments technical support have solved my problem.

[Dimitrios · Accepted solution]

Hi mimran,

Glad to hear you short it.

You have wired a False constant to both your while loops so that's why it never stops any of your loops.

And your code will stuck on the inner while loop so a new file will not generated when you log for 2nd time.

I used an event case so every time your Boolean goes true it fires an event that will change your filename succesfully. Also i wired you outer bottom while loop to your stop button and used a local variable to stop the top while loop, that way both loops stop when stop button is pressed.

What did the NI guys suggested by the way?

Regards

Dimitrios

[mimran]

Hi Dimitrios,

I have managed to do same thing by changing loop condition to continue if true using Boolean local variable. Anyhow that problem is solved.  Thanks

How I can change  style of Columns Headings to Bold.At the moment write to spreadsheet function doesnt take any style parameter.

[Dimitrios]

Under Programming---->Report Generation Pallete i have a VI under the Excel Specific VI's that is doing that.

Have a look on the Help image below.

[arrowminds]

Hi,

I am working on a project which involves logging of different calculated real time values to excel file and then insert graph in same previous saved file.

So at the moment, I am able to generate time stamped file (e.g test_28_04_10_10_2). I have to implement further improvements to this excel file.

1)Column headings should be bold.

2)Insert graph in same saved file.

I did tried report generation toolkit but found that I need to use function "New Report" function because return type of this function is report out which is being used as an input in every report generation function.

The drawback of using this New Report function is that, it opens up Excel in real time and then user has to save the file by itself. I can work with this function if excel doesnt opens up and generate graph in the background.

Thanks

[Dimitrios]

Hi Arrowminds,

Can you supply a VI for LV 8.6?

It might be better to start a new thread because is a different issue and you will get more help.

Regards

Dimitrios