将两个数据表导出为两个相同的excel文件 [英] Export two datatable into two sheets of same excel file

问题描述

我必须将两个数据表值导出到两个相同excel文件的单独表格中。

如何创建多个单张并导出到它们？



谢谢。

Hi,

I have to export two datatable values into two seperate sheets of same excel file.
How can i create multiple sheets and export to the same?

Thank you.

推荐答案

尝试创建一个工作表对象工作簿。

Try creating multiple Worksheet objects of a Work book.

Dim xlsapp As New Microsoft.Office.Interop.Excel.Application()
Dim workbook As Microsoft.Office.Interop.Excel.Workbook = xlsapp.Workbooks.Open(dlgSaveFile.FileName, 0, False, 5, "", "", _
True, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, vbTab, False, False, 0, _
True, 1, 0)
Dim sheet1 As Microsoft.Office.Interop.Excel.Worksheet = workbook.Worksheets(1)
Dim sheet2 As Microsoft.Office.Interop.Excel.Worksheet = workbook.Worksheets(1)

现在如何创建一个工作表？用于办公室的微软工具允许您使用代码中的Excel工作表，还可以购买商业库。他们将支持创建多个工作表，如果您通过导出到csv创建Excel文件，则无法执行此操作。



如果您将代码发布到向我们展示你现在如何创建它们，我不得不猜测。

How are you creating one sheet, now ? The microsoft tools for office let you work with excel sheets in code, there's also commercial libraries you can buy. They will support creating multiple sheets, which you can't do if you're creating excel files by exporting to csv.

It would help us if you posted code to show us how you create them now, I've had to guess.

Microsoft.Office.Interop.Excel.Application xlsapp = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook workbook = xlsapp.Workbooks.Open(dlgSaveFile.FileName, 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, Constants.vbTab, false,
false, 0, true, 1, 0);
Microsoft.Office.Interop.Excel.Worksheet sheet1 = workbook.Worksheets(1);
Microsoft.Office.Interop.Excel.Worksheet sheet2 = workbook.Worksheets(1);

要命名您的Excel工作表，请使用工作表对象的name属性。

例如：

To name your excel sheet,use the name property of your Work sheet object.
eg:

sheet1.Name="Example1";
sheet2.Name="Example2";

快乐编码..

Happy coding..

这篇关于将两个数据表导出为两个相同的excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！