iX Talk

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.

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

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

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.

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

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