LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

save/load to file Table control with different data types

Need help. I can write data from a table to a file. For example excel. At new start to receive this data in the table. Edit data. As in the attached application. I need a table control with different data types.
0 Kudos
Message 1 of 9
(2,017 Views)

Tables contain strings. But there are some ways to play tricks if you want an enum selector to pop up when editing a cell.

 

The read/write spreadsheet VIs are for spreadsheets in the general sense, which means values are separated by delimiter putting them in different columns. You should just make the file extension ".txt" when using a tab delimiter.

 

If you really need an Excel file, you should use the report generation toolkit.

0 Kudos
Message 2 of 9
(1,972 Views)

Thanks for the answer.
In what type of file to save it does not matter.
It is important for me to be able to edit the saved data after restarting the program.
But my data types are different.

0 Kudos
Message 3 of 9
(1,957 Views)

You can't read and write Excel files (actual .xls or .xlsx) unless you use the Report Generation Toolkit (that requires Excel to be installed) or a third party tool kit like XLR8

 

========================
=== Engineer Ambiguously ===
========================
0 Kudos
Message 4 of 9
(1,936 Views)

Thanks for the answer.
I don't care about the excel file.
The task is to save and edit data of different types in the table during a new load.

0 Kudos
Message 5 of 9
(1,926 Views)

@Aritek wrote:

The task is to save and edit data of different types in the table during a new load.


If you need different datatypes in a table you can take a look at 'OpenSource Project for a .NET Datagrid for LabVIEW' by Mike King . The code is on github: https://github.com/unipsycho/LabVIEWdotNetDataGrid .

Disclaimer: I did not try this project.

 

0 Kudos
Message 6 of 9
(1,923 Views)

The simplest option is a 1D array of clusters, where each element is a row. You can convert the cluster values manually to save to the file. This isn't as usable as Excel, but it is simple


___________________
Try to take over the world!
0 Kudos
Message 7 of 9
(1,912 Views)

Thanks for the answer.
I want without .NO.
For example https://forums.ni.com/t5/LabVIEW/array-of-cluster/m-p/1822451#M625032
I connected modules of read/wtite.
It works.
But when you try to edit it is reset.

0 Kudos
Message 8 of 9
(1,911 Views)

Maybe this should work.
But I see a strange error.

0 Kudos
Message 9 of 9
(1,897 Views)