Lpla 개발 블로그

Python

[Python] xls를 xlsx로 변환하는법, xlsx를 xls로 변환하는법

xls를 xlsx로 변환하는법 # xls to xlsx import win32com.client as win32 fname = "11번가.xls" excel = win32.gencache.EnsureDispatch('Excel.Application') wb = excel.Workbooks.Open(fname) wb.SaveAs(fname+"x", FileFormat = 51) #FileFormat = 51 is for .xlsx extension wb.Close() #FileFormat = 56 is for .xls extension excel.Application.Quit() xlsx를 xls로 변환하는법 # xlsx to xls from win32com.client import Dispatch xl ..