Python Forum
Script to read, write data to excel file and update it to firebase
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Script to read, write data to excel file and update it to firebase
#1
I am going to do a project on database analysis where the data is read from an excel file. The user should be able to search for the dates, employee ids etc. The no of hours attended by each employee should be calculated with the hours that the employee missed also the percentage of attendance, alert if it gets below a certain margin. All these details need to be updated in the employees' page in firebase from the excel file regularly. The admin should be able to update the details with GUI.

Now being new to python, I just know the basics like to create classes, function etc. So what should i learn to be able to do the above or is there some script already avail that i can use? what packages will i need?
I got like 3 months to this! Thank you! Huh
Reply
#2
Pick one part, and start there. The real starting point, should be figuring out what it is you're doing. For example, why would you let someone search through data in excel, if you're also copying an excel doc into firebase and allowing admins to update firebase? Anything they search in the excel file would be outdated, or missing information.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Help with to check an Input list data with a data read from an external source sacharyya 3 318 Mar-09-2024, 12:33 PM
Last Post: Pedroski55
  Python openyxl not updating Excel file MrBean12 1 249 Mar-03-2024, 12:16 AM
Last Post: MrBean12
  Copy Paste excel files based on the first letters of the file name Viento 2 348 Feb-07-2024, 12:24 PM
Last Post: Viento
  Last record in file doesn't write to newline gonksoup 3 364 Jan-22-2024, 12:56 PM
Last Post: deanhystad
  Recommended way to read/create PDF file? Winfried 3 2,784 Nov-26-2023, 07:51 AM
Last Post: Pedroski55
  write to csv file problem jacksfrustration 11 1,372 Nov-09-2023, 01:56 PM
Last Post: deanhystad
  python Read each xlsx file and write it into csv with pipe delimiter mg24 4 1,308 Nov-09-2023, 10:56 AM
Last Post: mg24
  Search Excel File with a list of values huzzug 4 1,147 Nov-03-2023, 05:35 PM
Last Post: huzzug
  Updating sharepoint excel file odd results cubangt 1 754 Nov-03-2023, 05:13 PM
Last Post: noisefloor
Question Special Characters read-write Prisonfeed 1 581 Sep-17-2023, 08:26 PM
Last Post: Gribouillis

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020