欧美成人精品手机在线观看_69视频国产_动漫精品第一页_日韩中文字幕网 - 日本欧美一区二区

先設置日期格式，再加載數據。

//Create the worksheet
string sheetName = string.IsNullOrEmpty(sourceTable.TableName) ? "Sheet1" : sourceTable.TableName;
ExcelWorksheet ws = pck.Workbook.Worksheets.Add(sheetName);
ws.Column(16).Style.Numberformat.Format = "yyyy-MM-dd HH:mm:ss"; //第16列
ws.Column(23).Style.Numberformat.Format = "yyyy-MM-dd HH:mm:ss"; //第23列
ws.Column(30).Style.Numberformat.Format = "yyyy-MM-dd HH:mm:ss"; //第30列
//Load the datatable into the sheet, starting from cell A1. Print the column names on row 1
ws.Cells["A1"].LoadFromDataTable(sourceTable, true);