想要使用LIST生成多个Excel工作表 [英] want to generate multiple excel sheets using LIST

问题描述

我想使用LIST在一个工作簿中生成多个Excel工作表



一张工作表和excel文件生成我使用了这个代码项目链接。



MVC Grid to Excel文件下载 [ ^ ]



我应该怎么做才能从多个工作表的LIST生成Excel？

解决方案

如果这是关于LIST的初学者问题，答案是学习使用列表，您可能想要做的是迭代列表并添加工作表。



如果这是关于如何添加工作表的问题，请参阅 http://stackoverflow.com/questions/193092/c-sharp-how-t o-add-excel-worksheet-programatically-office-xp-2003 [ ^ ]



和往常一样，我会我建议您使用Open XML 2 SDK而不是Excel自动化，因为即使没有安装Excel也可以使用它...



玩得开心。

i want to generate multiple excel sheet inside one workbook using LIST

for one sheet and excel file generation I have used this code project link.

MVC Grid to Excel file download[^]

what should I do to generate excel from LIST with multiple sheets?

解决方案

If this is a beginner question about LIST, the answer is learn to work with lists, what you probably want to do is to iterate over a list and add worksheets.

If this is a question about how to add a worksheet, see this http://stackoverflow.com/questions/193092/c-sharp-how-to-add-excel-worksheet-programatically-office-xp-2003[^]

and, as always, I would like to recommend you using the Open XML 2 SDK instead of Excel automation, because it will work even if Excel is not installed...

have fun.

这篇关于想要使用LIST生成多个Excel工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！