{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 冷血范 的问题《How to create excel sheet data directly from the .》','https://www.manongdao.com/q-851301.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
I want to create excel sheet from asp.net application using C# language.
please reply me how to create it and also if having source. I don't know how to create it.
Also I want drop down list in one of column. how we can do this.
Please reply me its urgent....
Regards, Girish
The two basic approaches to your question are to use ADO.NET or to use system.xml libraries. If you use XML you will be creating a XML based Office 2007 format file (as well as read/write), whereas with ADO.NET you will need an existing file, afaik.
I'd recommend using a library such as the one suggested above to work with it as an XML file, and distribute it as a XLSX/XLSM based file. Even if the user is on Office 2003, they can use the compatibility back to open such files (basic download from Microsoft).