I've found examples of how to create a text table in CONNECT Edition from scratch then filling the table out. Is there a way to programmatically create a table with and excel linkage? The manual tool does the job I need but the user has to manually create each table and connection, I'd like to automate that process for an Excel file that has many tabs with varying ranges.
Ideally, there would be a TextTableDataSource that can be linked to Excel. Then we could use that source to create a table as you desire.
However, Paul Connelly commented: That class and its subclasses were created solely to allow us to implement the EC type converter used to change the data source from within the Properties dialog. It is not intended to serve as a .NET version of the native type. If you want to do things with TextTables, use the C++ API.
Regards, Jon Summers LA Solutions
Answer Verified By: Mike Robertson