【Devexpres】spreadsheetControl自动列宽

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

 

posted @ 2022-11-14 18:38  Sqsdhc  阅读(80)  评论(0)    收藏  举报