从类库中的多个数据集中导出到Excel [英] Export to Excel from Multiple datasets in Class Library

问题描述

大家好，

我有一个类库文件，其中有多个要导出到Excel文件的数据集中的数据，它可以在单个工作表或多个WorkSheets中.

以前有人做过这个吗?

谢谢，
Prasant

Hi All,

I have a class library file in which i have the Data in the multiple datasets which i want to export to Excel file.It could be in a single Worksheet or multiple WorkSheets.

Do anyone worked on this before???

Thanks,
Prasant

推荐答案

您可以为此使用Open XML SDK 2.0.

在欢迎使用适用于Microsoft Office的Open XML SDK 2.0的内容，了解有关Open XML SDK 2.0的更多信息. [^ ]

下一篇文章介绍了如何使用此sdk将数据表导出到excel
OpenXML SDK 2.0:将数据表导出到Excel
[ ^ ]您可以将此逻辑包装到多个数据集.

You can use Open XML SDK 2.0 for this purpose.

Read more about Open XML SDK 2.0 at Welcome to the Open XML SDK 2.0 for Microsoft Office
[^]

Following article explains how to export data table to excel using this sdk
OpenXML SDK 2.0: Export a DataTable to Excel
[^] You can wrap this logic for multiple datasets.

这篇关于从类库中的多个数据集中导出到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！