[CONNECT C#] Programmatically create table using Excel table

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.