# import xlsxwriter module
import xlsxwriter
from fpdf import FPDF
import pandas as pd
workbook = xlsxwriter.Workbook(‘Example2.xlsx’)
worksheet = workbook.add_worksheet()
def createXl():
# Start from the first cell.
# Rows and columns are zero indexed.
row = 0
column = 0
content = [“Serial_No”, “Invoice_No”, “Purchase_Dt”, “Sell_Dt”,
“desciption”, “Expiry”, “Quantity_Sell”, “Quantity_Purchased”,“Remaining_Quantity”]
# iterating through content list
for item in content :
# write operation perform
worksheet.write(row, column, item)
# incrementing the value of row by one
# with each iterations.
column += 1
def update_xl():
row = 1
column = 0
content = [“12”, “323”, “13-04-23”, “34-04-34”,
“desciption”, “56”, “4”, “400”,“396”]
# iterating through content list
for item in content :
# write operation perform
worksheet.write(row, column, item)
# incrementing the value of row by one
# with each iterations.
column += 1
def close_Xl():
workbook.close()
def create_invoice(*args):
pdf=FPDF()
pdf.add_page()
pdf.set_font(“Arial”, “B”,8)
pdf.cell(w=0,h=5,txt=Inv,ln=1)
pdf.cell(w=1,h=5,txt=Inv4,ln=2)
pdf.cell(w=2,h=5,txt=Inv1,ln=3)
pdf.cell(w=3,h=5,txt=Inv2,ln=4)
pdf.cell(w=4,h=5,txt=Inv3,ln=5)
pdf.output(‘Inventory_1’)
createXl()
update_xl()
close_Xl()
df=pd.read_excel(“Example2.xlsx”)
Invoice_No=df[[‘Invoice_No’]]
Product_Desc=df[[‘desciption’]]
Quantity=df[[‘Quantity_Sell’]]
Inv=‘———————————— \n’
Inv4= str(Invoice_No)
Inv1= str(Product_Desc)
Inv2= str(Quantity)
Inv3= ‘\n —————————–‘
Inv=str(Inv)
#update_xl()
create_invoice(Inv)
print(df)
print(df[[‘Invoice_No’]])
print(Inv)
Hi,
Just to add some extra points can it be possible to make it more user friendly like using any UI would greatly work for those who needs Inventory Management solution.
Hi,
Thanks for reply we are working on creating an application that works on windows, android and ios too.
We are going to achieve this by using Kivy_Language which is again a part of python to have multiplatform
applications.
Thannks,
MyNaukri.co.in