如何把一个dataset中的多张table导入到excel里的不同sheets 请问如何把一个dataset中的多张table导入到excel里的不同sheets呢.每张表对应一个相应的sheet 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 dataset.Tables[i].Rows[][]不同table单元格的内容依次写到excel的不同sheet中。你可以搜搜如何往excel中导入数据。再按这个试试。 excel中sheet的名字是固定的,要把对应的table导进去... Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.ApplicationClass(); Object missing = System.Reflection.Missing.Value; Microsoft.Office.Interop.Excel.Workbooks m_objWorkBooks = app.Workbooks; Microsoft.Office.Interop.Excel.Workbook m_objWorkBook = m_objWorkBooks.Add(true); //Microsoft.Office.Interop.Excel.Sheets m_objWorkSheets = m_objWorkBook.Sheets; m_objWorkBook = app.Workbooks.Open(sourcefilePath, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing); Microsoft.Office.Interop.Excel.Worksheet m_objWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)m_objWorkBook.Sheets[1]; try { app.Visible = false; if (excelTable.Rows.Count > 0) { int row = 0; row = excelTable.Rows.Count; int col = excelTable.Columns.Count; for (int i = 0; i < row; i++) { for (int j = 0; j < col; j++) { string str = excelTable.Rows[i][j].ToString(); m_objWorkSheet.Cells[i + 3, j + 1] = str; } } }// 设置禁止弹出保存和覆盖的询问提示框 app.DisplayAlerts = false; app.AlertBeforeOverwriting = false; //保存excel文件 m_objWorkSheet.SaveAs(sourcefilePath, missing, missing, missing, missing, missing, missing, missing, missing, missing); //app.PrintPreview(); app.Quit(); app = null;不同sheet设定活动状态Microsoft.Office.Interop.Excel.Worksheet m_objWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)m_objWorkBook.Sheets[1];sheet[1],sheet[2].. 在C#怎么获取系统时间到毫秒 求好心人给个简单的WEB OA系统源代码!! C# 我要怎样才能修改DataTable中符合条件的数据 变量类型:既数值类型和引用类型对内存和CPU而言其作用是什么? C# 怎样在主线程中关闭一个线程呢? 关于HttpWebRequest中使用socks代理的问题 購物車中的數據用什麼方式保存比較好? 一个关于数据流的问题 急问!!!(答案满意一定给分) 我的 RichTextBox 为什么不能正常使用? byte数组问题 为什么加断点的时候执行不加断点的时候不执行哇
你可以搜搜如何往excel中导入数据。再按这个试试。
Microsoft.Office.Interop.Excel.Application app =
new Microsoft.Office.Interop.Excel.ApplicationClass();
Object missing = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Excel.Workbooks m_objWorkBooks = app.Workbooks;
Microsoft.Office.Interop.Excel.Workbook m_objWorkBook = m_objWorkBooks.Add(true);
//Microsoft.Office.Interop.Excel.Sheets m_objWorkSheets = m_objWorkBook.Sheets;
m_objWorkBook = app.Workbooks.Open(sourcefilePath, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
Microsoft.Office.Interop.Excel.Worksheet m_objWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)m_objWorkBook.Sheets[1];
try
{
app.Visible = false;
if (excelTable.Rows.Count > 0)
{
int row = 0;
row = excelTable.Rows.Count;
int col = excelTable.Columns.Count;
for (int i = 0; i < row; i++)
{
for (int j = 0; j < col; j++)
{
string str = excelTable.Rows[i][j].ToString();
m_objWorkSheet.Cells[i + 3, j + 1] = str;
}
}
}
// 设置禁止弹出保存和覆盖的询问提示框
app.DisplayAlerts = false;
app.AlertBeforeOverwriting = false;
//保存excel文件
m_objWorkSheet.SaveAs(sourcefilePath, missing, missing, missing, missing, missing, missing, missing, missing, missing);
//app.PrintPreview();
app.Quit();
app = null;不同sheet设定活动状态Microsoft.Office.Interop.Excel.Worksheet m_objWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)m_objWorkBook.Sheets[1];
sheet[1],sheet[2]..