????? Many colleagues and friends encountered Excel in the process of project development, need to generate a customer report through Excel, but every time there is a lot of problems on Excel. Below I will make a system description of the Excel's processing in the project, I hope to help you. ASP.NET
Chapter rough
1, generate Excel
1.1, export directly in HTML to Excel
??????? How to use the above method directly to generate Excel in the case of large data
1.2, generate multiple Sheet Excel on the server
2, read Excel
2.1, read Excel with ODBC data sources
2.2?, Let the web program access Excel on the server
2.2, read Excel with Microsoft.Excel components
3. Reflections on the speed of reading speed by Microsoft.Excel control
?
?
(Fail)