02-07-2022 02:56 AM
02-07-2022 10:53 AM
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.
02-08-2022 12:47 AM
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.
02-08-2022
08:36 PM
- last edited on
09-05-2025
09:08 AM
by
Content Cleaner
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
02-09-2022 01:26 AM
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.
02-09-2022 01:47 AM
@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.
02-09-2022 02:24 AM
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
02-09-2022 02:27 AM
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.
02-09-2022 05:20 AM
Maybe this should work.
But I see a strange error.