从数据库读出数据到excel完整代码
来源:互联网 发布:淘宝5金冠店铺 编辑:程序博客网 时间:2024/05/16 08:23
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;
using System.IO;
using System.Reflection;
using System.Data.Sql;
using System.Data.SqlClient;
namespace ExcleTest
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
DataTable dt;
private void button1_Click(object sender, EventArgs e)
{
string connStr = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=RiskAssesment;Data Source=.";
SqlConnection conn = new SqlConnection(connStr);
conn.Open(); //打开数据库
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from PipeClass";
SqlDataAdapter sda = new SqlDataAdapter(cmd.CommandText, conn);
DataSet ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
dt = ds.Tables[0];
conn.Close();
}
private void button2_Click(object sender, EventArgs e )
{
string s=@"G:\c#\ExcleTest\ExcleTest\XLS\11.xls";
CreateExcel(dt,s);
}
public void CreateExcel(DataTable dt, string fileName)
{
System.Diagnostics.Process[] arrProcesses;
arrProcesses = System.Diagnostics.Process.GetProcessesByName("Excel");
foreach (System.Diagnostics.Process myProcess in arrProcesses)
{
myProcess.Kill();
}
Object missing = Missing.Value;
Microsoft.Office.Interop.Excel.Application m_objExcel =
new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbooks m_objWorkBooks = m_objExcel.Workbooks;
Microsoft.Office.Interop.Excel.Workbook m_objWorkBook = m_objWorkBooks.Add(true);
Microsoft.Office.Interop.Excel.Sheets m_objWorkSheets = m_objWorkBook.Sheets; ;
Microsoft.Office.Interop.Excel.Worksheet m_objWorkSheet =
(Microsoft.Office.Interop.Excel.Worksheet)m_objWorkSheets[1];
int intFeildCount = dt.Columns.Count;
for (int col = 0; col < intFeildCount; col++)
{
m_objWorkSheet.Cells[1, col + 1] = dt.Columns[col].ToString();
}
for (int intRowCount = 0; intRowCount < dt.Rows.Count; intRowCount++)
{
for (int intCol = 0; intCol < dt.Columns.Count; intCol++)
{
m_objWorkSheet.Cells[intRowCount + 2, intCol + 1] = "'" + dt.Rows[intRowCount][intCol].ToString();
}
}
if (File.Exists(fileName))
{
File.Delete(fileName);
}
m_objWorkBook.SaveAs(fileName, missing, missing, missing, missing,
missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
missing, missing, missing, missing, missing);
m_objExcel = null;
}
}
}
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;
using System.IO;
using System.Reflection;
using System.Data.Sql;
using System.Data.SqlClient;
namespace ExcleTest
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
DataTable dt;
private void button1_Click(object sender, EventArgs e)
{
string connStr = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=RiskAssesment;Data Source=.";
SqlConnection conn = new SqlConnection(connStr);
conn.Open(); //打开数据库
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from PipeClass";
SqlDataAdapter sda = new SqlDataAdapter(cmd.CommandText, conn);
DataSet ds = new DataSet();
sda.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
dt = ds.Tables[0];
conn.Close();
}
private void button2_Click(object sender, EventArgs e )
{
string s=@"G:\c#\ExcleTest\ExcleTest\XLS\11.xls";
CreateExcel(dt,s);
}
public void CreateExcel(DataTable dt, string fileName)
{
System.Diagnostics.Process[] arrProcesses;
arrProcesses = System.Diagnostics.Process.GetProcessesByName("Excel");
foreach (System.Diagnostics.Process myProcess in arrProcesses)
{
myProcess.Kill();
}
Object missing = Missing.Value;
Microsoft.Office.Interop.Excel.Application m_objExcel =
new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbooks m_objWorkBooks = m_objExcel.Workbooks;
Microsoft.Office.Interop.Excel.Workbook m_objWorkBook = m_objWorkBooks.Add(true);
Microsoft.Office.Interop.Excel.Sheets m_objWorkSheets = m_objWorkBook.Sheets; ;
Microsoft.Office.Interop.Excel.Worksheet m_objWorkSheet =
(Microsoft.Office.Interop.Excel.Worksheet)m_objWorkSheets[1];
int intFeildCount = dt.Columns.Count;
for (int col = 0; col < intFeildCount; col++)
{
m_objWorkSheet.Cells[1, col + 1] = dt.Columns[col].ToString();
}
for (int intRowCount = 0; intRowCount < dt.Rows.Count; intRowCount++)
{
for (int intCol = 0; intCol < dt.Columns.Count; intCol++)
{
m_objWorkSheet.Cells[intRowCount + 2, intCol + 1] = "'" + dt.Rows[intRowCount][intCol].ToString();
}
}
if (File.Exists(fileName))
{
File.Delete(fileName);
}
m_objWorkBook.SaveAs(fileName, missing, missing, missing, missing,
missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
missing, missing, missing, missing, missing);
m_objExcel = null;
}
}
}
- 从数据库读出数据到excel完整代码
- 从EXCEL中读出数据到数据库中
- 如何把从数据库读出来的数据以excel格式显示到网页?
- excel-从excel导入数据到数据库
- struts2数据库数据读出excel poi
- 用Java JXL实现从excel读出数据转入数据库及例子
- 用Java JXL实现从excel读出数据转入数据库及例子
- 从数据库中写数据到EXCEL
- 从数据库导出数据到Excel
- 从excel导入数据到数据库
- 从excel导入数据到数据库
- 从数据库中读取数据到Excel
- 从数据库读出数据动态生成菜单栏
- 图片保存到数据及从数据库读出(winform,c# 和vb.net)
- 打开页面从数据库读出数据显示到页面上的解决方法
- 把图像文件上传到数据库,并从数据库读出
- 文件保存到数据库/从数据库读出写成文件
- 文件保存到数据库/从数据库读出写成文件
- 运算符
- 文本比较算法Ⅱ——Needleman/Wunsch算法
- rake 出现问题的解决方式
- JAVA多线程之Lock的使用
- Pygame学习(3)-----如何对图像进行翻转,缩放,旋转
- 从数据库读出数据到excel完整代码
- Java自学视频整理(持续更新中...)
- java中文乱码过滤器
- hdu1398 Square Coins(生成函数)
- 贝叶斯推断及其互联网应用(二):过滤垃圾邮件
- 数据库style
- LINK : fatal error LNK1000: Internal error during IncrBuildImage
- 捕捉鼠标拖动和鼠标移动事件
- JS 的选择