Import excel sheet on IX

[charlyprouteau]

Dar Sir,

Is a way to import excel sheet to IX?
My problem is :
I need fill datas on D1 = "colums A, line 1" and D2 = "colums A, line 2" in Microsoft Excel.
Then, I need to import this excel file into IX, and affect D1 to TAG1 and D2 to TAG2.
Have you got an idea about this?

Thanks for your answer.

[mark.monroe]

You can import/export tags from a csv file. CSV files can be read/writen to by Excel.

Snap 2013-04-18 at 08.38.51.jpg (27.21 KiB) Viewed 8797 times

[charlyprouteau]

It is not this function I want to do.
I want to import excel sheet when the project runs, and affect value (located on the excel sheet) to a tag.
For information, the project will run on a PC.
example : tag1 will take value of D4 case on the excel file.
thanks for your answer

[mark.monroe]

You would have to write your own C# script to open up a CSV file and then read the values into the tags. You can take a look at this forum post and the Script_database_export project.

The project has come code in it that will give you an idea of how to work with files in C#.

There is nothing in iX that will allow you to do this automatically.

[Edmund]

What file extension will your excel sheet have (*.xls, *.xlsx, *.csv)?

If you have a example of it, it would be easier.