I have a a list of invoices created with LibreOffice Calc inside a folder. Now I would like to retrieve the data inside of those invoices to create another spreadsheet called “All” that contains a row for each invoice.
Name Phone Street
John 677 Main
Mary 897 Niceday
Is there any way to do that automatically?
One more: imagine, I add a new invoice file, I would like that after addding it, the Name, Phone and Street inside it, were added automatically to the “All” file.
Is possible? Should I create an script? What language shoould I use (LibreOffice Basic, Javascript, Python…)?
Im on Ubuntu, but the script should work in the computer of my customer (Windows 8), where I also installed LibreOffice.