Python Excel Library: OPENPYXL xlrd Comparison Introduction

Plan to use Python as an automated tool to write MTK camera driver.

1. Template selection Standard library, string--template can be

   But to redefine the replacement character, explain later

2. Config file tangled days: Cfg,yaml, Python,csv.

   However, given that these configuration files are for programmers, plain text words some vendor do not understand, the explanation is too troublesome.

   Finally, the use of Excel, the inside can slowly write the meaning of each configuration, you can add maps, tables, text and other comments, more useful.

   The common Python Excel Lib has xlrd Openpyxl.

??	Compatibility	Speed	Function	??
Xlrd	Full platform	Fast	Less	??
Openpyxl	2010-new	Slow	Many	??

Consider repeatedly, choose OPENPYXL

• refer to https://openpyxl.readthedocs.io/en/default/index.html# syntax and XLRD, which is more intuitive with A1 instead of 11 for a cell.
• New, powerful.
• Slow speed doesn't matter. Self-use can be tolerated.

??

??

??

??

??

??

??

??

Reference Links:

Http://poquitopicante.blogspot.com/2013/06/xlrd-vs-openpyxl-round-ii.html

http://xlrd.readthedocs.io/en/latest/

Https://openpyxl.readthedocs.io/en/default/index.html

Python Excel Library: OPENPYXL xlrd Comparison Introduction