Update code to utiltize Aspose.Cell

cattyhu · June 20, 2011, 8:27pm

I am new to Aspose. I am try to update over 4000 line of code that was utiltize Mircosoft.Office.Interop Excel.

The code were try to export data to excel sheet or excel sheet template with chart.

i had done search, however, i am not able to find any method or property that i can use in aspose.cell..

see below line of code still use MS Excel..

oChart.Shapes.Item("Rectangle 3").TextFrame.Characters(null, null).Text = CtrlTotal;

oChart.Chart.Location(Excel.XlChartLocation.xlLocationAsNewSheet, "Dashboard Chart");

oSheet.Cells.CreateRange("A1", Missing.Value);

oSheet.Cells.CreateRange("A" + (y + 1), "A" + (y + 3)).Clear();

series.Border.ColorIndex = colSeriesMD_CompositScore

range = (Range)oSheet.Rows[("5:" + lastRow.ToString()), Missing.Value];

range.Insert(Excel.XlInsertShiftDirection.xlShiftDown, Excel.XlInsertFormatOrigin.xlFormatFromLeftOrAbove);

range.Delete(Excel.XlDeleteShiftDirection.xlShiftUp);

I wonder if some one can help me find out how to update those code. thanks.

amjad.sahi · June 20, 2011, 9:17pm