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

问题描述

我正在开发包含报告大量的Web应用程序。这些报告是相当基本的，但一些有多个数据集或嵌入图表。其中一个关键要求是，每个报告可以导出到Excel。该报告的Excel版本断开，应该相同（或非常相似）的Web报表。这包括价值观formmating，单元格样式，行/列，图号等。

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.

我遇到的问题是，ASP.Net报告我看了做创建报告非常出色的工具，但出口到Excel是不是一样强大，我想。在ASP.Net US preadsheet工具做大量的工作产生一个Excel表，但他们没有提供一个方法来查看在浏览器中的信息，而不下载到本地并在Excel中查看。

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.

有什么建议？谢谢！

推荐答案

Infragistics的有一些相当强大的Web控件，其中之一是，可以导出到Excel一个网格。在Excel导出组件允许您格式化结果，添加图像和其他的东西，所以它应该做你所追求的。

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.

与Infragistics的唯一的问题是，他们的API是非常...什么字......繁琐？因此，需要一些工作习惯，往往很多code把事情做好。但最终的结果还是不错的。

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.

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