[Python] Automation using Python

from openpyxl import load_workbook
from openpyxl.chart import BarChart, Reference
from openpyxl.utils import get_column_letter
from openpyxl.styles import Font
import os
import sys

application = os.path.dirname(sys.executable)
month = input("Enter the month: ")

input_path = os.path.join(application, 'pivot_table.xlsx')
wb = load_workbook(input_path)
sheet = wb['Report']


min_column = wb.active.min_column
max_column = wb.active.max_column
min_row = wb.active.min_row
max_row = wb.active.max_row

barchart = BarChart()

data = Reference(sheet, min_col=min_column+1, max_col=max_column, min_row=min_row, max_row=max_row)
categories = Reference(sheet, min_col=min_column, max_col=min_column, min_row=min_row+1, max_row=max_row)

#Adding Data & Categories
barchart.add_data(data, titles_from_data=True)
barchart.set_categories(categories)


# Making Chart
sheet.add_chart(barchart, 'B12')
barchart.title = 'Sales by Product line'
barchart.style = 10

# Loop through columns data
for i in range(min_column+1, max_column+1):
letter = get_column_letter(i)
sheet[f'{letter}{max_row+1}'] = f'=SUM({letter}{min_row+1}:{letter}{max_row})'
sheet[f'{letter}{max_row+1}'].style = 'Currency'

sheet[f'{get_column_letter(min_column)}{max_row+1}'] = 'Total'

sheet["A1"] = 'Sales Report'
sheet["A2"] = month
sheet["A1"].font = Font('Arial',bold=True, size=20)
sheet["A2"].font = Font('Arial',bold=True, size=20)

output_path = os.path.join(application, f'report_{month}.xlsx')

wb.save(output_path)



I try to automate the excel file on terminal were the user will enter the input, but there is till an issue going on were the user input is not asking it just directly says successfully completed I need a help for this code.

Continue reading...