Spreadsheet spread;
Worksheet ws;
spread = new SpreadsheetClass();
if (spread == null)
{
base.AppendMessage("无法创建owc对象,可能您的机子未安装owc");
return;
}
ws = spread.ActiveSheet;
int iStart = 1; ws.Cells[iStart, 1] = "Date";
ws.Cells[iStart, 2] = "EmployeeCode";
ws.Cells[iStart, 3] = "EmployeeName";
ws.Cells[iStart, 4] = "Orgcode1";
ws.Cells[iStart, 5] = "Category";
ws.Cells[iStart, 6] = "Status";
ws.Cells[iStart, 7] = "Message";
for (int i = 0; i < dt.Rows.Count;i++ )
{
iStart = iStart + 1;
ws.Cells[iStart, 1] = DateTime.Parse(dt.Rows[i][1].ToString().Trim()).ToString("yyyy/MM/dd");
ws.Cells[iStart, 2] = "'"+dt.Rows[i][2].ToString().Trim();
ws.Cells[iStart, 3] = dt.Rows[i][3].ToString().Trim();
ws.Cells[iStart, 4] = dt.Rows[i][4].ToString().Trim();
ws.Cells[iStart, 5] = dt.Rows[i][5].ToString().Trim();
ws.Cells[iStart, 6] = dt.Rows[i][6].ToString().Trim();
ws.Cells[iStart, 7] = dt.Rows[i][7].ToString().Trim();
}
string strReport = strFilePath + "Metso_log.xls";
try
{
spread.Export(strReport, SheetExportActionEnum.ssExportActionNone, SheetExportFormat.ssExportHTML);
}
catch (Exception ex)
{
base.AppendMessage(ex.Message + " Please close file " + strReport + " first!");
return;
}
System.IO.FileInfo file = new System.IO.FileInfo(path);
Response.Clear();
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AddHeader("Content-Disposition", "attachment; filename = " + Server.UrlEncode(file.Name));
Response.AddHeader("Content-Length", file.Length.ToString());
Response.ContentType = "application/ms-excel";
Response.WriteFile(file.FullName);
Response.Flush();
Response.End();
请问 导出到excel 用上面那些对象怎么设置excel中一个单元格的宽度?
Worksheet ws;
spread = new SpreadsheetClass();
if (spread == null)
{
base.AppendMessage("无法创建owc对象,可能您的机子未安装owc");
return;
}
ws = spread.ActiveSheet;
int iStart = 1; ws.Cells[iStart, 1] = "Date";
ws.Cells[iStart, 2] = "EmployeeCode";
ws.Cells[iStart, 3] = "EmployeeName";
ws.Cells[iStart, 4] = "Orgcode1";
ws.Cells[iStart, 5] = "Category";
ws.Cells[iStart, 6] = "Status";
ws.Cells[iStart, 7] = "Message";
for (int i = 0; i < dt.Rows.Count;i++ )
{
iStart = iStart + 1;
ws.Cells[iStart, 1] = DateTime.Parse(dt.Rows[i][1].ToString().Trim()).ToString("yyyy/MM/dd");
ws.Cells[iStart, 2] = "'"+dt.Rows[i][2].ToString().Trim();
ws.Cells[iStart, 3] = dt.Rows[i][3].ToString().Trim();
ws.Cells[iStart, 4] = dt.Rows[i][4].ToString().Trim();
ws.Cells[iStart, 5] = dt.Rows[i][5].ToString().Trim();
ws.Cells[iStart, 6] = dt.Rows[i][6].ToString().Trim();
ws.Cells[iStart, 7] = dt.Rows[i][7].ToString().Trim();
}
string strReport = strFilePath + "Metso_log.xls";
try
{
spread.Export(strReport, SheetExportActionEnum.ssExportActionNone, SheetExportFormat.ssExportHTML);
}
catch (Exception ex)
{
base.AppendMessage(ex.Message + " Please close file " + strReport + " first!");
return;
}
System.IO.FileInfo file = new System.IO.FileInfo(path);
Response.Clear();
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AddHeader("Content-Disposition", "attachment; filename = " + Server.UrlEncode(file.Name));
Response.AddHeader("Content-Length", file.Length.ToString());
Response.ContentType = "application/ms-excel";
Response.WriteFile(file.FullName);
Response.Flush();
Response.End();
请问 导出到excel 用上面那些对象怎么设置excel中一个单元格的宽度?
解决方案 »
- 如何获得GridView动态创建TemplateField中的ItemTemplate中的a标签的值
- 伪静态分页问题
- fckeditor上传问题
- 关于TreeView控件的问题
- 建立sqldatasource时,为什么高级sql生成选项那里不能选择呢。
- [怪题讨论] 来一个人讨论加10分,直到分尽人亡,直到六月六日
- 如何在Web用户控件中获得用弹出对话框的返回值问题
- 我如何送给dropdownlist一个value值,如何让dropdownlist选中value等于我给的值那个项目呢
- 小弟想问一下关于在线聊天室的设计思路的问题?
- 关于 数据绑定 问题
- 关于js及兼容性。。。。
- 【100分悬赏】输入本机IP地址访问asp.net网站
使用二维数组赋值到excel