App Developper: How to use DataSheet

[stefan.erni]

Hi Ben

How can I use the DataSheet?

Or what am I doing wrong. I can't see any value,

regards

Stefan

FC9_AppDev_DataSheet.fcsx

(6.89 KiB) Downloaded 187 times

[medelec35]

Hi Stefan
I find the CSV_ReadWrite works better for spreadsheet creation.
There is an example that shows more that available by right-click on the component on the panel and selecting Help
I will look into the DataSheet component.

[Steve-Matrix]

The data in the DataSheet component is stored and can not be viewed directly on the panel.

However, you can view the data while the simulation is running (and after simulation has stopped) by right-clicking and selecting "Show stored data". This will then allow you to view, modify, export the data as a CSV and import data from a CSV. In fact, this can be done with any of the 2d Chart components.

There are 2 different DataSheet components and they work in slightly different ways. The first ("Data Sheet") allows you to place data to anywhere on a 2x2 grid. You can also read values back from this grid using <GetData>. The second allows you to add data to a number of series, but you can't read this back in your program. You can see and manipulate the data from both types of components using the "Show stored data" commands.

Note also that these DataSheet components can accept only numbers.

We are looking at implementing a more visual grid component which will allow the data to be viewed and edited directly on the panel, but if this happens it's likely to be in v10.

[medelec35]

Thanks, Steve.
I will add some information to Wiki regarding the DataSheet.

[medelec35]

just an update.
There was a bug within the DataSheet component, that stopped the data from being retrieved.
It has been fixed and the component will be pushed to the update system ASAP.

[stefan.erni]

Hi Martin, Hi Steven

I already use the CSV_ReadWrite
Very convenient.
But I would also like to view the data and not just save it. Is there a way to open the saved file with Excel using the App Developer and a command?
Such as "open test.csv"
so this would then open like a popup window.
It is also a wish to create more popup windows with the App Developer. Regardless of whether the app developer creates these windows or the App developer forces another program to open a file

However, you can view the data while the simulation is running (and after simulation has stopped) by right-clicking and selecting "Show stored data". This will then allow you to view, modify, export the data as a CSV and import data from a CSV. In fact, this can be done with any of the 2d Chart components

That's great.
This is so good that it must also work in the finished App!!
i mean in the deploit(exported) App.

I have seen this also works with the chart. Can you also add an export all 8 series , or mark which series will be exported.
Sometimes I have very big charts

And one more thing for the App Developer10…
With one command I can export the chart automatically.
With another command I can export the chart as printscreen in a JPG or PNG file automatically.


regards

Stefan

chart_2022-02-23_9-06-44.jpg (38.9 KiB) Viewed 4101 times

[Steve-Matrix]

This is so good that it must also work in the finished App!!
i mean in the deploit(exported) App.

I have seen this also works with the chart. Can you also add an export all 8 series , or mark which series will be exported.
Sometimes I have very big charts

Yes - this will work with deployed App Developer apps as well. But only one series can be exported at a time.

And one more thing for the App Developer10…
With one command I can export the chart automatically.
With another command I can export the chart as printscreen in a JPG or PNG file automatically.

Thanks for the suggestions. I'll add them to the list.

[stefan.erni]

Hi Steve

If it's working with deployed App Developer apps, how to do it there?

With the mouse-button I have just a zoom possibilities.


regards

Stefan

serie_use_2022-02-23_11-07-45.jpg (13.7 KiB) Viewed 4095 times

[Steve-Matrix]

Hi Stefan. You are correct - it is not available in a deployed App. I will look into this and investigate.

[Steve-Matrix]

Hi Stefan,

It was a bit more complicated that I hoped, but I have found and fixed the issues in the code that were causing this. We are unlikely to release another v9 version soon, but if this is a big problem for you then I may be able to give you a special release of the runtime to use. If you want this, please let me know by PM.