从数据库进行 Excel 自动化，最好的技术是什么？
我想要从数据库生成 Excel 报告。
What do you think is the best Technology to use for Excel automation ?
Consider :
> Full Excel API Support is a must.
> Cross Platform solution preferable.
> Programmer's efficiency is high priority.
> Mono development is welcome, if that provides an edge.
> Open Source solutions are welcomed.
> VB.Net, C#.Net or something else ?
> What build environment to use, MSBuild or NAnt or something else ?
请为我的项目提供您的经验和建议！
这将是一个庞大的报告项目，需要利用大量 Excel API。
I want to have Excel reports generated from the database.
What do you think is the best Technology to use for Excel automation ?
Consider :
> Full Excel API Support is a must.
> Cross Platform solution preferable.
> Programmer's efficiency is high priority.
> Mono development is welcome, if that provides an edge.
> Open Source solutions are welcomed.
> VB.Net, C#.Net or something else ?
> What build environment to use, MSBuild or NAnt or something else ?
Please throw your experiences and advises for my project !!
Its going to be massive reporting project, with a lots of Excel API's to be exploited.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您的问题有很多技术要求，但没有任何业务要求，如果用户想要来自数据库的一些报告，他们可以在 Excel 中查看/操作，那么可能有比使用 excel API 更好的方法来做到这一点。
如果您想生成报告，我建议使用专为该工作构建的东西，而不是实施您自己的解决方案。如果您的 SQL 环境是 MS SQL Server，那么 SSRS 就可以完成这项工作，事实上，如果您想要包括 mySQL 和 Oracle，您可以将 SSRS 与其他数据库一起使用。如果没有，那么这个答案有一些开源解决方案。
Your question has lots of technical requirements but not any business requirements, If the users want some reports from a DB that they can view / manipulate in excel then there are probably better ways to do it than using the excel API.
If you want to generate reports I'd suggest using something built for the job rather than implementing your own solution. If your SQL environment is MS SQL Server then SSRS would do the job, in fact you can use SSRS with other Databases if you want including mySQL and Oracle. If not then this answer has some open source solutions.