D
datapanix
Hi all,
At the office, we've got many XLS spreadsheets that we use to track and
update lots of info. I'm in the process of migrating the procedure to
a web application. I'm writing the app from scratch, so it does not
natively support parsing XLS files. What I'd like for now is whenever
the XLS file is saved, a CSV is generated which I can then parse and
format appropriately on the web app.
Is there a way to set up a spreadsheet so that this functionality is
possible? I'd like to do it with a minimum of buttons (i.e one on the
spreadsheet that says "click here to export as CSV"), so that the
export operation is transparent to the user.
I realize there are tools available to work with native XLS files, but
for the time being, I'd like to try this. Any help would be
appreciated!
Thanks
At the office, we've got many XLS spreadsheets that we use to track and
update lots of info. I'm in the process of migrating the procedure to
a web application. I'm writing the app from scratch, so it does not
natively support parsing XLS files. What I'd like for now is whenever
the XLS file is saved, a CSV is generated which I can then parse and
format appropriately on the web app.
Is there a way to set up a spreadsheet so that this functionality is
possible? I'd like to do it with a minimum of buttons (i.e one on the
spreadsheet that says "click here to export as CSV"), so that the
export operation is transparent to the user.
I realize there are tools available to work with native XLS files, but
for the time being, I'd like to try this. Any help would be
appreciated!
Thanks