Create a *.csv file

2 posts in this topic

Hi, I have a problem. I want to make a specific *.csv file that will contain data from, let’s say, D0-D100 registers from my PLC. The *.csv file should be created when some event occurs (not periodically). What is the best way to do it? I thought of using MX Sheet / MX Component, but I’m wondering if there is another (cheaper) possibility to communicate with PLC from for e.g. Excel (I mean read data automatically from PLC to Excel via USB or Ethernet), and then use a macro to save it as *.csv file in a specific location?

Share this post

Link to post
Share on other sites

Which CPU do you use?

With L-series or System-Q with SD card, you can set up a logging and save as CSV on the SD card.

With the FTP server on the CPU switched on, an FTP client should then be able to be fetch the file.

I have never tried this and therefore I don't know how to access the SD card via FTP  . But this solution would be free

Edited by Dave W.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now