formatting - C# Interop Excel format like Excel's format as table -

formatting - C# Interop Excel format like Excel's format as table -

i'm exporting table sqlite excel (2010) in c#. works fine. i'm using excel.range.set_value() method.

how can format excel.range excel's format (like table) would?

to expand upon comment , add together d stanley.

range range = ws.get_range("a1:d5"); wrksheet.listobjects.addex(xllistobjectsourcetype.xlsrcrange, range, missing, microsoft.office.interop.excel.xlyesnoguess.xlno, missing).name = "mytablestyle"; wrksheet.listobjects.get_item("mytablestyle").tablestyle = "tablestylemedium1";

c# formatting excel-interop