.NET - Excel ListObject在数据绑定上自动调整大小

using System;
using System.Data;
using System.IO;
using Excel = Microsoft.Office.Interop.Excel;

namespace ExcelListObjectDataBinding
{
    class Program
    {
        static void Main(string[] args)
        {
            // 创建一个 DataTable 作为数据源
            DataTable dataTable = new DataTable();
            dataTable.Columns.Add("Name", typeof(string));
            dataTable.Columns.Add("Age", typeof(int));
            dataTable.Columns.Add("Gender", typeof(string));
            dataTable.Rows.Add("Alice", 25, "Female");
            dataTable.Rows.Add("Bob", 30, "Male");
            dataTable.Rows.Add("Charlie", 35, "Male");

            // 创建一个 Excel 工作簿
            Excel.Application excelApp = new Excel.Application();
            excelApp.Visible = true;
            Excel.Workbook workbook = excelApp.Workbooks.Add();

            // 创建一个 ListObject 对象并将其与数据源绑定
            Excel.ListObject listObject = workbook.ActiveSheet.ListObjects.AddEx(Excel.XlListObjectSourceType.xlSrcRange, 
                workbook.ActiveSheet.Range["A1"], 
                Type.Missing, 
                Excel.XlYesNoGuess.xlYes, 
                Type.Missing);
            listObject.TableObject.Resize(workbook.ActiveSheet.Range["A1:C4"]);
            listObject.TableObject.DataBodyRange.AutoFit();
            listObject.TableObject.HeaderRowRange.AutoFit();
            listObject.TableObject.ListColumns[1].DataBodyRange.NumberFormat = "0";
            listObject.TableObject.ListColumns[2].DataBodyRange.NumberFormat = "0";
            listObject.TableObject.DisplayName = "MyTable";
            listObject.TableObject.ListColumns[1].Name = "Age";
            listObject.TableObject.ListColumns[2].Name = "Gender";
            listObject.TableObject.ListColumns[3].Name = "Name";
            listObject.TableObject.ListColumns[1].Range.ColumnWidth = 10;
            listObject.TableObject.ListColumns[2].Range.ColumnWidth = 10;
            listObject.TableObject.ListColumns[3].Range.ColumnWidth = 20;
            listObject.TableObject.ListRows[1].Range.RowHeight = 20;

            // 将数据源填充到表格中
            listObject.TableObject.SetDataSource(dataTable, Type.Missing, Type.Missing);

            // 保存工作簿
            workbook.SaveAs("MyTable.xlsx");

            // 退出 Excel 应用程序
            excelApp.Quit();
        }
    }
}