AnsweredAssumed Answered

DataLink - Resize to show all values en masse

Question asked by Karl.Hodgkiss Champion on May 21, 2015
Latest reply on Aug 29, 2015 by Guilherme Ferreira

Is there a way to force Excel to do a "Resize to show all values" en masse?

 

I've got a simple worksheet showing compressed data for 10 tags with the start/end time in cells A1&A2 (pretty standard stuff).

On my first run I get 10 values for each tag, but then I change the times and now I should get 19 values in each column.... but instead I get 10 values and the resize message (CTRL+ALT+F9 doesn't help.)

E.G.

Number of Values: 19

19-May-15 08:14:45      3.84795022

19-May-15 08:29:15      1.789492369

19-May-15 08:38:58      Shutdown

19-May-15 08:45:58      0.37449

19-May-15 09:47:58      4.31672

19-May-15 11:02:28      25.93758

19-May-15 13:30:28      85.49880

19-May-15 14:39:28      99.19938

19-May-15 15:42:58      96.52633

20-May-15 07:22:37      16.99458

Resize to show all values   Resize to show all values

 

I found this KB article which is on the right track but the number of tags/ranges could be huge KB01035 - Recalculate a PI DataLink function without using the right-click menu

 

 

Similar to the above, after resizing the data to display 100 values I then change it back to 10 values and save as a CSV file... but the extra 90 unused cells are also saved in the file as unwanted commas... how can this be stopped ?

E.G.

Number of Values:,10

20-May-15 07:22:37,16.99458

20-May-15 08:26:58,2.06320

20-May-15 09:26:28,1.32765

20-May-15 10:34:28,16.04910

20-May-15 13:33:58,86.55754

20-May-15 14:39:28,99.19938

20-May-15 15:41:58,96.68435

21-May-15 07:05:40,22.89077

21-May-15 07:15:28,3.72859

21-May-15 08:05:28,6.07596

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

,

Outcomes