I have a spreadshhet I just created, I get a WorksheetRegion and use the FormatAsTable method. I now have a table that uses the default Excel style. I want to be able to have no style on this table. This would be the equivalent of using the COM command below
ActiveSheet.ListObjects("Table1").TableStyle = ""
Nothing I've tried removes the style or allows me to add a table with no style. I can change the style fine, removing is the problem.
Any ideas?
Thanks,
Tom
Hello Tom,
The DefaultTableStyle is set to TableStyleMedium2 which is from my understanding what you wish to change or remove. Keep in mind passing null as the second paramter when calling FormatAsTable will set this table style.
Our online documentation explains this and more about setting any WorkSheetTableStyle in the CustomTableStyles or StandardTableStyles collection.
http://help.infragistics.com/doc/WinForms/2014.2/CLR4.0/?page=Infragistics4.Documents.Excel.v14.2~Infragistics.Documents.Excel.Workbook~DefaultTableStyle.html
Excel doesn't have any blank table styles that I am aware of. Let me know if you have any questions regardingt this matter.
Everything you say is correct, yet I still don't know how to have a table with no style. In. Excel, it's easy to select, in the style selector, a style labelled None. Doing this results in the VBA code I posted.
i would like to be able to get this result using Infragistics.