ASP.Net Web服务器控件生成HTML和Excel [英] ASP.Net web server control that generates HTML and Excel

问题描述

我正在开发一个包含大量报告的Web应用程序。这些报告是相当基本的，但有些则有多个数据集或嵌入图表。每个报告的主要要求之一是可以导出到Excel。报告的Excel版本已断开连接，并且与Web报告的外观（或非常相似）应该相同。这包括值的格式化，单元格样式，行/列数，图表等。

我遇到的问题是ASP.Net报表工具我'我们在创建报告方面做得很好，但Excel的出口并不像我想要的那样强大。 ASP.Net电子表格工具可以很好地生成Excel表单，但是它们不提供在浏览器中查看信息的方法，而无需在本地下载并在Excel中查看。

任何建议？谢谢！

解决方案

Infragistics 有一些相当强大的Web控件，其中一个是可以导出到Excel的网格。 Excel导出组件允许您格式化结果，添加图像和其他内容，因此应该执行以下操作。

Infragistics的唯一问题是它们的API是非常...什么是单词...繁琐？所以需要一些工作来习惯和经常使用很多代码来完成工作。但最终结果是好的。

I am developing a web application that contains a great deal of reporting. The reports are fairly basic, but some have multiple datasets or embedded charts. One of the key requirements is that each report can be exported to Excel. The Excel version of the report is disconnected and should look the same (or very similar) to the web report. That includes formmating of values, cell styles, number of rows/columns, charts, etc.

The problem I've encountered is that the ASP.Net reporting tools I've looked at do a great job in creating the report, but the export to Excel is not as robust as I'd like. The ASP.Net spreadsheet tools do a great job generating an Excel sheet, but they don't offer a way to view the information in a browser without downloading them locally and viewing them in Excel.

Any suggestions? Thanks!

解决方案

Infragistics has some fairly robust web controls, one of them is a grid that can export to Excel. The Excel export component allows you to format the results, add images and other stuff, so it should do what you are after.

The only problem with Infragistics is that their API is extremely ... what is the word ... cumbersome? So it takes some work to get used to and often much code to get things done properly. But the end result is good.

这篇关于ASP.Net Web服务器控件生成HTML和Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！