private void ExportFromDataGrid(string targetName, System.Web.UI.WebControls.GridView sourceGrid)
{
if (sourceGrid.Rows.Count <= 0)
{
return;
} int colcount = sourceGrid.Rows[0].Cells.Count;
int colhcount = sourceGrid.Columns.Count;
//int colhcount = sourceGrid.Rows[0].Cells.Count; int rowcount = sourceGrid.Rows.Count;
Response.AddHeader("Content-Disposition", "attachment;filename=" + targetName);
Response.ContentEncoding = System.Text.Encoding.GetEncoding("BIG5");
Response.ContentType = "application/excel";
//Response.ContentType = "application/vnd.ms-excel";
Response.Write("半成品入庫\n");
string temp = "";
//for (int i = 0; i < colhcount; i++)
//{
// //temp += sourceGrid.Columns[i].HeaderText.ToString() + "\t";
//}
temp = "五通碼\t車種代碼\t月份代碼\t廠商代碼\t架高代碼\t顏色代碼\t庫存狀況\t備注";
temp += "\n";
Response.Write(temp);
for (int r=0; r < rowcount; r++)
{
string strval = "";
int c = 2;
if (SFID) { c += 1; }
//if (SFIE) { r += 1; } for (c = c; c < colcount; c++)
{
strval += sourceGrid.Rows[r].Cells[c].Text.ToString().Replace(" ","") + "\t";
}
strval += "\n";
Response.Write(strval);
}
Response.Flush();
Response.Close();
Response.End();
}
我是用上面這種方法導出覺得是比較完美的,因為不會連背景和格式都導出,隻導出數字,或字符。
但現在又遇到一個問題,標題單元格怎麼合並呢?比如有五列的話。
{
if (sourceGrid.Rows.Count <= 0)
{
return;
} int colcount = sourceGrid.Rows[0].Cells.Count;
int colhcount = sourceGrid.Columns.Count;
//int colhcount = sourceGrid.Rows[0].Cells.Count; int rowcount = sourceGrid.Rows.Count;
Response.AddHeader("Content-Disposition", "attachment;filename=" + targetName);
Response.ContentEncoding = System.Text.Encoding.GetEncoding("BIG5");
Response.ContentType = "application/excel";
//Response.ContentType = "application/vnd.ms-excel";
Response.Write("半成品入庫\n");
string temp = "";
//for (int i = 0; i < colhcount; i++)
//{
// //temp += sourceGrid.Columns[i].HeaderText.ToString() + "\t";
//}
temp = "五通碼\t車種代碼\t月份代碼\t廠商代碼\t架高代碼\t顏色代碼\t庫存狀況\t備注";
temp += "\n";
Response.Write(temp);
for (int r=0; r < rowcount; r++)
{
string strval = "";
int c = 2;
if (SFID) { c += 1; }
//if (SFIE) { r += 1; } for (c = c; c < colcount; c++)
{
strval += sourceGrid.Rows[r].Cells[c].Text.ToString().Replace(" ","") + "\t";
}
strval += "\n";
Response.Write(strval);
}
Response.Flush();
Response.Close();
Response.End();
}
我是用上面這種方法導出覺得是比較完美的,因為不會連背景和格式都導出,隻導出數字,或字符。
但現在又遇到一個問題,標題單元格怎麼合並呢?比如有五列的話。
解决方案 »
- 网站上的TQ在线客服是如何实现的?
- div
- asp.net网站如何生成静态页面
- asp.net数据库连接问题
- 请教DataGrid初始时显示指定行数的问题
- 使用DataRelationCollection.Add 方法的时候,数据库字段必须是INT类型的吗?
- 如何获取某一存储过程所有的参数列表呢?
- 如果DATAGRID绑定后台数据库后, 它的列的宽度是不是肯定不能设定的?我要指定宽度.请问怎样解决这个问题,
- 如何播放wav文件和停止播放wav文件呢?
- 要转ASP。NET。可我以前没学过C语言,没基础,怎么学习C#啊。。。
- ***HyperLink的奇怪问题.着急
- JS获取 FreeTextBox的值
A1和A2合并:sheet.get_Range("A1","A2").Merge(0);其他同理