from flask import Flask, request, render_template
import pandas as pd
from pandas.io.excel import ExcelWriter
app = Flask(__name__)
@app.route('/')
def index():
return render_template('index.html')
@app.route('/entry', methods=['POST'])
def entry():
cell = request.form['cell']
value = request.form['value']
df = pd.read_excel('data.xlsx')
df.loc[cell] = value
writer = ExcelWriter('data.xlsx')
df.to_excel(writer,'Sheet1',index=False)
writer.save()
return "Data entered successfully"
@app.route('/email', methods=['GET'])
def email():
# code to send the excel file as an email attachment
return "Email sent successfully"
@app.route('/print', methods=['GET'])
def print():
df = pd.read_excel('data.xlsx')
df.to_pdf('data.pdf',index=False)
# code to print the pdf file
return "PDF printed successfully"
if __name__ == '__main__':
app.run(debug = True)
Email
Print
