Python + PHP + Excel = Data Entry Automation Part 1
Channel:
Subscribers:
567
Published on ● Video Link: https://www.youtube.com/watch?v=RSRLNU4QepE
4The behind the scenes on how I put few things together to automate a BORING process of data entry. I was totally not aware the Python has a library called pyautogui that has the magical ability to simulate keypresses... Amazing!
Using Excel as the data source is possible thanks to the PHPExcel library (reads the rows and columns of an excel file) and some good old PHP + Apache2 web server.
I will be exploring this more with a sophisticated web page and potential ways to optimise the process for my personal amusement.
If you would like the code just let me know and I will potentially send you a link or something.
Other Videos By Geb Systems
| 2022-05-13 | Warehouse & Production System... 2nd Update, da Gun |
| 2022-05-02 | Vretti D4602B barcode print test |
| 2022-04-26 | Warehouse & Production System... 1st Update |
| 2022-04-11 | Python Cheats Magicka 2 |
| 2022-04-08 | One more Arduino at LTB |
| 2022-04-06 | Warehouse & Production System... The beginning |
| 2022-04-01 | PHP Projects: WMS and KVM |
| 2022-03-26 | PyAutoGUI: Normal speed entry input |
| 2022-03-26 | PyAutoGUI: 100 entries in 18 minutes |
| 2022-03-22 | PyAutoGUI: How to automate web page data input |
| 2022-03-20 | Python + PHP + Excel = Data Entry Automation Part 1 |
| 2022-03-19 | Motion Triggered MP3 player.. 1st UPDATE |
| 2022-03-17 | MITM Protection Tool |
| 2022-03-15 | DIY Marble Track |
| 2022-03-11 | Motion Triggered MP3 player |
| 2022-03-07 | FreeCAD Spreadsheet in practice |
| 2022-03-04 | Din rail holder body redesign |
| 2022-03-02 | Arduino RS485 50M Test |
| 2022-02-26 | 3D Printed din rail mount on a server rack |
| 2022-02-25 | DIY 2U Rack din rail mount (mod) in FreeCAD |
| 2022-02-24 | DIY Arduino IoT enclosure assembly |
Tags:
programing
coding
python
php