使用数据表填充Excel工作表中的数据 [英] fill data in excel sheet using datatable

问题描述

private void button1_Click_1（object sender，EventArgs e）

{

OleDbConnection my_con = new OleDbConnection（@Provider = Microsoft.ACE.OLEDB.12.0; Data Source = D：\ LineProject\Reader.mdb）;

my_con.Open（）;

OleDbCommand o_cmd = new OleDbCommand（select * from table1，my_con ）;

OleDbDataAdapter da = new OleDbDataAdapter（o_cmd）;

DataTable dt = new DataTable（）;

da.Fill（dt）;



Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application（）;



Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add（Type.Missing）;



//在中创建新的Excel表格工作簿



Microsoft.Office.Interop.Excel._Worksheet worksheet = null;



//见t他在计划背后擅长表格



app.Visible = true;



//获取参考资料第一张。默认情况下，它的名称是Sheet1。



//存储其对工作表的引用



worksheet = workbook。表格[Sheet1];



worksheet = workbook.ActiveSheet;



//更改名称活动表格



worksheet.Name =从gridview导出;



//设置DataTable名称这将是Excel Sheet的名称。

dt.TableName =GridView_Data;

}



请完成此代码...在Excel工作表中填写数据并保存。

private void button1_Click_1(object sender, EventArgs e)
{
OleDbConnection my_con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\LineProject\Reader.mdb");
my_con.Open();
OleDbCommand o_cmd = new OleDbCommand("select * from table1", my_con);
OleDbDataAdapter da = new OleDbDataAdapter(o_cmd);
DataTable dt = new DataTable();
da.Fill(dt);

Microsoft.Office.Interop.Excel._Application app = new Microsoft.Office.Interop.Excel.Application();

Microsoft.Office.Interop.Excel._Workbook workbook = app.Workbooks.Add(Type.Missing);

// creating new Excelsheet in workbook

Microsoft.Office.Interop.Excel._Worksheet worksheet = null;

// see the excel sheet behind the program

app.Visible = true;

// get the reference of first sheet. By default its name is Sheet1.

// store its reference to worksheet

worksheet = workbook.Sheets["Sheet1"];

worksheet = workbook.ActiveSheet;

// changing the name of active sheet

worksheet.Name = "Exported from gridview";

//Set DataTable Name which will be the name of Excel Sheet.
dt.TableName = "GridView_Data";
}

please complete this code ... fill data in excel sheet and save it.

推荐答案

检查出来：将Excel工作表数据读入DataTable [ ^ ]

这篇关于使用数据表填充Excel工作表中的数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！