Streamline Your Invoice Management Excel for Animal Science with airSlate SignNow

Invoice management excel for Animal science

hello everyone I am sambar Tia and I welcome to on a car one two three today we'll discuss how to make the software in Python and how to connect a database like MySQL and Excel Excel is a very good database storage software it does mean instead of MySQL we will connect with the Excel database here and all this increase in voice it does mean in this video we will discuss how to make the invoice how to print the invoice how to save the invoice and how to display the invoice in everywhere okay let's start this is my source code am I in opening here in ideally you can open a anything where you have ideally are yes Here I am opening I am running the software and when it will run yes username I am entering here that is sham and and password and if you go to this thing and this is the invoice area where our invoice will display what we and here the here the content for restaurant billing our hotel William rotate andouille dal makhni curry Java and Zira Rajasthani and etc here here the pay taxes and here the hotel type meal breakfast lunch and room type single bread double word editor optimally and etc so first of all I am entering here and this is the area where the already existed database we can watch so this will expand it and here is the scroll bar and here now display the Excel database yes if you press this button then you will find do you want to display this data yes and if you do yes and you will find the two column Shawn Bhatia and Delhi and another column Shyam Sharma and Bombay this to entry is already existed okay so you can reset it and make the inverse first name you can the this via and surname you demented idea address like in Bangalore postal code one two three four are an example mobile dummy while number email is making the invoice dummy email okay nationality it is the combo box you will find the British are Indian and data birth you know you can say five 1208 and what what 1964 an example and and here the ID type you want to include the other card and you can take the gender female and here the check in debt 20 February and twenty okay twenty-two and a month is same and twenty one you have live and meal you took a lunch and you can do the single bed okay and here Thunder ot yes Michael twelve you can say the thirteenth and URI and dal makhni you can say one only Khadija 1 2 and 0 raise to okay and Holly one it is not possible for one person to eat it but for in the meantime making so and it is not possible for one person to to eat it so large amount of this any special thali is okay but all interests must be filled ok and and and if I'm if I make this thing then total then area here will be in in the text and cost and it will yes 919 this is the text amount this is the cost and total grain cost is six thousand 25 rupees and here the invoice and this is the number and customer number you guys are and DV abadieh Bangalore and etcetera and number of studies one days 22 21 okay and a rotatory and it is the scroll bar and you can take all this okay and it is if it is the one total and print ourselves just you can type in print do you want to invest plenteous yes if a to yes then this is printing here and yes this is the printer and going on printing and after printing this bill I can cut it okay here the also asking me do you want to say this and if I make yes then then it it will save on this desktop and I can save it for an example Divya [Music] twice Bangalore for an example whatever you if you are using this thing in you you can make the separate folder and all this Inuits must be saved at their location but I am just making this far okay and just to save it okay the display invite save the successfully okay and go to the watch is it saved or not the Viva Bangalore okay and if you edit are open this thing then just maximize it in you watch Divya Bhatia Bangalore address and what does and all this interest this is the separate database you can say it's the universe or cell but is it actually are saved in in in my what it's a database are not but until and unless you are not insert this data into the Excel insert then it will not insert in it okay so first of all I will inserting in in it okay excellent sir T yes we want to insert this data yes if I make it successful and now if you want to display their thing yes then you will find what you will find here Divya Bharti and Bangalore etcetera this column was not present before okay only and this is the end if you reset button this may be the reset then I will clear okay and this is the exit button okay that's it yes do you want to really exit yes I really exit and let's go to the actual database by default it will make the record folder are you just to make that got folder and I have already path set it to see folder and record folder Oh and if you take if you purchase this software then you will you have to make only the required software in your C Drive and paste this customer table and I will give you this table and if you if you want to love this whole coding from basic to this level then you can join our program easily with he surprised with is supporting price then I I will take the whole process how to do that I am opening this customer table because all data I inserted in it exhale I am opening the upsell and all this interest which I made earlier which I inserted from front-end which are which are existed in it okay and completely inserted it in we have already cached on fronted also but it is opening in a taking if attempts yes charm and as a it was present earlier in DVI inserted right now Bangalore and address and its etc and all these entries are present here lunch have taken single and all the pay tax and cost and etcetera all this thing are presented I am I can insert another another int is also what just to cut it and redone again program pressing f5 what will you do just to go to the your source code where is my source code just opening and just to press the f5 array you can run from here and we login again into your software and you will find what what the actually need and how Boop's yes a it is too much time but it's yes it's come here and I even I am logging again yes this is software and I am what-what-what-what built in some dummy entries for Rahul okay surname nothing but nothing but shamans and and so on address and nothing but just I am entering too okay - two-for-one okay and here meal okay breakfast I am taking the cottage all sits okay nothing but in the total then you will find the 248 six cottage Charlotte it's very and here here if he makes me sit and and then cost a you know friends okay and mill charges 300 okay and here is Hollis the see because it is the heck the six quantity and you of you will find by dividing this jewel day okay here is the one day y -1 days representing me here fronts because two and one it's not possible so just to make it clear and you will make it what the mean three what I made a role and I I do do two and three okay and make it meal okay and the card each animal is five right now and make it the again bill okay one days plus one days okay and hero okay number is 1 and n make it if you want to insert this thing then we want to say yes I am NOT going to print it okay net and do you want to say also I am not saving it okay but I want to excel insert into Excel yes and just so it is it inserted or not yes yes yes you are role in a nothing but okay all this interesting thing so everything what you want to insert a new ticket will inserted in it and and this invoice you can add and subtract and anything and you can make the reset and friends here and you want to purchase this software are you want to then customize it I will customize for you and you can take it and and many things about it you can tag alpha and if you wanna learn now with coding with with proper how to make this setup I and how to say all this then you can easily join our forces and you will got thank you very soon again and if you really like it then subscribe then like okay Baba we'll meet