Trying to select range for Excel chart

[hansioux]

Hi,

This is probably not an "perl" question, but I am writting this in perl,
so I gave it a shot.

I have created a excel spreadsheet using the Win32:le..

I am trying to create a excel chart,

but instead of charting column A all the way through column J
I just want to chart column A and column J.

$Range = $Sheet->Range("A1:J10")->Select(); only gives the whole thing.
Unfortunately, this is the only kind of examples I can find on the web.

Now, I know I can copy and paste this two columns together on to a new
sheet, but that kind of defeats the purpose.

Please give me a pointer, thanks!

 

[A. Sinan Unur]

try
$Range = $Sheet->Range("A:A,J:J")->Select();

This should select column A and column J rather than all columns
between A and J.

Incidentally, one can figure out the answer to this question by starting
up Excel, and selecting a discontinuous range for a formula, and looking
at what is displayed in the formula bar. Considerably faster than waiting
for someone else to do it and post the solution on the UseNet.

Sinan.

 

[hansioux]

It did work, thanks.



Originally posted by Graham Wood

This is a multi-part message in MIME format.
--------------6ACA1FB34367523651D886F4
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

whole thing.

try
$Range = $Sheet->Range("A:A,J:J")->Select();

This should select column A and column J rather than all columns
between A
and J.

Hope this helps

Graham



--------------6ACA1FB34367523651D886F4
Content-Type: text/x-vcard; charset=UTF-8;
name="Graham.T.Wood.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Graham Wood
Content-Disposition: attachment;
filename="Graham.T.Wood.vcf"

begin:vcard
n:;Graham
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:[email protected]
fn:Graham Wood
end:vcard

--------------6ACA1FB34367523651D886F4--