Friday, September 8, 2017

Reading Excel Spreadsheets with Python

Excel & Python

Reading an Excel Spreadsheet

In this section, we will look at a function that demonstrates reads the Excel sheet data and convert that data into XML file.

We Used the following libraries to do the above functionality


  • Openpyxl : Openpyxl is a Python library for reading and writing Excel 2010 xlsx/xlsm/xltx/xltm files.
  • xml.etree.ElementTree: To create the xml tree elements
  • datetime: to conver the date time column values to specified format 


No comments:

Post a Comment