Free Support Forum - aspose.com

How to setup active cell in a worksheet?

Hi,

I need to create an Excel doc which selects Cells[8,1] as the active cell when

a user opens this doc. It would be something similar to excel.worksheets.activeindex.

BTW.

int idx = report.Worksheets.AddCopy("Week");

report.Worksheets[idx].Copy(week);

This above code would create an corrupted Excel doc.

Currently Aspose.Excel doesn't support to set an active cell at run time. We will add this feature later.

Now you can set Cells[8,1] as active cell in your template file. Aspose.Excel can import it and save it to generated file.

About the copy problem, please try this attached file. If the error still occurs, please post your template file here, I will check it right now.