BTW Why are you saving each column header with piece piece of data but not saving the part no? Your file is full of redundant information but is missing what I'd consider a piece of vital information ie which part no the data relates to.
My Part column is holding the part type in each cell. That is my fixed cell data. I'm making a sort of build sheet for a mountain bike but I'd like to do it in
Java instead of Excel. Part has all the parts listed in it already.
Part
______
Frame:
Fork:
Rear Shock:
Headset:
ect..
This column is all fixed since there are only so many parts on a bike, about 35. This way the user can just enter a model/description, price, and weight and not have to worry about what parts they need or forgetting to include something since its all listed there for them. They can just go easily down the list.
That is the best way I can explain it.
All I want to do i re-write my saved data back into the table without adding rows below where my fixed data ends. 35 rows for 35 parts. If I can do that ignoring my part column, wonderful. If it has to be overwritten that's fine too.
I'm thinking I would need to set the values in each cell for the given row somehow, then repeat this process by using a similar for loop as to when the data was saved.