uno – Tarik Billa

OOo/LibreOffice UNO / Java: How to get calling spreadsheet cell of a calc function?

December 7, 2023 by Tarik

It looks like you want to register a listener to a spreadsheet component. To satisfy your goal, you could add the listener to the spreadsheet object it self, or to another nested object that implements an interface that supports an add.+EventListener() method. Below is a pair (broadcaster/listener) that I can think you could use in … Read more

how to convert xls to xlsx

July 16, 2023 by Tarik

You need to have win32com installed on your machine. Here is my code: import win32com.client as win32 fname = “full+path+to+xls_file” excel = win32.gencache.EnsureDispatch(‘Excel.Application’) wb = excel.Workbooks.Open(fname) wb.SaveAs(fname+”x”, FileFormat = 51) #FileFormat = 51 is for .xlsx extension wb.Close() #FileFormat = 56 is for .xls extension excel.Application.Quit() Just wrapped the code above in a function together … Read more