/**
     * 隐藏列
     * @param sheet
     * @param hiddenColumns
     */
    protected void hideColumns(Sheet sheet,List<Integer> hiddenColumns) {
        if (null != hiddenColumns && hiddenColumns.size() > 0) {
            for (Integer hiddenColumn : hiddenColumns) {
                sheet.setColumnHidden(hiddenColumn, true);
            }
        }
    }

import pandas as pd
from openpyxl import load_workbook
import os
#输入路径
dir = r"C:\Users\lyp\Documents\WeChat Files\W2956224\FileStorage\File\2020-04\res"#设置工作路径
#合并后的输出路径
shuchu='D:\\merge\\sheet2.xlsx'
frames=[]
allcount=0
for root, dirs, files in os.walk(dir):
    for file in files:
        filename=os.path.join(root,file)
        print(filename)
        allcount+=1
        print(allcount)
        wb = load_workbook(filename,data_only=True)
        ws = wb.active
        sheets=wb.worksheets
        #合并表格的索引
        sheet=sheets[0]
        hidden_cols = []
        rows=sheet.rows
        #取出非隐藏列的id
        for colLetter,colDimension in sheet.row_dimensions.items():
            if (colDimension.hidden == False and colLetter>3):
                hidden_cols.append(colLetter)
        count=0
        onesheet=[]
        for row in rows:
            one=[]
            count+=1
            if(count  in hidden_cols):
                for cell in row:
                    one.append(cell._value)
                onesheet.append(one)
        df=pd.DataFrame(onesheet)
        frames.append(df)
result = pd.concat(frames)
result.to_excel(shuchu)#保存合并的数据到电脑D盘的merge文件夹中，并把合并后的文件命名为a12.csv

隐藏列：ctrl+shift+右键 然后点击右键取消隐藏

隐藏行:ctrl+shift+下键盘，然后点击右键取消隐藏

调节列宽的时候要注意表格全部选中以后要在首行点击右键。

行就好操作了


加列的快捷键：ctrl+shift+（+）这里的指的就是键盘上面的那个加号键盘。