从视图中填充的Excel工作簿 [英] populate excel workbook from a view
问题描述
什么是从视图中填充的Excel工作簿的最佳方式?
What is the best way to populate an excel workbook from a view?
我想在一个视图设计一个文本框StudentId和查看成绩。
I want to design a textbox "StudentId" and a button "Show Grades" in a view.
一旦学生进入StudentId和点击显示等级我想拉从StudentTable,等级该特定StudentId并将其显示在Excel工作簿。
Once a student enters "StudentId" and clicks "Show Grades" I want to pull "Grades" from "StudentTable" for that particular "StudentId" and display it in an Excel workbook.
我怎么能这样做呢?
在此先感谢
推荐答案
如果导出到Excel 2007+(.xlsx)格式是确定你的情况,你可以看看在EPPlus库。它的工作对我非常好。你并不需要安装的办公室。
If exporting to Excel 2007+ (.xlsx) is ok for your situation, you could take a look at the EPPlus library. It's worked very well for me. You don't need to have office installed.
HTTP://epplus.$c$cplex.com/wikipage标题= WebapplicationExample
这篇关于从视图中填充的Excel工作簿的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!