Hi Stepan, i am not an expert in java. 1) What does the new code look like in Java? I can't find any help on the internet. Attached my csv. thanks in advance Siegfried
Am Dienstag, 5. Mai 2020 11:01:21 UTC+2 schrieb t603: > > 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/55d8f97e-ce8b-4f25-88a6-ed56ae152ae8%40googlegroups.com.
ANREDE,TITEL,NAME,VORNAME,STRASSE,PLZ,ORT,TELEFONPRIVAT,HANDY,EINTRITT,GEBURTSDATUM,EMAIL Herrn,,Schulze,Lothar,Meier-Str. 10,58339,Breckerfeld,02338 265412,365623822,1990-01-01,1949-11-05,[email protected] Herrn,,Müller,Thomas,Böcklerstr. 22,58340,Hagen,02331/265885,,1975-08-27,1956-04-16, Herrn,,Beck,Friedrich,Lützowstr. 48,58341,Hagen,,17255765737,1960-01-01,1957-05-05,[email protected] Herrn,,Schuster,Detlef,Buschstr. 19,58342,Hagen,02331 658942,1725273338,2017-06-25,1956-09-29,[email protected] Frau,,Schuster,Kornelia,Buschstr. 19,58343,Hagen,02331 658942,,2017-06-25,1957-05-14,[email protected]
