1、微软提供DsoFramer_KB311765_x86,可以直接嵌入office进入程序;
2、用导出程序进行处理——网络上代码太多,随便搜索就一把,不过需要自己处理就是了;
3、www.codeproject.com搜索excel,也是一堆堆的==================================================================
博客空间:http://blog.csdn.net/lovingkiss
资源下载:http://download.csdn.net/user/lovingkiss
优惠接单开发,组件控件定制开发,成品源代码批发
联系方式:Q64180940 全天在线
==================================================================
2、用导出程序进行处理——网络上代码太多,随便搜索就一把,不过需要自己处理就是了;
3、www.codeproject.com搜索excel,也是一堆堆的==================================================================
博客空间:http://blog.csdn.net/lovingkiss
资源下载:http://download.csdn.net/user/lovingkiss
优惠接单开发,组件控件定制开发,成品源代码批发
联系方式:Q64180940 全天在线
==================================================================
{
if (Program.ProjectID == "")
{
return;
} DataSet ds = this.BLL_Equipmentcode.ShowEquipmentcodeFromEquipmenttype(Program.ProjectID);
if (ds.Tables[0].Rows.Count > 0)
{
string FileName = filename;
long rowRead = 0;
float percent = 0;
Excel.Application xlApp = null;
xlApp = new Excel.Application();
Excel.Workbooks workbooks = xlApp.Workbooks;
Excel.Workbook workbook = workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
System.Data.DataTable dt= this.GetAllExportMessage(ds.Tables[0].Rows[j]["indexid"].ToString());
long totalCount = dt.Rows.Count;
Excel.Worksheet worksheet = (Excel.Worksheet)workbook.Worksheets[j+1];//取得sheet1
worksheet.Activate();
worksheet.Name = ds.Tables[0].Rows[j]["indexname"].ToString();
Excel.Range range; //写入字段
for (int i = 0; i < dt.Columns.Count; i++)
{
worksheet.Cells[1, i + 1] = dt.Columns[i].ColumnName;
range = (Excel.Range)worksheet.Cells[1, i + 1];
}
for (int r = 0; r < dt.Rows.Count; r++)
{
worksheet.Cells[r + 2, 1] = ds.Tables[0].Rows[r]["indexid"].ToString();
for (int i = 0; i < dt.Columns.Count; i++)
{
// worksheet.Cells[r+2,i+1]=dt.Rows[r][i];
if (i + 1 != dt.Columns.Count)
worksheet.Cells[r + 2, i + 2] = dt.Rows[r][i + 1];
}
rowRead++;
percent = ((float)(100 * rowRead)) / totalCount;
//this.FM.CaptionText.Text = "正在导出数据,已导出[" + percent.ToString("0.00") + "%]...";
System.Windows.Forms.Application.DoEvents();
}
range = worksheet.get_Range(worksheet.Cells[2, 1], worksheet.Cells[dt.Rows.Count + 2, dt.Columns.Count]);
workbook.Saved = true;
workbook.SaveCopyAs(FileName);
}
}
}
代码就是这样 当我定义第2个sheel时报错!!!