Is it possible to use this package to connect to an excel that's stored on a server? The path you're using is obviously local, im building an app which requires working with an excel file and I'm trying to figure out if I can do it as a web app, and whether it's best to actually interact with Excel or just build a database structure the same as I want the excel to be then just export the database as a CSV and put that into an excel file. Any advice?
So I did a little reading on the connection string and I can't seem to find any examples on files that are stored in a server. Just out of curiosity what server is being stored on?
@@SigmaCoding whatever server I host my app on ;) haha. This is a big project for someone of my limited knowledge. I'm thinking of just storing what I need in a db then joining the tables and exporting as csv