1. Home
  2. Forum
  3. ASP.NET Web Forms (Classic)
  4. How to apply table style to a group of cell?

How to apply table style to a group of cell?

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 =
worksheet.ListObjects.Create("DATA_TABLE",worksheet[2,1,14,9]);
table.BuiltInTableStyle = TableBuiltInStyles.TableStyleLight1;

(Syncfusion V9.203.0.137)

Thanks.


2 Replies
JB John Bowlin Bosco K Syncfusion Team 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.

Regards,
Pauline Bosco


SA Sivaneswaran Amsu Syncfusion Team 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. 
 
 
Regards, 
Sivaneswaran . A 


Loader.
Up arrow icon