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::ole..

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!

--
Posted via [url]http://dbforums.com[/url]

[A. Sinan Unur]

Graham Wood <Graham.T.Wood@oracle.com> wrote in
news:3F30F689.9E307414@oracle.com:

> hansioux wrote:
>

>> 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.

>
> 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.

--
A. Sinan Unur
[email]asu1@c-o-r-n-e-l-l.edu[/email]
Remove dashes for address
Spam bait: mailto:uce@ftc.gov

[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
>
> hansioux wrote:
>

> > 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::ole..
> > 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.
>
> 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:Graham.Wood@oracle.com
> fn:Graham Wood
> end:vcard
>

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

--
Posted via [url]http://dbforums.com[/url]