Hey guys, I’ve got a question about web apps and spreadsheets.
I’m working on a project that needs a grid-based input system. The problem is, most web GUIs for this kind of thing are pretty bad. The good ones are usually behind pricey APIs that take forever to learn.
I was thinking, what if we used Excel or Calc as part of the web app? Like, could users download a spreadsheet, do their number crunching, and then upload the results back to the website?
Has anyone tried something like this before? I’m wondering if it’s possible to have a spreadsheet submit data directly to a web app.
The main reason I’m asking is that I’m really fed up with the grid controls available for web pages. They’re either too basic or too hard to embed properly.
What do you all think? Is this a crazy idea or could it work?
ooh, interesting idea! have you looked into google sheets api? it might be a cool way to blend spreadsheet functionality with web apps. what kinda data are u working with? im curious how youd handle real-time updates and syncing. could be tricky but also super useful if you pull it off! whats ur main goal with this project?
Using spreadsheet software as a web interface is an intriguing idea, but it comes with challenges. While it could provide familiar functionality for users, integrating Excel or Calc with web applications isn’t straightforward. Security concerns arise when allowing file uploads, and ensuring data integrity can be tricky. Additionally, you’d need to handle various spreadsheet versions and potential formatting issues.
Instead, consider exploring JavaScript libraries like Handsontable or ag-Grid. These offer sophisticated grid controls that can be embedded directly into web pages, providing Excel-like functionality without the need for external software. They’re more seamless for users and easier to integrate from a development standpoint. While there’s a learning curve, it’s likely less steep than building a custom spreadsheet integration solution.