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
645 Views Asked by somey At
1
There are 1 best solutions below
Related Questions in JAVA
- Add image to JCheckBoxMenuItem
- How to access invisible Unordered List element with Selenium WebDriver using Java
- Inheritance in Java, apparent type vs actual type
- Java catch the ball Game
- Access objects variable & method by name
- GridBagLayout is displaying JTextField and JTextArea as short, vertical lines
- Perform a task each interval
- Compound classes stored in an array are not accessible in selenium java
- How to avoid concurrent access to a resource?
- Why does processing goes slower on implementing try catch block in java?
- Redirect inside java interceptor
- Push toolbar content below statusbar
- Animation in Java on top of JPanel
- JPA - How to query with a LIKE operator in combination with an AttributeConverter
- Java Assign a Value to an array cell
Related Questions in APACHE-POI
- matching the values from an array containing values
- How do I use DataProvider with Apache POI
- Unable to read excel if cell/column has drop down list enabled for Selenium webdriver TestNG
- Reading from a word document using java
- Java excel: Get next non-nullable cell in the same row
- Not able to print the values of cell with in a range through poi
- getting incorrect value from excel using apache poi
- Setting Comments in Excel (with apache poi)
- How to avoid out of memory exception in case of reading large .xlsx file in java using apache poi library class XSSFWorkbook
- Illegal exception zip file is closed in apache poi for docx file creating after build as jar
- lost Shape layout when set text
- Reading an excel and calculate total using Java/Apache POI
- Get the list of object containing text matching a pattern
- Reading from excel file with blank cells to 2d array
- Apache POI serialization issue in spring batch
Related Questions in XLS
- PHPExcel date formatting in strange numbers
- Using Python how to get number of occurance of a string in 'n' number of columns from a .csv file
- Why does my Excel gets corrupted every time I insert more than 21 users by typing XML or through C#?
- Best way to deal in reading very old xls files
- Grep in R (zero or any character)
- Getting list from row R
- JSON to xls in javascript
- Extract images from .xlsx/.xlsm in order
- xls form for conducting survey using android phone
- Generate array from CSV file selected by input type file
- Using Java and Apache POI customizing image size within excel cell
- How do I get XLS data to appear in CSV form the same way it displays in the file?
- OSError: No suitable library found for xls
- How do I get 'ssconvert' to embed off-sheet references?
- Concatenating multiple .xls files with unknown number of columns
Related Questions in CHUNKS
- Slicing arrays based on relations in the data (in Ruby)
- How to split an array into pairs of different elements in PHP randomly?
- Pandas to_csv index=False not working when writing incremental chunks
- Previous/Next buttons for PHP array chunks
- Determine the number of chunks in the selection from an hdf5 file
- Vue.js 2.0 Lazy Loading
- How define a spring batch chunk in the tasklet with code
- How to split a A*A std::array into chunks of B*B?
- Need to read a text file of size greater than 5 GB in chunks to reduce processing time using C++
- nodejs' request module doesn't give response in chunks
- How can I keep track of record number across multiple json objects in PHP
- File upload in chunks using Angular 4
- How to parse xls file containing multiple sheets, within 50MB of memory, in Java
- Divide array in chunks with different sizes
- How to call a program within a bash chunk in R markdown file?
Related Questions in MEMORY-EFFICIENT
- Efficiently finding the count of column values for distinct rows in a dataframe in r
- Faster alternative to populating a pre-allocated data frame using a for-loop
- Time running program varying wildly on each try?
- Inefiecient code on loops. 10000000 loop challenge.
- window click event vs a lot of buttons click event
- Instantiating C++ objects from QML has tremendous memory usage overhead
- Fast row removal and addition in pandas.DataFrame without reallocation
- What's the difference in memory between creating an object inside and outside of a loop
- Does Slicing `a` (e.g. `a[1:] == a[:-1]`) create copies of the `a`?
- How to parse xls file containing multiple sheets, within 50MB of memory, in Java
- How can I parse a csv in low memory, using some parser in Java?
- get all indexes of value nil in array
- Python - dividing a list-of-lists to groups
- Efficient way of computing statistics for large/imprecise amount of data
- create single bytes instance from sequence of memoryview
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)
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?
Apache POI provides a SAX like API to access Excel documents.
See Apache POI Event API: