Using Python to read and write Spreadsheet

Post date: Aug 26, 2016 4:23:31 PM

I just use the package called openpyxl.

• https://automatetheboringstuff.com/chapter12/ -- a great introduction to the topic
• https://openpyxl.readthedocs.io/en/default/ -- the API doc, very easy to read and follow, how to install the package
• http://www.pythonexcel.com/python-excel-writer.php -- a few essential examples to get job done
• http://stackoverflow.com/a/28782635/1613297 -- the function to convert number into excel style letter column

#openpyxl, #spreadsheet