如何将数据从两个表导入单个excel表？ [英] How to import data from two table to single excel sheet?

问题描述

如何将两个表中的数据从SQL Server导入到一个excel表中？

推荐答案

首先，您应该了解这根本不是问题：因为您不需要在Excel工作表中支持表并且只需要导出，您可以在单个工作表上放置任意数量的表：表具有有限的大小，因此您可以将两个表放在工作表的不同位置。如果您在第一个表的右侧移动第二个表，您甚至可以在以后增长它们，因为表格具有固定的行数。



用于创建您可以使用Microsoft Word互操作（它需要安装Excel）或Open XML SDK：

http://en.wikipedia.org/wiki/Open_XML [ ^ ]。



由于您没有分享有关您的编程语言，平台和其他细节的信息，所以这就是全部。

-SA

First of all, you should understand that this is not a problem at all: as you don't need to support the tables in an Excel sheet and only need the export, you can place any number of tables on the single sheet: each table have a finite size, so you can put, say, two table in different location of the sheet. If you, say, shift second table on the right of the first one, you can even grow them later, as the tables have fixed number of rows.

For creation of the Excel files, you can either use Microsoft Word interop (it requires Excel to be installed) or Open XML SDK:
http://en.wikipedia.org/wiki/Open_XML[^].

As you did not share information on your programming language, platform and other detail, that's all.

—SA

这篇关于如何将数据从两个表导入单个excel表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！