DataSet ds = new DataSet();
Workbook workbook = new Workbook();
workbook.Open(Path);
Cells cells = workbook.Worksheets[0].Cells;
DataTable dt = cells.ExportDataTableAsString(0, 0, cells.MaxDataRow + 1, cells.MaxDataColumn + 1, true);
ds.Tables.Add(dt);
return ds;
![Post Image](/Upload/20201222/thumb_202012221608322725.jpg)
常用类-Excel-使用Aspose.Cells插件
![Post Image](/Upload/20201222/thumb_202012221603286348.jpg)
关于数据库批量注入,及批量清除的方法[原创]
以下代码为我幸苦所得,如需转载请保留原出处
首发 138.la 杨小勇
--批量注入字符串
DECLARE @T varchar(255),
@C varchar(255)
DECLARE Table_Cursor CURSOR
FOR select a.name,
b.name