An activity pack used to read and process extra large excel files.
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.
Compatible with all versions of UiPath Studio
DocumentFormat.OpenXML (> = 2.5.0) Microsoft.Office.Interop.Excel (> = 15.0.4795.1000)
By clicking download you agree to the following license.