I am trying to show data in Excel from multiple blocks of sql queries.
我试图从多个SQL查询块中显示Excel中的数据。
There is a stored procedure which give results in the form of multiple tables after execution.
存储过程在执行后以多个表的形式给出结果。
I have to show these tables as they are in a tab in Excel. All tables may have different columns names.
我必须在Excel中的选项卡中显示这些表。所有表可能具有不同的列名称。
Example
if the first table's data starts at cell A1 and ends at A4 then, after inserting a couple of blank rows, the second table's data must start from cell A7 or A8, and all should be in same excel tab.
如果第一个表的数据从单元格A1开始到A4结束，那么在插入几个空白行之后，第二个表的数据必须从单元格A7或A8开始，并且所有数据都应该在同一个excel选项卡中。
1 个解决方案
#1
0
You can use this : link
你可以使用这个：链接
If you want to use benefits of SSIS and Excel destionation connection manager you have to write a query that gives you this result set. Then you can save this data into one excel sheet.
如果要使用SSIS和Excel destionation连接管理器的优点，则必须编写一个查询，为您提供此结果集。然后，您可以将此数据保存到一个Excel工作表中。
#1
0
You can use this : link
你可以使用这个：链接
If you want to use benefits of SSIS and Excel destionation connection manager you have to write a query that gives you this result set. Then you can save this data into one excel sheet.
如果要使用SSIS和Excel destionation连接管理器的优点，则必须编写一个查询，为您提供此结果集。然后，您可以将此数据保存到一个Excel工作表中。