Python3 去除 Excel 空白

【环境】

Windows 10 下，Python 3.6，使用第三方包 openpyxl。

【config.ini】

[config]; Excel 文件名XlFile=D:\test\test.xlsx; 需处理的表单名SheetName=Sheet1

【trim_cell_for_excel.py】

# encoding: utf-8# author: walker# date: 2018-09-26# summary: 去除 Excel 单元格内字符串前后的空白import osimport sysimport timeimport openpyxlfrom configparser import ConfigParserStartTime = time.time()cur_dir_fullpath = os.path.dirname(os.path.abspath(__file__))XlFile = r''SheetName = r''def ReadConfig():     r""" 读取配置文件 """    global XlFile, SheetName        cfg = ConfigParser()    cfgFile = os.path.join(cur_dir_fullpath, r'config.ini')    if not os.path.exists(cfgFile):        input(cfgFile + ' not found')        sys.exit(-1)    with open(cfgFile, mode='rb') as f:        content = f.read()    if content.startswith(b'\xef\xbb\xbf'):     # 去掉 utf8 bom 头        content = content[3:]    cfg.read_string(content.decode('utf8'))    if not cfg.sections():        input('Read config.ini failed...')        sys.exit(-1)            XlFile = cfg.get('config', 'XlFile').strip()              if not os.path.exists(XlFile):        print('Error: not exists %s' % XlFile)        sys.exit(-1)    print('XlFile: %s' % XlFile)        SheetName = cfg.get('config', 'SheetName').strip()     print('SheetName: %s' % SheetName)            print('Read config.ini successed!')def Main():    print('Load %s ...' % XlFile)    wb = openpyxl.load_workbook(XlFile)    print('Load %s success!' % XlFile)    sheet = wb[SheetName]    for i in range(1, sheet.max_row + 1):        for j in range(1, sheet.max_column + 1):            rawVal = sheet.cell(i, j).value            if not isinstance(rawVal, str):                continue            sheet.cell(i, j).value = rawVal.strip()    print('Save %s ...' % XlFile)    wb.save(XlFile)    print('Save %s success!' % XlFile)if __name__ == '__main__':    ReadConfig()    Main()    print('Time total: %.2fs' % (time.time() - StartTime))    print('Current time: %s' % time.strftime(        '%Y-%m-%d %H:%M:%S', time.localtime(time.time())))

【相关阅读】

• Working with Excel Files in Python
  

*** walker ***