DATASET 保存到EXCEL

[xuliangone1]

Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it. This exception is only raised if a debugger is attached to the process
什么原因？
VS2005 C# web

 public static void ExportToExcel(DataSet ds)
    {
        string saveFileName = "";
        //bool fileSaved = false;
        SaveFileDialog saveDialog = new SaveFileDialog();
        saveDialog.DefaultExt = "xls";
        saveDialog.Filter = "Excel文件|*.xls";
//////////////这里报错
        saveDialog.ShowDialog();////////////////////////这里报错
////////////////////////这里报错

        saveFileName = saveDialog.FileName;
        if (saveFileName.IndexOf(":") < 0) return; //被点了取消 
        Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
        if (xlApp == null)
        {
            MessageBox.Show("无法创建Excel对象，可能您的机子未安装Excel");
            return;
        }
        Microsoft.Office.Interop.Excel.Workbooks workbooks = xlApp.Workbooks;
        Microsoft.Office.Interop.Excel.Workbook workbook = workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);
        Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得sheet1 

        //写入标题
        for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
        {
            worksheet.Cells[1, i + 1] = ds.Tables[0].Columns[i].ToString();
        }
        //写入数值

        for (int r = 0; r < ds.Tables[0].Rows.Count; r++)
        {
            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                worksheet.Cells[r + 2, i + 1] = ds.Tables[0].Rows[r][i].ToString();
            }
            System.Windows.Forms.Application.DoEvents();
        }
        worksheet.Columns.EntireColumn.AutoFit();

        if (saveFileName != "")
        {
            try
            {
                workbook.Saved = true;
                workbook.SaveCopyAs(saveFileName);
            }
            catch (Exception ex)
            {
                MessageBox.Show("导出文件时出错,文件可能正被打开！\n" + ex.Message);
            }

        }
        xlApp.Quit();
        GC.Collect();//强行销毁 
        MessageBox.Show("导出Excel成功!");
    }

[我自横刀香甜笑]

Main函数有这个吗？[STAThread]

[bdmh]

        [STAThread]
        static void Main()

[骑着蜗牛去爬山]

给main函数加个attribute [STAThread]

[Ny-6000]

引用 3 楼 hjywyj 的回复:

给main函数加个attribute [STAThread]

+1