Excel Chart

[aitzi]

Hi,

I have to do an application that opens an excel page, and I have to do a
chart.
I can create the chart but I can´t put it in cell that I want.

How can I do it?

Sorry for my English!

[Mark Rae [MVP]]

Re: Excel Chart

"aitzi" <aitziber@leako .comwrote in message
news:e5$p$vMGJH A.2272@TK2MSFTN GP05.phx.gbl...

How can I do it?

http://www.aspose.com/categories/file-format-components/aspose.cells-for-.net-and-java/default.aspx

--
Mark Rae
ASP.NET MVP

http://www.markrae.net

[aitzi]

Re: Excel Chart

Thanks,
But I need use Excel because the Excel page is for my clients.
My code is this:
libro.Charts.Ad d(opc, opc, opc, opc);

rangos = hoja1.get_Range ("A" + fila.ToString() , "C" + (fila +
6).ToString());

//libro.ActiveCha rt.ChartWizard( rangos, Excel.XlChartTy pe.xlColumnClus tered,
opc, Excel.XlRowCol. xlColumns, opc, opc, opc, "historial" , opc, opc, "");

libro.ActiveCha rt.Location(Exc el.XlChartLocat ion.xlLocationA sObject,
"Detalles") ;



rangos = hoja1.get_Range ("I420", "I424");//coge los valores que hay ese
rango en la hoja de c lculo

libro.ActiveCha rt.SetSourceDat a(rangos, Excel.XlChartTy pe.xl3DArea);

libro.ActiveCha rt.Legend.Delet e();

libro.ActiveCha rt.ChartType = Excel.XlChartTy pe.xlBarCluster ed;

//libro.ActiveCha rt.PlotBy = Excel.XlRowCol. xlRows;

//libro.ActiveCha rt.SizeWithWind ow = Excel.XlSizeRep resents.xlSizeI sArea;

libro.ActiveCha rt.SizeWithWind ow = true;


//proteger el grafico

libro.ActiveCha rt.ProtectData = true;

libro.ActiveCha rt.ProtectForma tting = true;

libro.ActiveCha rt.ProtectGoalS eek = true;




"Mark Rae [MVP]" <mark@markNOSPA Mrae.netescribi ó en el mensaje
news:u51cV7MGJH A.2072@TK2MSFTN GP04.phx.gbl...

"aitzi" <aitziber@leako .comwrote in message
news:e5$p$vMGJH A.2272@TK2MSFTN GP05.phx.gbl...
>

>How can I do it?

>

http://www.aspose.com/categories/file-format-components/aspose.cells-for-.net-and-java/default.aspx

>
>
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

Re: Excel Chart

"aitzi" <aitziber@leako .comwrote in message
news:OBsffHNGJH A.4992@TK2MSFTN GP04.phx.gbl...

[please don't top-post]

>>How can I do it?

>>
>http://www.aspose.com/categories/fil...a/default.aspx

>
But I need use Excel because the Excel page is for my clients.

What difference does that make...?

You're posting in an ASP.NET newsgroup - server-side Office Automation isn't
supported by Microsoft, so you can't use the code that you've posted.

Therefore, you need a solution which will allow you to manipulate an Excel
workbook *WITHOUT* instantiating Excel itself - hence Aspose...


--
Mark Rae
ASP.NET MVP

http://www.markrae.net

[aitzi]

Re: Excel Chart

Sorry, I dont understand.

So, I can use Aspose and open an excel application, yes??

I will try with aspose.

Thanks




"Mark Rae [MVP]" <mark@markNOSPA Mrae.netescribi ó en el mensaje
news:OZY9WYNGJH A.3396@TK2MSFTN GP05.phx.gbl...

"aitzi" <aitziber@leako .comwrote in message
news:OBsffHNGJH A.4992@TK2MSFTN GP04.phx.gbl...
>
[please don't top-post]
>

>>>How can I do it?
>>>
>>http://www.aspose.com/categories/fil...a/default.aspx

>>
>But I need use Excel because the Excel page is for my clients.

>
What difference does that make...?
>
You're posting in an ASP.NET newsgroup - server-side Office Automation
isn't supported by Microsoft, so you can't use the code that you've
posted.
>
Therefore, you need a solution which will allow you to manipulate an Excel
workbook *WITHOUT* instantiating Excel itself - hence Aspose...
>
>
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Mark Rae [MVP]]

Re: Excel Chart

"aitzi" <aitziber@leako .comwrote in message
news:OcZCwgNGJH A.612@TK2MSFTNG P06.phx.gbl...

[please don't top-post]

>>>>How can I do it?
>>>>
>>>http://www.aspose.com/categories/fil...a/default.aspx
>>>
>>But I need use Excel because the Excel page is for my clients.

>>
>What difference does that make...?
>>
>You're posting in an ASP.NET newsgroup - server-side Office Automation
>isn't supported by Microsoft, so you can't use the code that you've
>posted.
>>
>Therefore, you need a solution which will allow you to manipulate an
>Excel workbook *WITHOUT* instantiating Excel itself - hence Aspose...

>
So, can I use Aspose to open an Excel application?

Yes - that is its purpose.


--
Mark Rae
ASP.NET MVP

http://www.markrae.net

[aitzi]

Re: Excel Chart

Thanks!!!




"Mark Rae [MVP]" <mark@markNOSPA Mrae.netescribi ó en el mensaje
news:%23yiQF3NG JHA.3664@TK2MSF TNGP05.phx.gbl. ..

"aitzi" <aitziber@leako .comwrote in message
news:OcZCwgNGJH A.612@TK2MSFTNG P06.phx.gbl...
>
[please don't top-post]
>

>>>>>How can I do it?
>>>>>
>>>>http://www.aspose.com/categories/fil...a/default.aspx
>>>>
>>>But I need use Excel because the Excel page is for my clients.
>>>
>>What difference does that make...?
>>>
>>You're posting in an ASP.NET newsgroup - server-side Office Automation
>>isn't supported by Microsoft, so you can't use the code that you've
>>posted.
>>>
>>Therefore, you need a solution which will allow you to manipulate an
>>Excel workbook *WITHOUT* instantiating Excel itself - hence Aspose...

>>
>So, can I use Aspose to open an Excel application?

>
Yes - that is its purpose.
>
>
--
Mark Rae
ASP.NET MVP
http://www.markrae.net