How to apply table style to a group of cell?

[shrimpy]

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.

[John Bowlin Bosco K]

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

[Sivaneswaran Amsu]

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. 

https://www.syncfusion.com/forums/143309/essential-studio-2019-volume-1-beta-release-v17-1-0-32-is-available-for-download  

 

We have prepared the sample for custom table styles which can be download for following link. 

 

Sample link :  http://www.syncfusion.com/downloads/support/directtrac/general/ze/CustomTableStyle2107438388  

 

Regards, 

Sivaneswaran . A