DATA AND TIME IN SAME EXCEL

[Mr Bungle]

HI ALL

Im making a project with a TPC2012 and Siemens PLC S700 but the HMI isn't compatible with free ADODB library so im trying to make a little DATA BASE with EXCEL SPREADSHEETS but dont know how put the time in a column and data in other, i hope someone can help me with this.

Or if someone knows a special database library for this kind of National Instruments HMI.

Thanks a lot and have a nice day!!!!

[MarisolM]

Hello Mr.. Bungle;

Actually there IS a toolkit that helps you to store data directly in excel; it is called Report Generation Toolkit.

In the following image there is an example on how to program it. In this specific vi, the generated data is saved every second to an excel worksheet, and so is the graph.

This is what the front panel looks like

The block diagram code is

And finally I am also adding a print.screen of the excel view

As you can see, the time (you can also set it to show the full date in the excel properties) is shown in one column while it's corresponding data is shown in the next one.

If you need another example on how to save data to excel check the following links, in the first one, there is a simple example on how to save data to excel, in the second one, it includes some data generation and data/time saving in a database;

http://decibel.ni.com/content/docs/DOC-6376

http://decibel.ni.com/content/docs/DOC-4578

I hope you find this information useful

Good luck with your application

Marisol

[Oriol.Bofill]

Hi,

I use this.

Good lucky !