fastexcel
fastexcel copied to clipboard
Generate and read big Excel files quickly
Follow your example, but i got OutOfMemory error if reading large excel file (1GB). Small one(200MB) still good. Here is the line throw error because of reading whole excel file...
when a cell copy the formula of above cell, the cell return empty formula. we see the code at line 144 of org.dhatim.fastexcel.reader.RowSpliterator shown as following: ![image](https://user-images.githubusercontent.com/77994430/116651260-a915b680-a937-11eb-9eb2-66d1f69a1cd7.png) the t attribute...
Is it possible to set a default font name and size using fastexcel? If so, how? I've tried to use `sheet.range()` over the entire document, however this seems to drastically...
Hello all, I am trying to create an Excel file with 3 worksheets. Two of the 2 worksheets contain up to 1,000,000 rows. The file is created and seems to...
i am uploading excel file with record count of 10K. when i use foreach, its working properly. but when i try to use parallel.forEach(), its not read all the values...
Hi, I upgraded to the newest fastexcel version and my projects fails when writing a null to a cell value. Since the setValue function changed and evolved from one function...
Hi, I think I have found an off by one error when using Cell.asDate(). The test below creates a Workbook with one sheet, and sets one cell to a LocalDateTime...
To use it in a reactive application, you need to do a nasty trick for the output stream and create your own like below (My example is returning the ByteArray...
First of all, I really appreciate the work that went into this! I'm parsing a xlsx with 36 columns or so, and the last few columns represent optional data. As...