tinyDB and file component

Hello
While using app inventor i discovered file component , my question is that can i use it to write excel file and export it on my android device ?
if yes can i also append to an existing one?
if yes please provide me with an aia file for than or a tutorial.
One more question I want to use my app like a stock so what condition may lead to my tinyDB to disappear or corrupts in it .
Sorry for my beginner questions but my app will be used as stock in company and there must be no fault in it.
Thank you .

There’s no direct way to open or write Excel files. Instead, you should export your Excel sheet as csv file. Then you can read it in App Inventor with the file component and turn it into a list with the “list from csv row” block.

There is a paid extension to read and write excel files.

It is rather limited but may be enough for you.

1 Like

@Italo an you give me an aia file for writing and reading on csv fie , and please can you answer me on tinydb issue.
thank you

it is really very simple, just use the file component…
you might want to try it yourself and if you get stuck, post a screenshot of your relevant blocks

see also the FAQ Section: Files


A very good way to learn App Inventor is to read the free Inventor’s Manual here in the AI2 free online eBook http://www.appinventor.org/book2 … the links are at the bottom of the Web page. The book ‘teaches’ users how to program with AI2 blocks.
There is a free programming course here http://www.appinventor.org/content/CourseInABox/Intro and the aia files for the projects in the book are here: http://www.appinventor.org/bookFiles
How to do a lot of basic things with App Inventor are described here: http://www.appinventor.org/content/howDoYou/eventHandling .

Also do the tutorials http://appinventor.mit.edu/explore/ai2/tutorials.html to learn the basics of App Inventor, then try something and follow the Top 5 Tips: How to learn App Inventor

Taifun


Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun.

Also consider converting to Google Sheets, which is more compatible for data access and synchronisation

Be sure to read the chapter in your bookkeeping course on tracking stock addition, withdrawal, inventory, pricing, fraud and theft. Companies have gone bankrupt when their stock disappeared.

@TIMAI2 the app will be used across the day without internet , maybe it is a good idea to save them to a tinydb as a list and when connecting to internet save them on google spreadsheet .

1 Like