I'm new to Rad Studio so I may be missing something, but I am trying to create an iOS app that just displays a list of data. I currently have an iOS app with a tListView that gets populated by a ClientDataSet, which is populated with data that I hard-coded into an xml file that's on my PC. I want to be able to fill my ListView with the data that is in an excel file instead of xml file so that when I need to add an item I can just add it in the excel file on my PC and rebuild the project. Is this possible? The only way I have found to access excel file data is TADO Connection, but it seems you can not use it on iOS applications. Thank you in advance.
I strongly recommend against using Excel files for this purpose. There are several reasons for that:
If your data is fundamentally a hierarchy (a tree) of various objects with different sets attributes, use JSON or XML.
If your data is rather a set of similar objects (a table), use CSV.
Whether you choose JSON, XML or CSV, parsing them will be a much easier task for a mobile app.
If you need a convenient GUI to manually update a file like that, consider using Visual Studio Code with plugins. Or, in case of CSV, you can actually use Excel (just save the final result back to .csv rather than to .xlsx).