第1个回答 2019-05-07
public
void
CreateExcel(
string
fileName)
{
Object
missing
=
Missing.Value;
Microsoft.Office.Interop.Excel.Application
m_objExcel
=
new
Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbooks
m_objWorkBooks
=
m_objExcel.Workbooks;
Microsoft.Office.Interop.Excel.Workbook
m_objWorkBook
=
m_objWorkBooks.Add(true);
Microsoft.Office.Interop.Excel.Sheets
m_objWorkSheets
=
m_objWorkBook.Sheets;
;
Microsoft.Office.Interop.Excel.Worksheet
m_objWorkSheet
=
(Microsoft.Office.Interop.Excel.Worksheet)m_objWorkSheets[1];
m_objWorkBook.SaveAs(fileName,
missing,
missing,
missing,
missing,
missing,
Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
missing,
missing,
missing,
missing,
missing);
m_objWorkBook.Close(false,missing,missing);
m_objExcel.Quit();
}
相信你对如何使用saveFileDialog是清楚的,调用上边的函数,需要的参数是文件存放路径。good
luck!
第2个回答 2011-08-26
现将excel的格式写到ascx的控制项里面,然後通过属性给他赋值,
最後把控件另存为文档.
操作嘛,嘿嘿,就重新赋值,重复上面的过程.