I would like to give my WorksheetTable a different name other than the default "Table1", "Table2", etc.
It looks like i can do something like this:
var myWorksheet = $("#spreadsheet1").igSpreadsheet("option", "workbook").worksheets().item("Sheet2"); myWorksheet.tables().item("Table1").source()._at = "MyTable";
Is there a better way? Is the line above safe to use?
I'm thinking we aren't supposed to use the underscore properties since they aren't documented but I can't find a better way.
Hello Brian,
in order to name a table you may use the 'name' method:
https://www.igniteui.com/help/api/2018.2/ig.excel.NamedReferenceBase#methods:name
Best regards,Alexander
Hi Alex,
This worked. Thank you.
I don't see a reference to the "name" method at https://www.igniteui.com/help/api/2017.1/ig.excel.WorksheetDataTable and I don't see a reference to the NamedReferenceBase there either. Can you please tell me how in the future I can make that relation on my own by reading the documentation?
The API for the igExcel engine is auto-generated based on the public classes available. I will discuss with the development team how it can be optimized and will create a task for improving the available igExcelEngine API as well as the online documentation: https://www.igniteui.com/help/javascript-excel-library
Thank you once more for your input on those topics!