When I export the historical data from a power chart to an excel sheet the enter path of the tag is displayed and makes the sheet look bad. Is there a way I can change this to only display the last ***. Also how can I limit the decimals to a lower amount say max .99 .I will post an example of what I mean
1 Like
I am also looking for this solution. Have you been able to find a solution yet?
Same problem here. Any solution ???
You have to write your own dataset to Excel script using the Apache POI libraries that IA uses internally. Search this forum for apache poi to find many examples.
Your own script can shorten names to meet your specific needs. No generic tool will be able to do that.