下面是一个简单的 C# 类,它以编程方式创建 Excel WorkBook 并向其中添加两个工作表,然后填充这两个工作表。最后,它将工作簿保存到应用程序根目录中的文件中,以便您可以检查结果...
public class Tyburn1
{
object missing = Type.Missing;
public Tyburn1()
{
Excel.Application oXL = new Excel.Application();
oXL.Visible = false;
Excel.Workbook oWB = oXL.Workbooks.Add(missing);
Excel.Worksheet oSheet = oWB.ActiveSheet as Excel.Worksheet;
oSheet.Name = "The first sheet";
oSheet.Cells[1, 1] = "Something";
Excel.Worksheet oSheet2 = oWB.Sheets.Add(missing, missing, 1, missing)
as Excel.Worksheet;
oSheet2.Name = "The second sheet";
oSheet2.Cells[1, 1] = "Something completely different";
string fileName = Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location)
+ "\\SoSample.xlsx";
oWB.SaveAs(fileName, Excel.XlFileFormat.xlOpenXMLWorkbook,
missing, missing, missing, missing,
Excel.XlSaveAsAccessMode.xlNoChange,
missing, missing, missing, missing, missing);
oWB.Close(missing, missing, missing);
oXL.UserControl = true;
oXL.Quit();
}
}
为此,您需要将对 Microsoft.Office.Interop.Excel 的引用添加到您的项目中(您可能已经在创建一张工作表时执行了此操作)。
添加第二张表的语句是...
Excel.Worksheet oSheet2 = oWB.Sheets.Add(missing, missing, 1, missing)
as Excel.Worksheet;
“1”参数指定单个工作表,如果您想一次添加多个工作表,则可以指定更多个工作表。
最后注意:语句 oXL.Visible = false;告诉 Excel 以静默模式启动。