# Excel Processing Speed

**URL:** <https://community.automationedge.com/t/excel-processing-speed/3620>\
**Category:** Get Help & Discuss\
**Tags:** rpa, generic\
**Created:** [June 11, 2021, 3:59am UTC](https://community.automationedge.com/t/excel-processing-speed/3620 "2021-06-11T03:59:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Imran\_Bhole](https://avatars.discourse-cdn.com/v4/letter/i/b9e5f3/32.png) [@Imran\_Bhole](https://community.automationedge.com/u/Imran_Bhole)\
**Post date:** [June 11, 2021, 3:59am UTC](https://community.automationedge.com/t/excel-processing-speed/3620/1 "2021-06-11T03:59:22Z")

</div>

Hi!  
I have built automated processing of large Excel files. The processing is excellent compared to what I have experienced so far, but I wanted to check if there are more options for finetuning to maximise the performance.

---

<div class="post-metadata">

**Author:** ![Jose\_Gonzalez](https://avatars.discourse-cdn.com/v4/letter/j/6de8d8/32.png) [@Jose\_Gonzalez](https://community.automationedge.com/u/Jose_Gonzalez)\
**Post date:** [June 11, 2021, 6:46am UTC](https://community.automationedge.com/t/excel-processing-speed/3620/2 "2021-06-11T06:46:54Z")

</div>

Hi!  
I am happy to see that you like the AutomationEdge Excel Automation which is 10X faster than others solutions in the industry.  
For fine-tuning, have you tried using the following drivers in the Spreadsheet type engines drop-down list.

- EXCEL Streamer - is also for reading large XLSX files. It is memory efficient and works across machine configurations.
- EXCEL Binary XLSB - It is provided to read Excel binary files. The Excel workbook sheets can be read and written a bit faster, making them useful for the larger spreadsheets.

---

<div class="post-metadata">

**Author:** ![francoiss](https://avatars.discourse-cdn.com/v4/letter/f/53a042/32.png) [@francoiss](https://community.automationedge.com/u/francoiss)\
**Post date:** [June 18, 2021, 6:11am UTC](https://community.automationedge.com/t/excel-processing-speed/3620/3 "2021-06-18T06:11:41Z")

</div>

Hi Imran

Recommend to do some performance analysis on your Java VMs memory utilization when the job run.

Here is the Pentaho guide which might help [Change the Java VM Memory Limits - Pentaho Documentation](https://help.pentaho.com/Documentation/8.0/Setup/Administration/Performance_Tuning/090).

Regards  
Francois