Showing results 1 to 2 of 2

Thread: Automatic import of report data into Excel

  1. #1
    jegloco Gast

    Rotes Gesicht Automatic import of report data into Excel

    Dear Support Team,

    We are looking for a method to import *.txt file from zenOn reports (exported report data) to be automatically populated into an Excel template with proper column arrangement without setting any parameters manually in Excel.

    There should be an Excel template created for this to allow for the user to just click export and see the data presented as a graph in the excel document.

    Please advice us for the solution. Hope to read from you soon as this issue is very urgent.

    Should you have any questions on the above please let me know.

    Thanks and regards,
    Jega

  2. #2

    Default Re: Automatic import of report data into Excel

    Hello,

    Unfortunatley this is not possible due to different formating information in the Excel and zenon. The report more or less is looking like Excel but in fact it is very different in the data format.

    The only way to handle a smooth import to Excel would be to export the raw data from zenon, and import this raw data to an already formated excel sheet e.g. via an VBA macro within Excel for example.

Similar Threads

  1. Access to Excel from SCADA Runtime
    By olga in forum VBA
    Replies: 1
    Last Post: 20th November 2010, 02:27
  2. Handling Asynchronous Data - Report Generator
    By mike.edkins in forum Drivers
    Replies: 1
    Last Post: 3rd February 2010, 13:35
  3. Import / Automatic creation of Variables in STRATON
    By prasadkh in forum straton / zenon Logic
    Replies: 1
    Last Post: 29th December 2009, 01:19
  4. HELP: I can not save dbf files in excel!
    By markclemens in forum zenon Supervisor
    Replies: 1
    Last Post: 12th June 2008, 07:11
  5. Replies: 0
    Last Post: 20th August 2007, 14:00

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •