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 apply table style to a group of cell?

Thread ID:





99670 Jun 3,2011 05:50 AM UTC Mar 14,2019 04:48 PM UTC ASP.NET Web Forms (Classic) 2
Tags: XlsIO
Asked On June 3, 2011 05:50 AM UTC

Hi All,

if i know the range of cells, e.g from range (2,1) to range (14, 9).

i want to apply a custom table style onto all the cell (table) amount them.

how can i do it.

from the API, i can only see "BuiltInTableStyle", what if i want to apply custom table style???

IListObject table =
table.BuiltInTableStyle = TableBuiltInStyles.TableStyleLight1;

(Syncfusion V9.203.0.137)


John Bowlin Bosco K [Syncfusion]
Replied On June 6, 2011 09:19 AM UTC

Hi Shrimpy,

Thank you very much for your interest in syncfusion Products.

Currently, Essential XlsIO does not provide support to apply custom table styles. It provides support to apply nearly 60 built-in styles for the table by using the TableBuiltInStyles enumerator of XlsIO. Also, we do not have any immediate plans to implement this feature. So, we will get back to you once this feature has been implemented in one of our forthcoming releases.

Please let us know if you need any further assistance.

Pauline Bosco

Sivaneswaran Amsu [Syncfusion]
Replied On March 14, 2019 04:48 PM UTC

Hi shrimpy, 
We are glad to inform you that the feature “Custom table styles support in Excel” has been included in our Essential Studio 2019 Volume 1 beta release  v17.1.0.32 and is available for download under the following link
We have prepared the sample for custom table styles which can be download for following link. 
Sivaneswaran . A 


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.

Please sign in to access our forum

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

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.