Help with Arrays and Jexcelapi
I've finally got Jexcelapi working and am able to read cell values and print them out. Now I want to use the data I read in from the spreadsheet. I'm able to read the data, perform math operations, and print it out again... but only one cell at a time.
I'm building a simple card game. I want to read the data in from excel and temporarily modify the values without writing back to Excel. For example, here is a sample of the data from the spreadsheet I am reading...
I want to read this data from the spreadsheet into an array of objects, then be able to change individual elements of the array. For example, subtract Health off a Unit that gets attacked.
I have been messing around with arrays and am having trouble understanding how to do this.
I just started using Java a couple weeks ago and have done a lot of reading. I finally learned how to read/write from a spreadsheet, but I don't want to create a temporary spreadsheet because I really don't build my program this way and would like to learn how to do it with arrays.
Any help would be appreciated.
Thanks in advance!
PS - I would like to be able to read this data into a single array of 6 rows and 3 columns instead of making 3 arrays.