Connect HomeMarketplaceComponentsRead Extra Large SpreadSheets

Read Extra Large SpreadSheets

Custom Activity

Custom Activity

Updated: October 27th, 2020

Published: September 13th, 2018

Downloads: 385

Language compatibility: Visual Basic

Community Support

Read Extra Large SpreadSheets

Custom Activity

Summary: 

An activity pack used to read and process extra large excel files.


Details

Benefits

This approach works only on xlsx files. Using SAX, the xml content of the file is loaded gradually, this means that the content is retrieved from the file without overloading the RAM memory or needing to have Microsoft Office installed.
XLS files can be processed too, but they need to be converted to xlsx first. 
The package has been successfully tested with files sizes of +200MB and over 1 million rows. There's no reason this solution could not read even bigger files, however, for this it would be needed to read the file in chunks.

Compatibility

Compatible with all versions of UiPath Studio

Dependencies

DocumentFormat.OpenXML (> = 2.5.0)
Microsoft.Office.Interop.Excel (> = 15.0.4795.1000)

Licensing

By clicking download you agree to the following license.