Evgen Jin EvgenJin
EvgenJin
/ csvToXlsx.groovy
Last active
June 3, 2020 23:17
— forked from VadimKirilchuk/csvToXlsx.groovy
Convert CSV to XLSX (Streaming)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| @Grab("org.apache.poi:poi:3.16") | |
| @Grab("org.apache.poi:poi-ooxml:3.16") | |
| import org.apache.poi.xssf.usermodel.*; | |
| import org.apache.poi.ss.usermodel.*; | |
| import org.apache.poi.xssf.streaming.*; | |
| def csvToExelNotExists() { | |
| try { | |
| String csvFileAddress = "./test.csv"; | |
| String xlsxFileAddress = "./autos.xlsx"; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #! /usr/bin/env groovy | |
| @Grab("org.apache.poi:poi:3.16") | |
| @Grab("org.apache.poi:poi-ooxml:3.16") | |
| import org.apache.poi.xssf.usermodel.*; | |
| import org.apache.poi.ss.usermodel.*; | |
| import org.apache.poi.xssf.streaming.*; | |
| /** more java than groovy, will make fancier later **/ | |
| def csvToXLSX() { |