fastexcel
StreamEx
fastexcel | StreamEx | |
---|---|---|
5 | 2 | |
605 | 2,149 | |
1.7% | - | |
8.8 | 6.4 | |
4 days ago | 23 days ago | |
Java | Java | |
Apache 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
fastexcel
-
FileOutputStream v. ByteArrayOutputStream: is there a noticeable difference in memory usage?
I'm using fastexcel to create the excel file, and I'm flushing it to the OutputStream after every row is written. Right now, I am using a FileOutputStream to write to disk. When the excel file is done being generated, I read it back in using InputStreamResource and stream the response. My thought process is that a ByteArrayOutputStream keeps everything in memory even if I'm flushing the excel file after every row, so I used the FileOutputStream. Does my logic track here? Or am I unnecessarily slowing things down with expensive filesystem IO?
-
Favorite hidden gem library?
fastexcel the fastest xlsx generation library
-
how to create an excel file from a form in an android app
I would use some library like for example this one. So you collect all the data you want to store in a list or map, and iterate over it, then add them to the excel like shown in the documentation of the library (should always be the same way more or less for any library)
-
Any good alternatives to Apache POI for creating Excel spreadsheets?
I've only had memory problems with apache poi. I only use https://github.com/dhatim/fastexcel now
StreamEx
-
Favorite hidden gem library?
I really like StreamEx. I do not know why people do not use it often, the syntax is just wonderful.
-
Jodd – The Unbearable Lightness of Java
It gets more perverse if you need to flatMap, or transmute components of map types, etc. If you want even more power, take a look at https://github.com/amaembo/streamex. This sort of container manipulation bread and butter for business processing. I use it every day, sometimes with a dozen operations. This (with liberal use of `final` values) makes for some pretty functional-looking code.
I'll grant you the Kotlin or Scala version is slightly more compact. But not fundamentally different, like the Go version.
I (and the pretty much every language designer in the post-Java era) disagree with you about checked exceptions, but that's a whole different thread...
What are some alternatives?
Apache POI - Mirror of Apache POI
jOOλ - jOOλ - The Missing Parts in Java 8 jOOλ improves the JDK libraries in areas where the Expert Group's focus was elsewhere. It adds tuple support, function support, and a lot of additional functionality around sequential Streams. The JDK 8's main efforts (default methods, lambdas, and the Stream API) were focused around maintaining backwards compatibility and implementing a functional API for parallelism.
easyexcel - 快速、简洁、解决大文件内存溢出的java处理Excel工具
Javaslang - vʌvr (formerly called Javaslang) is a non-commercial, non-profit object-functional library that runs with Java 8+. It aims to reduce the lines of code and increase code quality.
Aspose.Cells-for-Java - Aspose.Cells for Java examples, plugins and showcases
derive4j - Java 8 annotation processor and framework for deriving algebraic data types constructors, pattern-matching, folds, optics and typeclasses.
spreadsheet - Spreadsheet Builder
protonpack - Stream utilities for Java 8
zerocell - Simple, efficient Excel to POJO library for Java
underscore-java - java port of Underscore.js
docx4j - JAXB-based Java library for Word docx, Powerpoint pptx, and Excel xlsx files
Functional Java - Backport of Java 8's lambda expressions to Java 7, 6 and 5