使用微软的OWC组件,然后就可以对EXCEl进行操作了,具体的可以在网上查一下
解决方案 »
- sql2000h和sql2005中设计表是如何设计用户的角色和权限
- 模糊查询问题。。
- 如何遍历gridview的每行和每列?
- 在ASP.NET中弹出对话框
- 【求教】后台调用JS方法出现问题
- 有没有谁用.net C#,sql server2000做过交友的web2.0网站,有没有源码,请分享一下,TKS
- 求救---关于定时执行一方法的问题
- |M| 在CSDN的ASP.NET 里面我看也有很多人都有出书,然后我想问一下为什么你们出书都不出一个详细实用结构完整的书呢:比如写一个程序的话可
- 请问各位高手,开发asp.net软件是否大多数都用vs.net平台开发,但是介绍这方面的书籍很少啊!!!!
- VS .net装起来,是不是只有一个?????
- ~~~~~~一个关于DropDownList的问题~~~~~!!!!!!!
- 困惑!寻找传说中的ID[详细请看]
Introduction
I have created an Excel Export component using XSL and XML which can produce very well formatted Excel files. This doesn't require any Excel library to create Excel files without charts and macros, but if you want charts or macros in the Excel, then you have to have Excel installed on the machine. I will explain this using three examples.Export a DataTable into an Excel sheet which will not have any formatting.
Export an XMLDataDocument (has data from a DataTable and has a few tags added to it) into an Excel sheet which will have a lot of cool formatting.
Export an XMLDataDocument (has data from a DataTable and has a few tags added to it) into an Excel sheet which will have charts and a lot of cool formatting.3.excel文件读取——http://www.codeproject.com/office/Excelreader.asp
What it can do?
It can read read worksheets in a workbook and read cells in a worksheet.
It can read cell content (text, number, datetime, or error) and cell format (font, alignment, linestyle, background, etc.).
It can read pictures in the file, get information of image size, position, data, and format.
Using the code