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!

 

[aitzi]

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

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

//libro.ActiveChart.ChartWizard(rangos, Excel.XlChartType.xlColumnClustered,
opc, Excel.XlRowCol.xlColumns, opc, opc, opc, "historial", opc, opc, "");

libro.ActiveChart.Location(Excel.XlChartLocation.xlLocationAsObject,
"Detalles");



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

libro.ActiveChart.SetSourceData(rangos, Excel.XlChartType.xl3DArea);

libro.ActiveChart.Legend.Delete();

libro.ActiveChart.ChartType = Excel.XlChartType.xlBarClustered;

//libro.ActiveChart.PlotBy = Excel.XlRowCol.xlRows;

//libro.ActiveChart.SizeWithWindow = Excel.XlSizeRepresents.xlSizeIsArea;

libro.ActiveChart.SizeWithWindow = true;


//proteger el grafico

libro.ActiveChart.ProtectData = true;

libro.ActiveChart.ProtectFormatting = true;

libro.ActiveChart.ProtectGoalSeek = true;

 

[aitzi]

Sorry, I dont understand.

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

I will try with aspose.

Thanks

[please don't top-post]

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

 

[aitzi]

Thanks!!!

[please don't top-post]

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

Yes - that is its purpose.