Recent Control & Safety Systems Discussions
Similar Posts
Unloading OPC Client without closing Excel when using the Excel Add-in
excel add in deltav.xla
DeltaV Excel Add-in
DeltaV Excel Add-In
DeltaV Excel Add-in
Share

Limitation of max samples values in Excel Add-in

I am using Deltav 12.3 excel addin to get process history data to excel. But I found out that there is limitation in "RAW data function" in maximum samples of 65536. Is possible to change this limitation somehow or is there any other possibility how to get bigger amount of process history data to excel?

Thank you  

Dragonfly
  • LaurentB

    In reply to Dragonfly:

    You're right , I found this information "For now, DeltaV Reporter has a limitation of 65,536 rows regardless of Excel version"
    SO you have work around if you really need more.
    Suggestions :
    - Use DCVCHDUMP ( less user friendly but very powerfull) ( you can build macro in excel to export the command and import the result
    - split your addin queries into severall shorter period or increase the sample time to reduce line number. At the end working with much more 65536 lines in excel will be not very efficient also , Excel will be very slow to manipulate these data

This is the official online community site of the Emerson Global Users Exchange, a forum for the free exchange of non-proprietary information among the global user community of all Emerson Automation Solution's products and services. Our goal is to improve the efficiency and use of automation systems and solutions employed at members’ facilities by sharing our knowledge, experiences, and application information.

User Groups | World Areas | Community Guidelines | Legal Information | Privacy Policy | Contact Community Manager

Website translation provided by Website Translator

© 2015-2022 Emerson Global Users Exchange. All rights reserved.