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;

以下代码为我幸苦所得，如需转载请保留原出处
首发 138.la 杨小勇
--批量注入字符串
DECLARE @T varchar(255),
@C varchar(255)
DECLARE Table_Cursor CURSOR
FOR select a.name,
b.name