asp.net(c#)將數(shù)據(jù)導(dǎo)出到word或excel
來(lái)源:易賢網(wǎng) 閱讀:685 次 日期:2014-10-24 14:56:57
溫馨提示:易賢網(wǎng)小編為您整理了“asp.net(c#)將數(shù)據(jù)導(dǎo)出到word或excel”,方便廣大網(wǎng)友查閱!

最簡(jiǎn)單的方法是把頁(yè)面上所有的東西都導(dǎo)出

在載入時(shí)調(diào)用,注意頁(yè)面里不能有其它控件,包括按鈕

void converttoexcel()

{

response.clear();

response.buffer = true;

response.charset = gb2312;

response.appendheader(content-disposition, attachment;filename= + datetime.now.tostring(yyyymmddhhmmss) + .xls);

response.contentencoding = system.text.encoding.getencoding(gb2312);

response.contenttype = application/ms-excel;

this.page.enableviewstate = false;

system.io.stringwriter ostringwriter = new system.io.stringwriter();

system.web.ui.htmltextwriter ohtmltextwriter = new system.web.ui.htmltextwriter(ostringwriter);

this.page.rendercontrol(ohtmltextwriter);

response.write(ostringwriter.tostring());

response.end();

}

asp.net(c#)將數(shù)據(jù)導(dǎo)出到word或excel

命名空間:

using system.io;

using system.text;

將datagrid的數(shù)據(jù)導(dǎo)出到excel

string excelname=excel文件名;

httpcontext.current.response.charset = gb2312;

httpcontext.current.response.contentencoding = encoding.utf8;

httpcontext.current.response.contenttype = application/ms-excel;

httpcontext.current.response.appendheader(content-disposition, attachment;filename= + excelname + .xls);

dr1.page.enableviewstate = false;

stringwriter sw = new stringwriter();

htmltextwriter tw = new htmltextwriter(sw);

dr1.rendercontrol(tw);

httpcontext.current.response.write(sw.tostring());

httpcontext.current.response.end();

將datagrid的數(shù)據(jù)導(dǎo)出到word

string excelname=word文件名;

httpcontext.current.response.charset = gb2312;

httpcontext.current.response.contentencoding = encoding.utf8;

httpcontext.current.response.contenttype = application/ms-winword;

httpcontext.current.response.appendheader(content-disposition, attachment;filename= + excelname + .doc);

dr1.page.enableviewstate = false;

stringwriter sw = new stringwriter();

htmltextwriter tw = new htmltextwriter(sw);

dr1.rendercontrol(tw);

httpcontext.current.response.write(sw.tostring());

httpcontext.current.response.end();

asp.net 2.0,c#----利用gridview控件導(dǎo)出其他文件(導(dǎo)出excel,導(dǎo)出word文件)

// 注意,在visual studio2005平臺(tái)下,如果使用gridview導(dǎo)出文件,

//就必須重載verifyrenderinginserverform方法

public override void verifyrenderinginserverform(control control)

{

}

///

/// 導(dǎo)出到文件的方法,

///

/// model=1:導(dǎo)出為execl,model=2:導(dǎo)出為word

private void tofiles(int model)

{

string strfilename = datetime.now.tostring(yyyymmdd-hhmmss);

system.web.httpcontext hc = system.web.httpcontext.current;

hc.response.clear();

hc.response.buffer = true;

hc.response.contentencoding = system.text.encoding.utf8;//設(shè)置輸出流為簡(jiǎn)體中文

if (model == 1)

{

//---導(dǎo)出為excel文件

hc.response.addheader(content-disposition, attachment;filename= +httputility.urlencode(strfilename, system.text.encoding.utf8) + .xls);

hc.response.contenttype = application/ms-excel;//設(shè)置輸出文件類(lèi)型為excel文件。

}

else

{

//--- 導(dǎo)出為word文件

hc.response.addheader(content-disposition, attachment;filename= +httputility.urlencode(strfilename, system.text.encoding.utf8) + .doc);

hc.response.contenttype = application/ms-word;//設(shè)置輸出文件類(lèi)型為word文件。

}

system.io.stringwriter sw = new system.io.stringwriter();

system.web.ui.htmltextwriter htw = new system.web.ui.htmltextwriter(sw);

this.gridview1.rendercontrol(htw);

hc.response.write(sw.tostring());

hc.response.end();

}

//-導(dǎo)出為excel文件

protected void toexecl_click(object sender, eventargs e)

{

tofiles(1);

}

//-導(dǎo)出為word文件

protected void button1_click(object sender, eventargs e)

{

tofiles(2);

}

from:http://hi.baidu.com/jg_%b3%c2/blog/item/4f0edf188851c50135fa41ce.html

c#操作word[轉(zhuǎn)]

導(dǎo)入com庫(kù):microsoft word 11.0 object library.

更多信息請(qǐng)查看IT技術(shù)專(zhuān)欄

更多信息請(qǐng)查看網(wǎng)絡(luò)編程
易賢網(wǎng)手機(jī)網(wǎng)站地址:asp.net(c#)將數(shù)據(jù)導(dǎo)出到word或excel
由于各方面情況的不斷調(diào)整與變化,易賢網(wǎng)提供的所有考試信息和咨詢回復(fù)僅供參考,敬請(qǐng)考生以權(quán)威部門(mén)公布的正式信息和咨詢?yōu)闇?zhǔn)!

2025國(guó)考·省考課程試聽(tīng)報(bào)名

  • 報(bào)班類(lèi)型
  • 姓名
  • 手機(jī)號(hào)
  • 驗(yàn)證碼
關(guān)于我們 | 聯(lián)系我們 | 人才招聘 | 網(wǎng)站聲明 | 網(wǎng)站幫助 | 非正式的簡(jiǎn)要咨詢 | 簡(jiǎn)要咨詢須知 | 新媒體/短視頻平臺(tái) | 手機(jī)站點(diǎn) | 投訴建議
工業(yè)和信息化部備案號(hào):滇ICP備2023014141號(hào)-1 云南省教育廳備案號(hào):云教ICP備0901021 滇公網(wǎng)安備53010202001879號(hào) 人力資源服務(wù)許可證:(云)人服證字(2023)第0102001523號(hào)
云南網(wǎng)警備案專(zhuān)用圖標(biāo)
聯(lián)系電話:0871-65099533/13759567129 獲取招聘考試信息及咨詢關(guān)注公眾號(hào):hfpxwx
咨詢QQ:1093837350(9:00—18:00)版權(quán)所有:易賢網(wǎng)
云南網(wǎng)警報(bào)警專(zhuān)用圖標(biāo)