Worksheet worksheet = this.spreadsheetControl1.ActiveWorksheet;
worksheet.Import(datatable, true, 0, 0);
var da = worksheet.GetDataRange();//获得有数据的区域
worksheet.Columns.AutoFit(0, da.ColumnCount);//从0列到有数据的列自动列宽
Worksheet worksheet = this.spreadsheetControl1.ActiveWorksheet;
worksheet.Import(datatable, true, 0, 0);
var da = worksheet.GetDataRange();//获得有数据的区域
worksheet.Columns.AutoFit(0, da.ColumnCount);//从0列到有数据的列自动列宽