Free Support Forum - aspose.com

Select worksheet to be displayed on open

We are using the Excel designer to populate an excel spreadsheet from our database. When we open the document after it has been processed, it first displays the last column in the last worksheet in the document. How can I reset the cursor to the first column and first row of the first worksheet?

Thanks,

Martin

Hi Martin,

Do you use an evaluation copy or a licensed copy? If your Aspose.Excel is an evaluation copy, the first shown worksheet is always the license page(last worksheet). If your Aspose.Excel is licensed, please use Worksheets.ActiveSheetIndex to set the first shown worksheet.

We have a full licensed version. The activesheetindex worked.

Now when I view a worksheet that has a large number of columns, I first see the last column in the worksheet. The page is scrolled over to the right. How do I reset the view so that I can see the first column in view when the document is opened?

Martin

Hi Martin,

We will provide new properties to set the first view row and column in the future release. Now could you manually set it in your designer file?

I just noticed that my template documents had the last column selected when I opend them. I selected the first column and now it works as requested.

Thank you,

Martin