Scrolling an Excel document

[Todd Nirenstein]

I am opening an existing Excel file from an .aspx page and using that as a template by replacing the values in certain cells and then returning that to the user. With Excel, if you save the document with it scrolled to the right or scrolled down, it retains the scrolling position for the next time it is opened. The problem is that if someone edits the template and forgets to scroll back to the top, it will retain that position. I would like to always scroll to the top of the document when opened. Is that possible using XlsIO?

Thanks in advance,

Todd

[Manimala P]

Hi Todd,

Thank you for your interest in Syncfusion products.

As you have asked, you can always view the top of the file by using the following code snippet.

sheet.TopVisibleRow = 1;
sheet.LeftVisibleColumn = 1;

Please try this and let me know if you have any questions.

Regards,
Manimala.

[Todd Nirenstein]

That fixed the problem....thanks!

[Manimala P]

Hi Todd,

Thanks for the update.Please let us know if you have any other queries.

Regards,
Manimala.