导出Excel文件代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】导出Excel文件

作者:auspi12341 / 发布于2013/10/23/ 424


	protected void Page_Load(object sender, EventArgs e)
	 {
	 MakeDataTableAndDisplay();
	 }
	 protected void btnOk_Click(object sender, EventArgs e)
	 {
	 dao();
	 }

	 public DataSet dss
	 {
	 get;
	 set;
	 }

	 public System.Data.DataTable dtt
	 {
	 get;
	 set;
	 }

	 public void dao()
	 {
	 string name = "这个是测试文件名.xlsx";
	 if (name.Length > 5 && name.ToLower().Substring(name.Length - 5, 5) == ".xlsx")
	 {
	 if (dtt.Rows[0][0].ToString() == "") { MessageBox.Show("dt is NULL"); return; }

	 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 = dtt.Rows.Count;
	 int tbCoC = dtt.Columns.Count;

	 long rowRead = 0;
	 float percent = 0f;

	 for (int i = 0; i < tbCoC; i++)
	 {
	 workSheet.Cells[1, i + 1] = dtt.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] = dtt.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;
	 workBook.SaveCopyAs(@"E:\cs\" + name);
	 }
	 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();
	 }
	 }

	 MessageBox.Show("完毕");
	 }
	 else
	 {
	 MessageBox.Show("请浏览到Excel文件", "W");
	 }
	
	 }

	
	 private void MakeDataTableAndDisplay()
	 {
	 // Create new DataTable and DataSource objects.
	 System.Data.DataTable table = new System.Data.DataTable();
	 // Declare DataColumn and DataRow variables.
	 DataColumn column;
	 DataRow row;
	 DataView view;
	 DataSet ds = new DataSet();
	 // Create new DataColumn, set DataType, ColumnName and add to DataTable.
	 column = new DataColumn();
	 column.DataType = System.Type.GetType("System.Int32");
	 column.ColumnName = "id";
	 table.Columns.Add(column);
	 // Create second column.
	 column = new DataColumn();
	 column.DataType = Type.GetType("System.String");
	 column.ColumnName = "item";
	 table.Columns.Add(column);
	 // Create new DataRow objects and add to DataTable.
	 for (int i = 0; i < 10; i++)
	 {
	 row = table.NewRow();
	 row["id"] = i;
	 row["item"] = "item " + i.ToString();
	 table.Rows.Add(row);
	 }
	 // Create a DataView using the DataTable.
	 view = new DataView(table);
	 ds.Tables.Add(table);
	 dss = ds;
	 dtt = table;
	
	 }

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　导出Excel　

同语言下

可能有用的

auspi12341贡献的其它代码(1)

.导出Excel文件