AutoXL is a python program to automate excel or spreadsheet to perform a task which earlier consumed considerable time doing manually. But with AutoXL it can be done in a matter of seconds.
Apart from automating and fixing the xlsx file, a bar chart is also added to display the corrected column as a reference.
How code works
- The program takes an excel file name with its extension as the input, along with the name which is to be added for the updating column.
- Built in openpyxl is a python library which is used to read/write Excel 2010 xlsx/xlsm/xltx/xltm files.
- Workbook/Spreadsheet is then loaded into the program and the sheet which is to be updated is passed as an argument to instance of the openpyxl.
- Rows and cells are accessed and required updates are made.
- Built in classes of openpyxl i.e. BarChart and Reference are used to acces the values of updated rows and column.
- Values are then passed to instance of BarChart and is then addded to the sheet.
- Aftermost, Excel file is then saved.