Structured reference cell range enhancement for ExcelTable

[minren118]

I like using ExcelTable very much, because it can structure the data well, and it will be very easy and semantically clear to reference the data of a specific row or column, but in EPPLUS, compared with the object model interface of VBA, there are still some shortcomings in use, such as I want to reference a column's header area, data area, summary area, etc. There's no easy way to do it. But in VBA, there are direct properties that are easily accessible.

in EPPLUS,need to refer the col data range like below
var colName = excelTable.Columns["col10"].Position;
var colDataRange =excelTable.Range.TakeSingleColumn(colIndex).SkipRows(1);

but in VBA ，just like this

var colDataRange =excelTable.ListColumns("col10").DataRange

https://learn.microsoft.com/en-us/office/vba/api/excel.listcolumn
https://learn.microsoft.com/en-us/office/vba/api/excel.listrow

And Also the Resize method is usefull (Does not affect the relative absolute reference of other cell formulas)，Or, similar to LoadFromCollection, automatically extend the row range of ExcelTable, and other cell positions or formula references are automatically changed relative or absolute references.