Import Excel data previous exported in neoTable
Quote from Ronnie on March 18, 2021, 8:51 amHi @luishp, is it possible to import a data file (like Excel, CSV, etc) that was previously exported from neoTable?
For example, as data is stored in LocalStorage, there might be instances where the data is gone for whatever reasons. It'd be great to have an option to reload the saved data into neoTable. Can this be done?
Rgds, Ronnie
Hi @luishp, is it possible to import a data file (like Excel, CSV, etc) that was previously exported from neoTable?
For example, as data is stored in LocalStorage, there might be instances where the data is gone for whatever reasons. It'd be great to have an option to reload the saved data into neoTable. Can this be done?
Rgds, Ronnie
Quote from luishp on March 18, 2021, 1:46 pm@ronnie you can use neoSQL plugin to load CSV or Excel data into a JSON object and then into neoTable.
Best regards.
@ronnie you can use neoSQL plugin to load CSV or Excel data into a JSON object and then into neoTable.
Best regards.
Quote from Ronnie on March 19, 2021, 8:19 amHi @luishp I’m thinking wild here...or anybody who’ve used neoSQL plugin before...
Let’s say I’ve sample.xlsx in “myprogram\files” sub folder.
1) does it means that I can read/write to the”myprogram\files\sample.xlsx” file, and used it like a dB file?
2) I’d assuming above (1) is correct, will it work on Android/iOS mobile devices, hence bypassing the need for local storage constraints?
thanks in advance...
Hi @luishp I’m thinking wild here...or anybody who’ve used neoSQL plugin before...
Let’s say I’ve sample.xlsx in “myprogram\files” sub folder.
1) does it means that I can read/write to the”myprogram\files\sample.xlsx” file, and used it like a dB file?
2) I’d assuming above (1) is correct, will it work on Android/iOS mobile devices, hence bypassing the need for local storage constraints?
thanks in advance...
Quote from luishp on March 19, 2021, 11:21 am@ronnie with NeoScript you can only read, not write. But yes, it's possible to use it as a read only database and it works prety well. For writing, it would be necessary a server side script using something like this PHP library.
It's possible to write a Plugin as I did with neoPhp, but it's not easy and takes time.
Best regards.
@ronnie with NeoScript you can only read, not write. But yes, it's possible to use it as a read only database and it works prety well. For writing, it would be necessary a server side script using something like this PHP library.
It's possible to write a Plugin as I did with neoPhp, but it's not easy and takes time.
Best regards.
Quote from asmat on March 19, 2021, 2:07 pmHi @ronnie,
I think the easy ways for reading excel files are:
- Save your excel file to .csv or .txt file, then import with file input, you can easily read. this way works for a web app, android app, and also windows app (PWA).
- You can use copy-paste, for the fastest way it will good option for some private app, it works on web app and windows app.
Hi @ronnie,
I think the easy ways for reading excel files are:
- Save your excel file to .csv or .txt file, then import with file input, you can easily read. this way works for a web app, android app, and also windows app (PWA).
- You can use copy-paste, for the fastest way it will good option for some private app, it works on web app and windows app.
Uploaded files:
- You need to login to have access to uploads.
Quote from javadrajabihakami on March 19, 2021, 2:35 pmHello and good time dear friends ...! If possible, please put this discussion in the form of a project example for our better learning! Thanks...
Hello and good time dear friends ...! If possible, please put this discussion in the form of a project example for our better learning! Thanks...