Excel import

[Luka0204]

Hi,

i have excel file with 2 columns and cc 300 rows (saturation curve). How to import excel file in GX works 3 (R04CPU) and use data as two array variables [0..300]?

I want to avoid manual writing around 600 values.

Thanks

 

[collinsd70]

Hi Luka.

My first guess would be to use some sort of OPC Server. I believe "MX-Component or MX-Sheet" might be of use to you for this sort of thing.

Just having a quick google of the above confirms this is most likely the best way to go about this.

What sort of data are you populating in this array (INT, DINT, REALs?), depending on the OPC Server you may have to create a structure in your Globals and assign Mitsubishi Addresses

Regards

Daniel

Edited February 7, 2019 by collinsd70

[Gambit]

Right mouse click on your variable list in GX works 3 will give you an import and export option.
But If you're are going to make an array than it just two entries

 

[Luka0204]

1 hour ago, Gambit said:

Right mouse click on your variable list in GX works 3 will give you an import and export option.
But If you're are going to make an array than it just two entries

 

Problem is that I need to have an array of 300 constants (real numbers). I can program 300 times like this: DataArr_1[0]:=0.1; DataArr_1[1]:=0.5 etc, but that's not an aim. Another solution is that I copy all data from excel in Device Memory then write on PLC.

 

[Gambit]

As you already mentioned I would use the the device memory to send the Data.

And create a Dut or Array in the global list