Convert Excel data on a Tag Dataset ignition

Ignition
1

Hello, I need help.
I'am creating a webcam system. All data of a webcam will be configured on an Excel file like:

image
image751×483 4.86 KB

I would like to know if it is possible to extract my data excel below and write it like a tag dataset.

To do the test, I created a tag dataset like:

image
image818×198 16.7 KB

But in future, all configuration of webcam will be donne in a Excel file
the raison that is why I'am searching solution to get Read an Excel file and whrite data on a tag.

2

If you can format/convert your excel to csv, you can use this:
https://docs.inductiveautomation.com/display/DOC81/system.dataset.fromCSV

Otherwise you might be able to use org.apache.poi.ss

3

j'ai pris l'exemple du doc

# In this example it is assumed that the CSV file being read was a dataset
#that was previously exported using system.dataset.toCSV with the forExport flag set to True:
# Specify file path.
file_path = "C:\\my_dataset.csv"
# Read in the file as a string.
data_string = system.file.readFileAsString(file_path)
# Convert the string to a dataset and store in a variable.
data = system.dataset.fromCSV(data_string)
# Assign the dataset to a table.
event.source.parent.getComponent('Table').data = data

Mais s'affiche l'erreur.

image

fichier .csv:
image

4

Concernant cette bibliothèque, comment l'implémenter sur ignition

5

Pas tout à fait.

Le message d'erreur dit qu'il ne trouve que 4 rows, alors qu'il en attend 6.
Regarde bien ton csv:

ligne 5: #ROWS, 6

Et derrière, il n'y a que 4 lignes... Forcément, ca marche pas.

import org.apache.poi.ss

6

To help you get started: