Excel Automation work

Get Help & Discuss Process Studio
1

How does the Excel automation work — COM-based or independent? Can it handle large files?

2

In AutomationEdge Process Studio, Excel automation using the built-in Excel Input/Writer plugins is generally independent of Microsoft Excel desktop and does not require Excel to be installed. These plugins use file-processing libraries rather than desktop COM automation.

Can it handle large files?

Yes. AutomationEdge provides different options for processing large Excel files, depending on the file format and operation:

  • Read large .xlsx files: Use EXCEL Streamer or Apache POI Streaming to help reduce memory consumption.

  • Read large .xlsb files: Use Excel Binary (XLSB) with Enable Batching to process data in chunks.

  • Write large .xlsx files: Use Microsoft Excel Writer with Stream XLSX data enabled to reduce memory consumption.