Lookout

cancel
Showing results for 
Search instead for 
Did you mean: 

How I read CSV files to XYChart?

I'm record my process data whit spreadsheet object in .csv files and now I
want read data to XYChart object. It is possible?
0 Kudos
Message 1 of 4
(3,978 Views)
Only if you convert the csv file to a MS Excel 2.1 file. You can then import the data into a datatable and connect the appropriate datatable datamember(s) to the appropriate XY chart datamembers.

There are other ways to do this:
1) When you save your data using a spreadhsheet object also record the data to a datatable. Then you can use the XY chart to read the data from the datatable without importing.

2) The best way: All the data you are saving to the spreadsheet object should also be recorded in the the citadel database (you have to ensure this). Then execute a SQL query to extract the data into a datatable (via importing). Now you can read the data into an XY chart.

The last example is complex but it works the best and offers the most functional op
tions.

Regards,
Tommy Scharmann
0 Kudos
Message 2 of 4
(3,977 Views)

How we can extract Data from Citadel data base with SQL query?   Where this Citadel data store (Database path)?

0 Kudos
Message 3 of 4
(3,347 Views)

You should 1st open the CSV file in Microsoft Excel to view the CSV.

0 Kudos
Message 4 of 4
(3,293 Views)