M mrwighty Member Licensed User Longtime User Oct 8, 2018 #1 Hi, I have a customer who wants an option to delete the last row in an excel worksheet, is there an easy way todo this? I could loop all rows and copy to another sheet but hoping there is an easier way (Remove/Delete/Uninitialise a Row)? Thank you
Hi, I have a customer who wants an option to delete the last row in an excel worksheet, is there an easy way todo this? I could loop all rows and copy to another sheet but hoping there is an easier way (Remove/Delete/Uninitialise a Row)? Thank you
Erel B4X founder Staff member Licensed User Longtime User Oct 9, 2018 #2 Try this: B4X: Dim jo As JavaObject = WritableSheet1 Dim RowNumber As Int = WritableShee1.RowsCount - 1 jo.RunMethod("removeRow", Array(RowNumber)) Upvote 0
Try this: B4X: Dim jo As JavaObject = WritableSheet1 Dim RowNumber As Int = WritableShee1.RowsCount - 1 jo.RunMethod("removeRow", Array(RowNumber))
M mrwighty Member Licensed User Longtime User Oct 9, 2018 #3 Excellent Thanks Erel - worked perfectly! Upvote 0
mcqueccu Well-Known Member Licensed User Longtime User Oct 9, 2018 #4 I will suggest you edit the question to elaborate a bit on your problem so that it can be easily found, or tag it. Upvote 0
I will suggest you edit the question to elaborate a bit on your problem so that it can be easily found, or tag it.