如何在不显示 Excel 互操作的保存对话框的情况下保存工作簿? [英] How to save workbook without showing save dialog with Excel interop?

问题描述

我必须创建一个控制台应用程序，将 DataSet 导出到 Excel.问题是它不应该弹出保存窗口，它应该自动创建 Excel 文件.到目前为止，我有以下代码，但我不知道如何让它自动保存.将不胜感激.

I have to create a Console application that exports a DataSet to Excel. The problem is that it shouldn't pop up the save window, it should automatically create the Excel file. So far I have the following code, but I don't know how to make it save automatically. Would appreciate any help.

public static void CreateWorkbook(DataSet ds, String path)
{
    int rowindex = 0;
    int columnindex = 0;

    Microsoft.Office.Interop.Excel.Application wapp = new Microsoft.Office.Interop.Excel.Application();
    Microsoft.Office.Interop.Excel.Worksheet wsheet;
    Microsoft.Office.Interop.Excel.Workbook wbook;

    wapp.Visible = false;

    wbook = wapp.Workbooks.Add(true);
    wsheet = (Worksheet)wbook.ActiveSheet;

    try
    {
        for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
        {
            wsheet.Cells[1, i + 1] = ds.Tables[0].Columns[i].ColumnName;

        }

        foreach (DataRow row in ds.Tables[0].Rows)
        {
            rowindex++;
            columnindex = 0;
            foreach (DataColumn col in ds.Tables[0].Columns)
            {
                columnindex++;
                wsheet.Cells[rowindex + 1, columnindex] = row[col.ColumnName];
            }
        }
    }
    catch (Exception ex)
    {
        String err = ex.Message;
    }
    wapp.UserControl = true;
}

推荐答案

WorkBook.SaveAs() 的所有参数都是可选的，但您可以只使用 Type.Missing 如果您愿意，可以为其中的大多数提供.

All of the arguments to WorkBook.SaveAs() are optional, but you can just use Type.Missing for most of them if you want to.

典型的调用如下所示:

wbook.SaveAs("c:\temp\blah", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Type.Missing, Type.Missing,
            false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
            Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
wbook.Close();

请注意，我没有包含文件扩展名；Excel 会为您设置.

Note that I didn't include the file extension; Excel will set that for you.

Workbook.SaveAs 方法 (Microsoft.Office.Tools.Excel) |Microsoft Docs 描述了每个参数.

这篇关于如何在不显示 Excel 互操作的保存对话框的情况下保存工作簿?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！