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: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to set date format for entire sheet using XlsIO?

Setting a number format for an entire sheet at once is not possible with XlsIO. However, this approach also affects the performance and will impact the memory usage.


To apply a number format to all the cells, we recommend to utilize UsedRange property of IRange. This will apply a same format to all the used range cells in a worksheet. The following code snippets illustrates the same for your reference.



The sample illustrating this behavior is available here.


Article ID: Published Date: Last Revised Date: Platform: Control:
4224 03/03/2015 03/03/2015 WinForms XlsIO
Did you find this information helpful?
Add Comment
You must log in to leave a comment

Please sign in to access our KB

or the page will be automatically redirected to sign-in page in 10 seconds.

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