rslogix500 to excel

randyk

Member

Join Date

Jul 2008

Location

Florida

Posts

58

• Oct 1, 2008

• #1

I'm trying to load RSLogix500 data(I/O, bits, timers, etc.)into excel, don't seem to be using the right keywords though(excel, edit, rslogix500) on the search for info. I have never tried to do this so any info would be appreciated.

Thanks, Randy

 

gas

Member

G

Join Date

Nov 2005

Location

Erie, Pa

Posts

531

• Oct 1, 2008

• #2

Go to tools-database-ascii- inport/export.
Good luck

 

OkiePC

Lifetime Supporting Member

Join Date

Mar 2005

Location

ENE of Nowhere Oklahoma

Posts

11,790

• Oct 1, 2008

• #3

http://www.software.rockwell.com/support/download/detail.cfm?ID=2797


http://forums.mrplc.com/index.php?dlcategory=3

Note, you need a version of RSLinx higher than Lite to do this...

 

randyk

Member

OP

Join Date

Jul 2008

Location

Florida

Posts

58

• Oct 1, 2008

• #4

Thanks guys, have'nt had a chance to look at this another project of more importance came up, will let you know what I come up with.

 

TConnolly

Lifetime Supporting Member

Join Date

Apr 2005

Location

Salt Lake City

Posts

6,152

• Oct 1, 2008

• #5

Are you trying to read values from PLC memory into Excel?

Or are you trying to import register values from an offline .RSS file into Excel?

 

randyk

Member

OP

Join Date

Jul 2008

Location

Florida

Posts

58

• Oct 1, 2008

• #6

Offline .RSS file into Excel. Sorry if I forgot to mention that.

 

TConnolly

Lifetime Supporting Member

Join Date

Apr 2005

Location

Salt Lake City

Posts

6,152

• Oct 1, 2008

• #7

There is no easy way to do it (by easy I mean a few mouse clicks), but there is a way. Its more tedious than difficult. Export the program to a library file. File->Save As -> File Type .SLC. Now open the .SLC file using notepad or word pad. You will be able to see all of the data files and their values. You can then edit/cut/paste to make a .CSV file that you can open in Excel.