 |
| 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
