All things are lawful, but not all things are profitable.
Dave Tolls wrote:What issue are you seeing?
Does it fail to delete the row, throw an exception, or something else?
Can you post an SSCCE that demonstrates the issue, especially showing how the file is opened and saved?
All things are lawful, but not all things are profitable.
Tim Moores wrote:In that case, since the code you posted only contains two lines that use POI, but none of the crucial loading and saving of the sheet:
Can you post an SSCCE that demonstrates the issue, especially showing how the file is opened and saved?
Knute Snortum wrote:https://coderanch.com/wiki/660111/Doesnt-Work-Useless
"Doesn't work" could mean:
1) Row is cleared but it doesn't get shifted up
2) No action is performed at all
3) Any number of things
Could you be more descriptive about exactly what doesn't work?
All things are lawful, but not all things are profitable.
Knute Snortum wrote:Does "done" print?
Anthony Johnson wrote:
2) No action is performed at all.
Dave Tolls wrote:
Anthony Johnson wrote:
2) No action is performed at all.
But what does that mean?
What action do you expect to see?
All the above code shows is the removal of a row from the sheet, but there's nothing there to show us how you determine whether the row is removed.
Do you save the sheet and then check?
Is there something else you expect to see?
(And I missed you already had a println statement in there! )
All things are lawful, but not all things are profitable.