FrutigerAG Posted December 13, 2021 Report Share Posted December 13, 2021 I am currently working on the development of a measuring device, based on a V700. As result resp. measurement data file I have a UDT file which is stored on a PC. I would like to import this UDT file directly into a read-only Excel template, so that the user of the measuring device cannot change the measurement data file. After all, a CSV file could be modified. Is there an import routine to Excel where you can import UDT files directly (without SD card manager)? Poss. via separate DLL? Thanks. Quote Link to comment Share on other sites More sharing options...
MVP 2022 Ausman Posted December 14, 2021 MVP 2022 Report Share Posted December 14, 2021 I'm just clarifying what you're asking....you want a method to read a UDT directly from the PLC into a read-only xls/xlsx? The question arises because of you saying "UDT file which is stored on a PC. I would like to import this UDT file directly into a read-only Excel template", which is a totally different thing. And if truth of the file is necessary, I'd always be storing the initial UDT somewhere inaccessible to users, and only letting them use a copy. cheers, Aus Quote Link to comment Share on other sites More sharing options...
FrutigerAG Posted December 16, 2021 Author Report Share Posted December 16, 2021 Hi Ausman Thank you for your answer. I have a mobile measuring device that is taken from measuring location to measuring location. The measurement data are recorded on this measuring device on the SD card and then sent in UDT format by email to a defined address. The recipient of the email has no PLC on site, but saves the UDT file locally on the PC. This file is then to be read into an Excel spreadsheet without any detours via the SD card manager. Unfortunately the description of the "Unitronics Data Table DLL" is very bad and it doesn't seem to be the right solution for my purposes. Thanks for your help. Greetings, Marc Quote Link to comment Share on other sites More sharing options...
MVP 2022 Ausman Posted December 20, 2021 MVP 2022 Report Share Posted December 20, 2021 Hi Marc, So I'm assuming that the "measuring device" can't do the conversion on it's own. Therefore my way of doing this would be for somewhere in the transfer process the excel file is generated at the PC end and locked up. To me the easiest way for this to happen would be a small script that the user would run. It would first make the UDT read only, then convert to excel and lock that file as well. As to how well this would work, or easy it would be, I haven't had time to explore this as yet. cheers, Aus 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.