Jump to content

V570 Import/export DT to excel need example


Recommended Posts

Hello I am working with recipe control and data tables at the moment using SD card. I need example to import/export data tables, because one that I found write only 1 cell in excel, and that cell becoming full of "0CSV" words. So basicly I want to do , pushing button on HMI and all data table from PLC would be exported to SD card or existing Data table from SD card would be imported to PLC data table memory with same name.

 

I attached file with my try to do this... 1st it wrote a lot of "0CSV" in one cell, now it doesn't work, just shows MI6-> status integer message of 128 then i try to export..

post-28986-0-67948900-1430038190_thumb.jpg

post-28986-0-37121400-1430038309_thumb.jpg

post-28986-0-02875100-1430038310_thumb.jpg

Link to comment
Share on other sites

  • 2 weeks later...
  • MVP 2023

Is this your entire program?  You don't have anything to monitor the SD card's status in the logic.

 

Also, you probably want to allocate more than 6 characters for a DW on the last line.  The delimiter for the last line should be 0D (carriage return), not 2C (comma).  You're just writing one huge line, not a line for each entry.

 

Joe T. 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...