excel 导出多个sheet页

前进的步伐 2013-12-05 05:06:52

如何将多个组好的文本如下
(<html><head><title></title></head><body>里面是带样式的table</body></html>)
导入到各个sheet页

...全文

268 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

Swu_level 2013-12-06

打赏
举报

/// <summary> /// 将DataTable转换为WorkSheet /// </summary> /// <param name="dataTable"></param> /// <returns></returns> private static string TableToWorksheet(DataTable dataTable) { if (null==dataTable||dataTable.Rows.Count==0) { return string.Empty; } StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("<Worksheet ss:Name='" + dataTable.TableName.ToString() + "'>"); stringBuilder.Append("<Table x:FullColumns='1' x:FullRows='1'>"); //输出标题 stringBuilder.Append("rn<Row ss:AutoFitHeight='1'>"); foreach (DataColumn tableColumn in dataTable.Columns) { stringBuilder.AppendFormat("<Cell ss:StyleID='Header'><Data ss:Type='String'>{0}</Data></Cell>", tableColumn.ColumnName.ToString()); } stringBuilder.Append("rn</Row>"); foreach(DataRow row in dataTable.Rows) { stringBuilder.Append("<Row>"); foreach (DataColumn tableColumn in dataTable.Columns) { stringBuilder.AppendFormat("<Cell ss:StyleID='border'><Data ss:Type='String'>{0}</Data></Cell>", row[tableColumn].ToString()); } stringBuilder.Append("</Row>"); } stringBuilder.Append("</Table>"); stringBuilder.Append("</Worksheet>"); return stringBuilder.ToString(); }

前进的步伐 2013-12-06