Hi ,
I am now trying to adopt LO as my full time replacement to MS Excel, as I use VBA Macro in most of my work, I am stuck at this point for now,
in VBA , I was using
"example:
- Range(“A10”).End(Xlup).Offset(1,0)
- Range(“A10”).End(Xldown).Offset(1,0)
- Range(“A10”).End(XltoRight).Offset(1,0)
- Range(“A10”).End(XltoLeft).Offset(1,0)
to navigate , and find the last row , Right side, left side , I particularly use this function to do my thing, but i couldnt find and example, which is equivalent to this in Python , in LibreOffice.
If someone could help me , how to do the above four operations with Python in libreoffice with some example, it would be a great help to me.
please note : i have googled , binged, used duck duck go, but couldnt find the solution. please help me out , I am stuck.