怎样把页面保存为word格式;怎样把数据转换为格Execel式;比较急!!谢谢! 一是用MS提供的word和excel组件,自己做一个dll来完成转换。二是用WPS等提供的相应功能来实现。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 using System;using System.Drawing;using System.Collections;using System.ComponentModel;using System.Windows.Forms;using System.Data;using System.Data.OleDb;namespace WindowsApplication5{ /// <summary> /// Form1 的摘要说明。 /// </summary> public class Form1 : System.Windows.Forms.Form { private System.Windows.Forms.Button button1; private DataSet myDataSet; /// <summary> /// 必需的设计器变量。 /// </summary> private System.ComponentModel.Container components = null; public Form1() { // // Windows 窗体设计器支持所必需的 // InitializeComponent(); // // TODO: 在 InitializeComponent 调用后添加任何构造函数代码 // } /// <summary> /// 清理所有正在使用的资源。 /// </summary> protected override void Dispose( bool disposing ) { if( disposing ) { if (components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region Windows Form Designer generated code /// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { this.button1 = new System.Windows.Forms.Button(); this.SuspendLayout(); // // button1 // this.button1.Location = new System.Drawing.Point(120, 224); this.button1.Name = "button1"; this.button1.TabIndex = 0; this.button1.Text = "button1"; this.button1.Click += new System.EventHandler(this.button1_Click); // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(6, 14); this.ClientSize = new System.Drawing.Size(292, 273); this.Controls.AddRange(new System.Windows.Forms.Control[] { this.button1}); this.Name = "Form1"; this.Text = "Form1"; this.Load += new System.EventHandler(this.Form1_Load); this.ResumeLayout(false); } #endregion /// <summary> /// 应用程序的主入口点。 /// </summary> [STAThread] static void Main() { Application.Run(new Form1()); } private void button1_Click(object sender, System.EventArgs e) { try { string strCon="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Data Source=servername;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=servername;Use Encryption for Data=False;Tag with column collation when possible=False"; OleDbConnection myConn=new OleDbConnection(strCon); myConn.Open(); string strCom="SELECT * FROM Products"; myDataSet=new DataSet(); OleDbDataAdapter myCommand=new OleDbDataAdapter(strCom,myConn); myCommand.Fill(myDataSet,"Products"); myConn.Close(); } catch(Exception ey) { MessageBox.Show("连接错误!"+ey.ToString(),"错误"); } DataTable table=myDataSet.Tables[0]; Excel.Application excel=new Excel.Application(); excel.Application.Workbooks.Add(true); int colIndex=0; foreach(DataColumn col in table.Columns) { colIndex++; excel.Cells[1,colIndex]=col.ColumnName; } int rowIndex=1; foreach(DataRow row in table.Rows) { rowIndex++; colIndex=0; foreach(DataColumn col in table.Columns) { colIndex++; excel.Cells[rowIndex,colIndex]=row[col.ColumnName].ToString(); } } excel.Visible=true; } private void Form1_Load(object sender, System.EventArgs e) { } }}//应引用office.dll,excel.dll,vbide.dll (tlbimp.ext excel9.olb) gridview导出excel时设置excel为文本格式 c#数据显示 新手问题:关于随机数 c#读取EXCEL错误 问个新手问题 为什么我的注册信息写不进数据库啊 急!! Visual C#基于组件的开发 c#调用win32的COM 如何把远程端的数据库分离到本机? 如何能获得一个winform的graphics对象?(不重载OnPaint方法,也不使用Paint事件) 如何浏览我的html代码?(AxWebBrowser) 在Windows Forms 下怎么获得DataGrid的选定行的内容? 很简单的问题,但是很急,解决了就给分!!
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.OleDb;
namespace WindowsApplication5
{
/// <summary>
/// Form1 的摘要说明。
/// </summary>
public class Form1 : System.Windows.Forms.Form
{
private System.Windows.Forms.Button button1;
private DataSet myDataSet;
/// <summary>
/// 必需的设计器变量。
/// </summary>
private System.ComponentModel.Container components = null; public Form1()
{
//
// Windows 窗体设计器支持所必需的
//
InitializeComponent(); //
// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
//
} /// <summary>
/// 清理所有正在使用的资源。
/// </summary>
protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
} #region Windows Form Designer generated code
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.button1 = new System.Windows.Forms.Button();
this.SuspendLayout();
//
// button1
//
this.button1.Location = new System.Drawing.Point(120, 224);
this.button1.Name = "button1";
this.button1.TabIndex = 0;
this.button1.Text = "button1";
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(292, 273);
this.Controls.AddRange(new System.Windows.Forms.Control[] {
this.button1});
this.Name = "Form1";
this.Text = "Form1";
this.Load += new System.EventHandler(this.Form1_Load);
this.ResumeLayout(false); }
#endregion /// <summary>
/// 应用程序的主入口点。
/// </summary>
[STAThread]
static void Main()
{
Application.Run(new Form1());
} private void button1_Click(object sender, System.EventArgs e)
{
try
{ string strCon="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Data Source=servername;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=servername;Use Encryption for Data=False;Tag with column collation when possible=False";
OleDbConnection myConn=new OleDbConnection(strCon);
myConn.Open();
string strCom="SELECT * FROM Products";
myDataSet=new DataSet();
OleDbDataAdapter myCommand=new OleDbDataAdapter(strCom,myConn);
myCommand.Fill(myDataSet,"Products");
myConn.Close();
}
catch(Exception ey)
{
MessageBox.Show("连接错误!"+ey.ToString(),"错误");
}
DataTable table=myDataSet.Tables[0];
Excel.Application excel=new Excel.Application();
excel.Application.Workbooks.Add(true);
int colIndex=0;
foreach(DataColumn col in table.Columns)
{
colIndex++;
excel.Cells[1,colIndex]=col.ColumnName;
}
int rowIndex=1;
foreach(DataRow row in table.Rows)
{
rowIndex++;
colIndex=0;
foreach(DataColumn col in table.Columns)
{
colIndex++;
excel.Cells[rowIndex,colIndex]=row[col.ColumnName].ToString();
} } excel.Visible=true;
} private void Form1_Load(object sender, System.EventArgs e)
{
}
}
}//应引用office.dll,excel.dll,vbide.dll (tlbimp.ext excel9.olb)