如何将数据库的数据源插入到Excel中去了? 我想先把是得到一个数据源,然后把数据源插入到Excel文件中去 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 使用Eexcel充当数据库: using System.Data.OleDb; OleDbConnection objConn = new OleDbConnection( "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strSampleFolder + "new.xls;Extended Properties=Excel 8.0;"); objConn.Open(); // Add two records to the table named 'MyTable'. OleDbCommand objCmd = new OleDbCommand(); objCmd.Connection = objConn; objCmd.CommandText = "CREATE TABLE MyTable (FirstName char(255),LastName char(255))"; objCmd.ExecuteNonQuery(); objCmd.CommandText = "Insert into MyTable (FirstName, LastName)" + " values ('shao', 'zhidong')"; objCmd.ExecuteNonQuery(); objCmd.CommandText = "Insert into MyTable (FirstName, LastName)" + " values ('张', '三')"; objCmd.ExecuteNonQuery(); // Close the connection. objConn.Close();使用Excel组件: private Excel.Application objExcel = null; private Excel.Workbooks objBooks = null; private Excel._Workbook objBook = null; private Excel.Sheets objSheets = null; private Excel._Worksheet objSheet = null; private Excel.Range objRange = null; private Excel.Font objFont = null; protected void btnAuto_Click(object sender, System.EventArgs e) { // Start a new workbook in Excel. objExcel = new Excel.Application(); objBooks = (Excel.Workbooks)objExcel.Workbooks; objBook = (Excel._Workbook)(objBooks.Add(objOpt)); // Add data to cells of the first worksheet in the new workbook. objSheets = (Excel.Sheets)objBook.Worksheets; objSheet = (Excel._Worksheet)(objSheets.get_Item(1)); objRange = objSheet.get_Range("A1", objOpt); objRange.set_Value(objOpt,"Last Name"); objRange = objSheet.get_Range("B1", objOpt); objRange.set_Value(objOpt,"First Name"); objRange = objSheet.get_Range("A2", objOpt); objRange.set_Value(objOpt,"shao"); objRange = objSheet.get_Range("B2", objOpt); objRange.set_Value(objOpt,"zhidong"); // Apply bold to cells A1:B1. objRange = objSheet.get_Range("A1", "B1"); objFont = objRange.Font; objFont.Bold=true; // Save the workbook and quit Excel. objBook.SaveAs(strSampleFolder + "Book1.xls", objOpt, objOpt, objOpt, objOpt, objOpt, Excel.XlSaveAsAccessMode.xlNoChange, objOpt, objOpt, objOpt, objOpt, objOpt); objBook.Close(false, objOpt, objOpt); objExcel.Quit(); } IIS网站响应超时 有没有比较有效的办法解决啊 C# From_Load和Button_Click 问题?? 菜菜的问题! webBrowser将word显示后,如何在winform中控制其中的word文档? 关于控件生成的问题!急~~~~~~~~~~ 关于权限的问题,请问怎么处理比较好 关于DataGrid查询显示的问题 平砚,快往这看! 咨询csdn:发表了top文章,能不能给我寄本书?散分200庆贺 公开招标:数据传输控件 谁能给我一个Sockets编程方面的示例?高分等待您的指导! C# Winform DataGridView 横向显示
using System.Data.OleDb;
OleDbConnection objConn = new OleDbConnection(
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + strSampleFolder +
"new.xls;Extended Properties=Excel 8.0;");
objConn.Open(); // Add two records to the table named 'MyTable'.
OleDbCommand objCmd = new OleDbCommand();
objCmd.Connection = objConn;
objCmd.CommandText = "CREATE TABLE MyTable (FirstName char(255),LastName char(255))";
objCmd.ExecuteNonQuery();
objCmd.CommandText = "Insert into MyTable (FirstName, LastName)" +
" values ('shao', 'zhidong')";
objCmd.ExecuteNonQuery();
objCmd.CommandText = "Insert into MyTable (FirstName, LastName)" +
" values ('张', '三')";
objCmd.ExecuteNonQuery();
// Close the connection.
objConn.Close();使用Excel组件:
private Excel.Application objExcel = null;
private Excel.Workbooks objBooks = null;
private Excel._Workbook objBook = null;
private Excel.Sheets objSheets = null;
private Excel._Worksheet objSheet = null;
private Excel.Range objRange = null;
private Excel.Font objFont = null; protected void btnAuto_Click(object sender, System.EventArgs e)
{
// Start a new workbook in Excel.
objExcel = new Excel.Application();
objBooks = (Excel.Workbooks)objExcel.Workbooks;
objBook = (Excel._Workbook)(objBooks.Add(objOpt)); // Add data to cells of the first worksheet in the new workbook.
objSheets = (Excel.Sheets)objBook.Worksheets;
objSheet = (Excel._Worksheet)(objSheets.get_Item(1));
objRange = objSheet.get_Range("A1", objOpt);
objRange.set_Value(objOpt,"Last Name");
objRange = objSheet.get_Range("B1", objOpt);
objRange.set_Value(objOpt,"First Name");
objRange = objSheet.get_Range("A2", objOpt);
objRange.set_Value(objOpt,"shao");
objRange = objSheet.get_Range("B2", objOpt);
objRange.set_Value(objOpt,"zhidong"); // Apply bold to cells A1:B1.
objRange = objSheet.get_Range("A1", "B1");
objFont = objRange.Font;
objFont.Bold=true; // Save the workbook and quit Excel.
objBook.SaveAs(strSampleFolder + "Book1.xls", objOpt, objOpt,
objOpt, objOpt, objOpt, Excel.XlSaveAsAccessMode.xlNoChange,
objOpt, objOpt, objOpt, objOpt, objOpt);
objBook.Close(false, objOpt, objOpt);
objExcel.Quit();
}