Spreadsheet object (Lookout 5.1)

[FRRO]

Hi,

I have two question regarding the spreadsheet object.

First, When I'm looking my file in Excell, In the first Row, I don't want to have all the Expression. In the follwing exemple I would like to just have ModbusSlave6
Instead of my expression
38.3*(..\..\[SymLink_Server]\ModbusSlave6.Pompe1 or ..\..\[SymLink_Server]\ModbusSlave6.Pompe2)

Is this possible?

Second question.

I want to do the sum off all the data in a Field. For exemple. I logged a data in every 1 hour and I would like to add the data with the previous Data, Instead of put the Data in a Other Row. Is This Possible without creating a Template in Excell.

Tx

[Khalid]

Hi,

First: you can create an Expression Object called ModbusSlave6 and point it to your expression statement. And then log this Expression Object in the SpreadSheet object.

Second: SpreadSheet object will always add a new row each time. To achieve what you want, you may want to use the DataTable object instead. The DataTable object is like the SpreadSheet object, but much more powerful -- it can do (or can be made to do) everything that the SpreadSheet object does, plus more -- a superset, if you will.

In the DataTable object you can have the cells accumulate values (with some logic) and then write the data to an excel file periodically.

Hope this gives you some ideas.

Best regards,

Khalid 🙂