62,074
社区成员
发帖
与我相关
我的任务
分享
using System;
using System.Collections.Generic;
using System.Text;
using Aspose.Cells;
using System.Data;
namespace ConsoleApplication11
{
class Program
{
static void Main(string[] args)
{
DataTable dt = new DataTable();
for (int i = 0; i < 2; i++)
{
dt.Columns.Add(i.ToString());
}
DataRow row;
for (int i = 0; i < 10; i++)
{
row = dt.NewRow();
row[0] = i;
row[1] = i + 1;
dt.Rows.Add(row);
}
Workbook workbook = new Workbook();
//新建sheet
//Worksheet sheet = workbook.Worksheets.Add();
//直接使用默认sheet
Worksheet sheet = workbook.Worksheets[0];
sheet.Cells.ImportDataTable(dt, true, "A1");
workbook.Save(@"D:\\TEST.XLS");
}
}
}
aspose.cells dll及使用文档
http://download.csdn.net/source/2192653
private void Toexcel()
{
//获取数据集
SqlConnection conn=new SqlConnection("连接数据库");
string strsql="select * from student";
SqlDataAdapter da=new SqlDataAdapter(strsql,conn);
DataSet ds=new DataSet();
da.Fill(ds,"test");
DataTable dt=ds.Tables["test"];
StringWriter sw=new StringWriter(); //创建对象
sw.WriteLine("学生信息"); //输入标题
sw.WriteLine("姓名\t年龄\t性别);//输入字段
//输入表格内容
foreach(DataRow dr in dt.Rows)
{
string str=dr["test"].ToString().Replace("\r"," ");
sw.WriteLine(dr["姓名"]+"\t"+dr["年龄"]+"\t"+dr["性别"]);
}
sw.Close(); //关闭数据流
Response.AddHeader("Content-Disposition", "attachment; filename=test.xls"); //test.xls导入Excel得文件名
Response.ContentType = "application/ms-excel";
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");
Response.Write(sw);
Response.End();
}