同时操作多个表格，对不同表，同列，但是数量不同的数据求和

池鱼思故渊#

同时操作多个表格，对不同表，同列，但是数量不同的数据求和。比如我现在有50个表格，同时对A列的数据，进行一个求和或者计数。表一A列10行数据，表二A列25个数据，一直到表50，50个工作表，对不同行数据，但是同列的数据，求和，有什么快捷方法不，不要一个一个表的打开，计算。

pxy0409

sql连接,或者pq连接

fshhhf

select * from [sheet1$] union all select * from [sheet2$] union all select * from [sheet3$] union all select * from [sheet4$] union all select * from [sheet5$] union all select * from [sheet6$] union all select * from [sheet7$] union all select * from [sheet8$] union all select * from [sheet9$] union all select * from [sheet10$] union all select * from [sheet11$] union all select * from [sheet12$] union all select * from [sheet13$] union all select * from [sheet14$] union all select * from [sheet15$] union all select * from [sheet16$] union all select * from [sheet17$] union all select * from [sheet18$] union all select * from [sheet19$] union all select * from [sheet20$] union all select * from [sheet21$] union all select * from [sheet22$] union all select * from [sheet23$] union all select * from [sheet24$] union all select * from [sheet25$] union all select * from [sheet26$]

fshhhf

select * from [sheet1$] union all select * from [sheet2$] union all select * from [sheet3$] union all select * from [sheet4$] union all select * from [sheet5$] union all select * from [sheet6$] union all select * from [sheet7$] union all select * from [sheet8$] union all select * from [sheet9$] union all select * from [sheet10$] union all select * from [sheet11$] union all select * from [sheet12$] union all select * from [sheet13$] union all select * from [sheet14$] union all select * from [sheet15$] union all select * from [sheet16$] union all select * from [sheet17$] union all select * from [sheet18$] union all select * from [sheet19$] union all select * from [sheet20$] union all select * from [sheet21$] union all select * from [sheet22$] union all select * from [sheet23$] union all select * from [sheet24$] union all select * from [sheet25$] union all select * from [sheet26$] 这段代码是26个工作表中一次性提取数据，具体操作点击数据→现有连接→浏览找到所在数据工作表→勾选左下角首行----标题→确定→选数据透视表→点击属性→定义→在命令文本中输入上代码即可

池鱼思故渊#

pxy0409 发表于 2022-5-6 17:11
sql连接,或者pq连接

感谢，大佬，我试试

池鱼思故渊#

fshhhf 发表于 2022-5-7 15:45
select * from [sheet1$] union all select * from [sheet2$] union all select * from [sheet3$] union al ...

感谢，大佬，我试试