Jump to content

Recommended Posts

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.

Link to comment
Share on other sites

  • MVP 2022

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • MVP 2022

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

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...