I have used POI and Jexcel. POI uses as much memory as the file size and Jexcel take a lot of memory while loading a workbook. My requirement is to process an xls file in chunks, so as to reduce the memory consumption.
How to parse xls file containing multiple sheets, within 50MB of memory, in Java
650 views Asked by somey At
1
There are 1 answers
Related Questions in JAVA
- I need the BIRT.war that is compatible with Java 17 and Tomcat 10
- Creating global Class holder
- No method found for class java.lang.String in Kafka
- Issue edit a jtable with a pictures
- getting error when trying to launch kotlin jar file that use supabase "java.lang.NoClassDefFoundError"
- Does the && (logical AND) operator have a higher precedence than || (logical OR) operator in Java?
- Mixed color rendering in a JTable
- HTTPS configuration in Spring Boot, server returning timeout
- How to use Layout to create textfields which dont increase in size?
- Function for making the code wait in javafx
- How to create beans of the same class for multiple template parameters in Spring
- How could you print a specific String from an array with the values of an array from a double array on the same line, using iteration to print all?
- org.telegram.telegrambots.meta.exceptions.TelegramApiException: Bot token and username can't be empty
- Accessing Secret Variables in Classic Pipelines through Java app in Azure DevOps
- Postgres && statement Error in Mybatis Mapper?
Related Questions in APACHE-POI
- Problem with sample code to set font properties for a whole XWPF Paragraph that includes Word fields
- Create filter on Integer column (with default values selected) while creating pivot table using apache poi
- Apache POI has some vulnerability with POI OOXML jar file
- The total number of document pages in the footer is not calculated correctly
- OutOfMemoryError: Java heap space. Read/Process Large Excel File(150MB) With Limited Memory (-Xmx130m) using Sax Parser
- Convert .docx to pdf using XDocReport
- Package[package ognl] of target class[class ognl.MethodFailedException] of target [ognl.MethodFailedException[java.lang.NoSuchFieldError:Factory]]
- word poi5.1.0 How to make chart add a series
- Is it possible to change Pivot Chart's (Pie chart) data color created using Pivot Table reference using Apache POI?
- Excel runs Apache-POI generated XLSX file but complains about working formula
- How to read Raw value rather then the formatted value from the excel sheet using POI library using XSSFReader class
- Apache POI Word insert both table and text at the same level
- Apache POI: get zoom level by using reflection
- APACHE POI: adding comment to existing word document
- Problem read formula excel file with apache poi
Related Questions in XLS
- How can I optimize creating an xlsx file?
- Warning when using c# to generate an excel file with hidden rows
- google apps script: convert an .xls (XHTML) to gsheet spreadsheet
- pandas.read_excel() cannot read an .xls file, what is going wrong?
- How can I connect to xlsx workbook each table from another workbook with Power Query?
- How to extract TimeStamp in correct format from XML in XLS Report
- Is there a way to open a file with a csv extension that has the file format of an XLS file, using python?
- Importing full test plans into Azure DevOps from .xls
- XPath returns nothing when tranfsorming XHTML to HTML with Java Saxon
- Generating excel file of extension .xlsx
- Rust write struct to the xls
- Unable to read an xls (a password protected file) after decrypting it
- Convert numerous files in a folder from csv to xls, while carrying out text to columns
- Laravel - Laravel Excel - maatwebsite Successfully added image to spreadsheets, the image is 'over cell', how to make it 'in cell'?
- How to open a xls file that seems to have something wrong in R
Related Questions in CHUNKS
- Large file processing in the web browser
- Trying to slice a large css file Trying to slice a large css file (1,952,726 rows) to chances using Python
- ChunkLoadError: Loading chunk X failed
- Chunks not loading when script tag is added dynamically using JS instead of adding it to HTML directly
- Calculate HTTP Range Header for download a file in chunks in JavaScript
- Why my R studio insert chunk short cut not working
- Chunks not working in my project, some chunks don`t activating in time
- Google Resumable Upload
- Getting Error to download specific parts of a video file stored in GridFS as chunks
- CPanel Issue: NextJS Static Export Doesnt Load, missing JS Chunks, CSS & SVG
- iOS Safari loads outdated javascript
- How to download and play a specific part of a large video file using requests python
- How to use 2 or more threads for count a words in a file
- Is it possible to download file chunk by chunk without loading into the browser memory
- Video chunks merging issues in laravel 5.8
Related Questions in MEMORY-EFFICIENT
- R: Efficient Way to partly modify diagonal of matrix
- The Reason Behind Employing an Additional Array and Counting Smaller Elements in the Counting Sort Algorithm
- Efficient way to iterate through df rows
- How to correctly reuse data in registers to compute faster the Pearson Correlation between vectors in a matrix
- Search in txt file with more than 3 million lines in C#
- How to generate all length n combinations of k elements (with replacement) that contain each element at least once?
- Given two arrays A and B, how to efficiently combine them so that the output is an array in which each element is a tuple (Aij,Bij)?)
- Fast and efficient substring extraction and comparison in R
- How to be more code efficient on fortran? I solved an exercise and I'm not satisfied with my own answer
- Efficiently enumerating multinomials with constant sum - R
- What's most efficient way of reading larger files in python?
- Running out of memory modifying a long string
- How to shuffle a function consistently from a seed number
- Improving CLOS memory-efficiency in Common Lisp?
- Compact way to save a list of subsets
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Apache POI provides a SAX like API to access Excel documents.
See Apache POI Event API: