有多个工作簿的Excel该如何导出？

[frankfuse]

用Asp.net，导出具有多个工作簿的Excel. 请给点提示或建议，谢谢

[wxd_860825]

导出多个excel,比较容易

[lemong]

Excel组件访问，可以导出多个工作簿，但是慢，效率很差
建议导出多个Excel

[Lovely_baby]

可以用Excel.Application
具体可以参照msdn的参考手册
关于在服务器端使用Office Application，请参照
http://blog.joycode.com/kaneboy/archive/2005/11/04/66364.aspx

及其相关文章

[lemong]

//Microsoft.Office.Interop.Excel.Application xlsApp = new Microsoft.Office.Interop.Excel.Application();
            //Workbooks workBooks = xlsApp.Workbooks;
            //Workbook workBook = workBooks.Add(XlWBATemplate.xlWBATWorksheet);
            //Worksheet workSheet = (Worksheet)workBook.Worksheets[1];
            //Range range = null;

            //long tbRoC = dt.Tables[0].Rows.Count;
            //int tbCoC = dt.Tables[0].Columns.Count;

            //long rowRead = 0;
            //float percent = 0f;

            //for (int i = 0; i < tbCoC; i++)
            //{
            //    workSheet.Cells[1, i + 1] = dt.Tables[0].Columns[i].ColumnName;
            //    range = (Range)workSheet.Cells[1, i + 1];
            //}

            //for (int r = 0; r < tbRoC; r++)
            //{
            //    for (int i = 0; i < tbCoC; i++)
            //    {
            //        workSheet.Cells[r + 2, i + 1] = dt.Tables[0].Rows[r][i];
            //        range = (Range)workSheet.Cells[r + 2, i + 1];
            //        range.EntireColumn.AutoFit();
            //    }

            //    percent = ((float)((++rowRead) * 100)) / tbRoC;

            //    System.Windows.Forms.Application.DoEvents();
            //}

            //try
            //{

            //    workBook.Saved = true;

            //    string path = fileSavePath;

            //    workBook.SaveCopyAs(path);

            //    fileSaveDirectory += lastName + ":\r\n" + path + "\r\n";
            //}
            //catch (Exception ex)
            //{
            //    MessageBox.Show(ex.ToString(), "Error for Save, maybe, this xls is opend");
            //}
            //finally
            //{
            //    workBooks.Close();
            //    if (xlsApp != null)
            //    {
            //        xlsApp.Workbooks.Close();
            //        xlsApp.Quit();

            //        int gc = GC.GetGeneration(xlsApp);
            //        System.Runtime.InteropServices.Marshal.ReleaseComObject(xlsApp);
            //        xlsApp = null;

            //        GC.Collect(gc);
            //    }
            //    GC.Collect();


            //    Process[] p = Process.GetProcessesByName("EXCEL");

            //    for (int i = 0; i < p.Length; i++)
            //    {
            //        p[i].Kill();
            //    }
            //}