1

I am using Win32::OLE to create charts from a excel datasheet in MSExcel 2010. The data are not in consecutive columns and I have a ds having the range of each data. I am trying to union all these data ranges to a single range object like :

my $range = $self->{'workbook'}->Application->Union( $range, $r );

It works fine, till "$BS$1:$BS$168". The next data is in the range "$BW$1:$BW$168". This range is not getting united with the previous range and I am left with only 18 collected data instead of 46.

What may be the reason and workaround? Is there any limit, to the number of series you can collect?

Axeman
  • 29,660
  • 2
  • 47
  • 102
Kallol
  • 302
  • 4
  • 16

1 Answers1

0

According this thread there is a limit 255 for address length, including all punctuation. Your example range is 13 characters plus one for separator, giving you around 18 items maximum.

Conclusion is to limit number of items or their length. Could you merge multiple columns together ($BS$1:$BW$168), or leave $s out for instance?

bvr
  • 9,687
  • 22
  • 28