Android Question Excel Library

[mrwighty]

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]

Try this:

Dim jo As JavaObject = WritableSheet1
Dim RowNumber As Int = WritableShee1.RowsCount - 1
jo.RunMethod("removeRow", Array(RowNumber))

 

[mrwighty]

Excellent
Thanks Erel - worked perfectly!

 

[mcqueccu]

I will suggest you edit the question to elaborate a bit on your problem so that it can be easily found, or tag it.