xlwings和openpyxl的区别
xlrd可以读xls、xlsx；
xlwt可以写xls；
openpyxl可以读写xlsx
记住我openpyxl：不需要excel软件，仅⽀持.xlsx格式
You are correct in that relies on , whereas does not.
openpyxl
A ".xlsx" excel file is essentially a zip-file containing multiple XML files formatted according to Microsoft's . With this specification it's possible to create a program capable of directly reading/writing excel files in just about any programming language. This is the approach applied in openpyxl: it uses python code to read/write excel files directly.
xlwings
A Microsoft Excel application can be started and controlled by an external program through the . The pywin32 package provides an interface between Win32 COM and Python. Through a python script with the right pywin32 commands you can fully control an Excel Application (open excel files, query data from cells, write data to cells, save excel files, etc.). The pywin32 commands that you can use mirror the , albeit with python syntax.
xlwings is (among other things) a user-friendly wrapper around pywin32. It introduces several concise-yet-powerful methods. An example would be the methods for direct of an excel cell range to a numpy array or pandas dataframe (and vice versa).
Summary
A fundamental difference between xlwings and openpyxl is that the former requires that MS Excel is installed on your machine, whereas the latter does not.
发布评论