charles.lin Posted March 29, 2021 Report Share Posted March 29, 2021 Hi, Instead of using the SQL database, does anyone know if it is possible to connect the Unilogic to an Microsoft Excel file? I would like to generate an easy database on the Excel spreadsheet and put it on SD card or some other places, and then connect the Unilogic to the spreadsheet to get the data. Thanks, Charls Quote Link to comment Share on other sites More sharing options...
dierkens Posted March 29, 2021 Report Share Posted March 29, 2021 We’ve found the best approach is to just save a data table to a UDT file and then use the converter to toss it into Excel. You can save it to a csv file but you have to thoughtful of how much time it takes to write to the csv file. Quote Link to comment Share on other sites More sharing options...
Swervomotor Posted March 30, 2021 Report Share Posted March 30, 2021 I have accomplished this a couple different ways: 1. Put the data table on a webserver page so you can connect and edit data remotely. 2. Convert UDT to .csv then FTP that to your network folder. Open in excel, edit, save as .csv, put back in network folder, Then FTP receive from the PLC (power up or button etc). 3. SQL to/from SQL database. SD card would be my last choice, you can even just use a FTP client like filezilla and "manually" grab it off the PLC to edit then put it back. Only issue I have is converting from .csv into excel, takes to many clicks/keystrokes so I normally just edit the raw .csv in notepad. File size could be an issue but some tables have 500-1000 rows of 19 columns and do not miss a beat. -Swervomotor Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.