asp.net如何导出excel,asp导出到excel的简单方法
内容导航:
一、aspnet怎么导出Excel
/// /// 将DataSet中的数据导出Execl到指定目录 /// /// /// public void
CreateExcel(DataSet ds, string FileName) { HttpResponse resp; resp = ; coding
= ng(“GB2312”); der(“Content-Disposition”, “attachment;filename=” + FileName);
string colHeaders = “”, ls_item = “”; //定义表对象与行对象,同时用DataSet对其值进行初始化 DataTable
dt = [0]; DataRow[] myRow = ();//可以类似(“id>10”)之形式达到数据筛选目的 int i = 0; int cl =
; //取得数据表各列标题,各标题之间以t分割,最后一个列标题后加回车符 for (i = 0; i < cl; i++) { if (i == (cl –
1))//最后一列,加n { colHeaders += [i].() + “\n”; } else { colHeaders += [i].() +
“\t”; } } (colHeaders); //向HTTP输出流中写入取得的数据信息 //逐行处理数据 foreach (DataRow row in
myRow) { //当前行数据写入HTTP输出流,并且置空ls_item以便下行数据 for (i = 0; i < cl; i++) { if (i
== (cl – 1))//最后一列,加n { ls_item += row[i].ToString() + “\n”; } else { ls_item
+= row[i].ToString() + “\t”; } } (ls_item); ls_item = “”; } (); }
把repeater绑定数据重新查询出来,查询的返回就直接返回DataTable
二、中如何导出Excel表
就是将gridview中的数据导出到Excel中?求代码谢谢代码发到那? /// /// 导出DataGridView的数据到Excel表中 ///
/// public static void DataToExcel(DataGridView m_DataView) { SaveFileDialog
kk = new SaveFileDialog(); = “保存EXECL文件”; = “EXECL文件(.xls) |.xls|所有文件(.)
|.“; ex = 1; if (g() == ) { string FileName = ;// + “.slsx”; if ((FileName))
(FileName); FileStream objFileStream; StreamWriter objStreamWriter; string
strLine = “”; objFileStream = new FileStream(FileName, ate, ); objStreamWriter
= new StreamWriter(objFileStream, ); for (int i = 0; i < m_; i++) { if
(m_[i].Visible == true) { strLine = strLine + m_[i].() + (9); } } (strLine);
strLine = “”; for (int i = 0; i < m_; i++) { if (m_[0].Visible == true) { if
(m_[i].Cells[0].Value == null) strLine = strLine + ” ” + (9); else strLine =
strLine + m_[i].Cells[0].() + (9); } for (int j = 1; j < m_; j++) { if
(m_[j].Visible == true) { if (m_[i].Cells[j].Value == null) strLine = strLine
+ ” ” + (9); else { string rowstr = “”; rowstr = m_[i].Cells[j].(); if
((“\r\n”) > 0) rowstr = (“\r\n”, ” “); if ((“\t”) > 0) rowstr = (“\t”, ” “);
strLine = strLine + rowstr + (9); } } } (strLine); strLine = “”; } (); (); }
}调用Main_el(gwSum);使用 插件,可以不让服务器安装Office软件就能操作Excel(读写修改等)public void
createexcel(dataset ds,string typeid,string filename) { httpresponse resp;
resp = ; coding = ng(“gb2312”); der(“content-disposition”,
“attachment;filename=” + filename); string colheaders= “”, ls_item=””; int
i=0;//定义表对象与行对像,同时用dataset对其值进行初始化 datatable dt=[0]; datarow[] myrow=(“”); //
typeid==”1″时导出为excel格式文件;typeid==”2″时导出为xml格式文件 if(typeid==”1″) {
//取得数据表各列标题,各标题之间以\t分割,最后一个列标题后加回车符 for(i=0;i<-1;i++) “\t”;=”” )=””
+=”row[i].tostring()” +”\n”;=”” ;=”” colheaders=”” colheaders+='[i].()+”\t”;’
else=”” for(i=”0;i<-1;i++)” foreach(datarow=”” if(typeid=”2″ in=”” ls_item=””
myrow)=”” pre=”” ();=”” (colheaders);=”” (());=”” (ls_item);=”” row=”” {=””
}=”” }<=”” 从dataset中直接导出xml数据并且写到http输出流中=”” 写缓冲区中的数据到http头文件中=””
向http输出流中写入取得的数据信息=”” 在当前行中,逐列获得数据,数据之间以\t分割,结束时加回车符\n=””
当前行数据写入http输出流,并且置空ls_item以便下行数据=”” 逐行处理数据=””>抢首赞评论0加载更多
三、天正怎么导出excel
答:<p>CAD里有个输出表格的功能,选中表格,右键有个输出,默认是CSV格式可以用Excel打开</p>
四、在aspnet中怎么导出excel表
这个类可以很好的控制Excel。读出内容想怎么导就怎么导/// /// Excel处理类 /// public class ExcelHander {
public ExcelHander() { // // TODO: Add constructor logic here // } private
string AList=”ABCDEFGHIJKLMNOPQRSTUVWXYZ”; public string GetAix(int x,int y) {
char [] AChars=ay(); if(x>=26){return “”;} string s=””;
s=s+AChars[x-1].ToString(); s=s+(); return s; } public void setValue(int x,int
y,string align,string text) { range=Range((x,y),miss); _Value(miss,text);
if(()==”CENTER”) { lAlignment=enter; } if(()==”LEFT”) { lAlignment=eft; }
if(()==”RIGHT”) { lAlignment=ight; } } public void setValue(int x,int y,string
text) { range=_Range((x,y),miss); _Value(miss,text); } public void
setValue(int x,int y,string text, font, color) { (x,y,text);
range=_Range((x,y),miss); =; =; =color; =; =; =; } public void insertRow(int
y) { range=_Range(GetAix(1,y),GetAix(25,y)); (miss); (,miss);
_Range(GetAix(1,y),GetAix(25,y)); (); (miss,miss); } public void past() {
string s=”a,b,c,d,e,f,g”; (_Range((10,10),miss),s); } public void
setBorder(int x1,int y1,int x2,int y2,int Width) {
range=_Range((x1,y1),(x2,y2)); =Width; } public void mergeCell(int x1,int
y1,int x2,int y2) { range=_Range((x1,y1),(x2,y2)); (true); } public
getRange(int x1,int y1,int x2,int y2) { range=_Range((x1,y1),(x2,y2)); return
range; } private Missing miss=; //忽略的参数OLENULL public static Missing
MissValue=; private on m_objExcel;//Excel应用程序实例 private m_objBooks;//工作表集合
private m_objBook;//当前操作的工作表 private sheet;//当前操作的表格 public CurrentSheet { get
{ return sheet; } set { =value; } } public CurrentWorkBooks { get { return
this.m_objBooks; } set { this.m_objBooks=value; } } public CurrentWorkBook {
get { return this.m_objBook; } set { this.m_objBook=value; } } public void
OpenExcelFile(string filename) { m_objExcel = new on(); UserControl(false);
m( filename, miss, miss, miss, miss, miss, miss, miss, miss, miss, miss,
miss, miss, miss, miss); m_objBooks = ()m_; m_objBook = m_kbook; sheet =
()m_et; } public void UserControl(bool usercontrol) {
if(m_objExcel==null){return ;} m_ol=usercontrol; m_erts=usercontrol; m_ =
usercontrol; } public void CreateExceFile() { m_objExcel = new on();
UserControl(false); m_objBooks = ()m_; m_objBook = ()(m_(miss)); sheet =
()m_et; } public void SaveAs(string FileName) { m_(FileName, miss, miss, miss,
miss, miss, e, ssionChanges, miss,miss, miss, miss); //m_(false, miss, miss);
} public void ReleaseExcel() { m_(); mObject(m_objExcel); mObject(m_objBooks);
mObject(m_objBook); mObject(sheet); (); } }
版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,请发送邮件至 55@qq.com 举报,一经查实,本站将立刻删除。转转请注明出处:https://www.szhjjp.com/n/105217.html