I spend a lot of time searching through various Excel files for product information on my office laptop. These spreadsheets contain serial numbers, providers, addresses, and more, which I have to sift through manually to compile orders and manage emails. It's a tedious process, and I'm looking to build a more efficient search tool that I can run locally. I was thinking of using PHP since I'm somewhat familiar with front-end development, but I've been advised to consider Python instead, although I don't have much experience with it. My goal is to create a quick and lightweight program that allows me to search through all these files without having to open each one individually. I'm open to learning something new, but I'd like to know how feasible this is.
4 Answers
Excel files can be a pain to work with, especially since they are essentially zipped XML files. You'll want a good Python library like openpyxl or pandas to handle the complexities of reading and writing Excel files.
Starting with Python is a solid choice! It's user-friendly, and there are plenty of resources available. Just be sure to consider how often your data changes—this will impact how you set up your script.
Instead of just building a script to search through your spreadsheets, consider converting those spreadsheets into a more searchable format. This might be a better long-term solution!
Python is definitely the way to go. You really don't need a full web interface for this; a simple script that reads all your Excel files into a list and allows you to search through that should suffice.
Related Questions
Set Wordpress Featured Image Using Javascript
How To Fix PHP Random Being The Same
Why no WebP Support with Wordpress
Replace Wordpress Cron With Linux Cron
Customize Yoast Canonical URL Programmatically
[Centos] Delete All Files And Folders That Contain a String