110,537
社区成员
发帖
与我相关
我的任务
分享
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;