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/c8d69202-c361-4930-8414-d28bdde0d710%40googlegroups.com.
