Reputation: 185
I have an Excel spreadsheet on which I run macros to generate a json file, which I include in my project in the raw folder for further use within the app. But this produces an overhead of exporting an Excel file with the project.
I was wondering if it was somehow possible to include a csv file within the project and run the macro code (or some other code) on it in runtime to get the json string?
Upvotes: 0
Views: 1194
Reputation: 5224
Here's a question on Read CSV with Scanner().
You find an executable java main
method in the first answer. This may be a good starting point for you.
Upvotes: 1