创建具有多个工作表的单个Excel [英] Create Single Excel with multiple sheet

问题描述

我有一个数据集，并且在我的数据集中有三个表table0,1,2.
我想打开对话框以写入包含三张纸的单个excel文件
在sheet1中将休假表0的记录，在sheet 2中将休假1的记录..
所以有什么主意..............
注-我想在没有Microsoft Office Interop dll的情况下创建

I have a datset and in my dataset there are three tables table0,1,2.
I want to open dialog box to write a single excel file with three sheets
in sheet1 will fallow records of table 0 and sheet 2 will 1 like that..
so have any idea..............
Note - I want to create without microsoft office Interop dll

推荐答案

我认为这将对您有所帮助

http://stackoverflow.com/questions/373925/c-sharp- winforms-app-export-dataset-to-excel [ ^ ]

i think this will help you

http://stackoverflow.com/questions/373925/c-sharp-winforms-app-export-dataset-to-excel[^]

无需互操作即可使用纯C#读取Excel文件 [ ^ ]应该给您解决方案.
此 [ ^ ]使用第三方，可能也会为您提供帮助.

Read Excel files in pure C# without interop[^] should give you a solution.
This[^] uses a third party and might help you as well.

这篇关于创建具有多个工作表的单个Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！