We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on : Nov 16th 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Scrolling an Excel document

Thread ID:

Created:

Updated:

Platform:

Replies:

92098 Dec 18,2009 03:26 PM UTC Dec 24,2009 10:31 AM UTC ASP.NET Web Forms (Classic) 3
loading
Tags: XlsIO
Todd Nirenstein
Asked On December 18, 2009 03:26 PM UTC

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 [Syncfusion]
Replied On December 23, 2009 08:25 AM UTC

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
Replied On December 23, 2009 06:27 PM UTC

That fixed the problem....thanks!

Manimala P [Syncfusion]
Replied On December 24, 2009 10:31 AM UTC

Hi Todd,

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

Regards,
Manimala.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;