Hi Siegfried, You can try this library : https://github.com/miachm/SODS to write a custom function to export table in ODS file. It works well. Regards Erwan
Le mardi 5 mai 2020 11:01:21 UTC+2, t603 a écrit : > > 1) Try to set up CSV OPTIONS (lineSeparator, fieldSeparator, > fieldDelimiter are among the most important for this task) in CSVWRITE, so > then You can doubleclick on CSV and it opens without any additional steps > directly in MS Office. Works for me great! Can be used for just only one > sheet and no formatting. > > 2) When You need multiple sheets, formatting, even very complex one, You > need to do some automatic post-processing. Try SpreadsheetML (Microsoft > easy readable and writeable XML format, not the current XLSX which looks > very similar to (X)HTML). The XSLT 3.0 and XPath 3.1 using Saxon 10 HE is > my choice. But You have to be familiar with XSLT a XPath. > > Regards, Stepan > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/ad57ac97-f724-467a-8d80-5029797f6ebe%40googlegroups.com.
