@89trunks I was wondering the same thing (just seen mentioning of Tika but never saw a working example though) and tried a few things. You actually get the data out from the ODS file but they are all in one column. I was initially able to transpose and convert a small example but a larger example failed and it also failed to preserve date and time fields.
I expanded my initial example to also export to several formats from R directly that would be better suited to preserve data and time formats:
