internal Worksheet(Interop.Excel.Worksheet worksheet) { this.worksheet = worksheet; }
internal Worksheet(Interop.Excel.Worksheet worksheet) { this.worksheet = worksheet; }
//导出Excel private void ExportExcel1() { // 定义要使用的Excel 组件接口 // 定义Application 对象,此对象表示整个Excel 程序 Interop.Excel.Application excelApp = null; Interop.Excel.Workbook workBook = null; Interop.Excel.Worksheet ws = null; Interop.Excel.Range r; int row = 1; int cell = 1; int i = 0; int Count = 0; try { //初始化 Application 对象 excelApp excelApp = new Interop.Excel.Application(); workBook = excelApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet); ws = (Worksheet)workBook.Worksheets[1]; // 命名工作表的名称为 "Task Management" ws.Name = "Soukey导出数据"; // 遍历数据表中的所有列 for (i = 0; i < m_pData.Columns.Count; i++) { ws.Cells[row, cell] = m_pData.Columns[i].ColumnName; r = (Range)ws.Cells[row, cell]; ws.get_Range(r, r).HorizontalAlignment = Interop.Excel.XlVAlign.xlVAlignCenter; cell++; } Count = m_pData.Rows.Count; // 创建行,把数据视图记录输出到对应的Excel 单元格 for (i = 0; i < m_pData.Rows.Count; i++) { for (int j = 0; j < m_pData.Columns.Count; j++) { ws.Cells[i + 2, j + 1] = m_pData.Rows[i][j]; Range rg = (Range)ws.get_Range(ws.Cells[i + 2, j + 1], ws.Cells[i + 2, j + 1]); rg.EntireColumn.ColumnWidth = 20; rg.NumberFormatLocal = "@"; } //更新进度条信息 m_sender.BeginInvoke(m_senderDelegate, new object[] { Count, i, false }); } workBook.SaveCopyAs(m_FileName); workBook.Saved = true; } catch (System.Exception) { return; } finally { excelApp.UserControl = false; excelApp.Quit(); System.Runtime.InteropServices.Marshal.ReleaseComObject(ws); System.Runtime.InteropServices.Marshal.ReleaseComObject(workBook); System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp); GC.Collect(); //更新进度条为完成,并传递参数表示导出任务完成 m_sender.BeginInvoke(m_senderDelegate, new object[] { Count, i, true }); } return; }