Is there a file size limit on the Microsoft 365 - Excel::Write Collection action?

[JeremyRTDean]

I am able to use this function fine with a small test file.  But my production file is 3,600 lines and it fails.

[SayeedBinAbdullah]

Hi @JeremyRTDean 

Yes, there are limitations when using the Microsoft 365 - Excel::Write Collection action in Blue Prism, especially when handling large datasets. While there isn't an explicitly documented file size limit, users have reported issues when working with larger collections.

• Blue Prism's ability to handle large datasets depends on memory and processing power.
• If your collection contains special characters (e.g., double quotes), it may sometimes cause errors
• Excel Online has a 250 MB total file size limit, If your production file exceeds this, it may cause failures.
  
  https://support.microsoft.com/en-gb/office/data-model-specification-and-limits-19aa79f8-e6e8-45a8-9be2-b58778fd68ef 
  
  
• Large datasets with complex formulas, conditional formatting, or external connections can slow down processing.
• Some users suggest using OLEDB instead of direct Excel actions for handling large datasets.
  https://community.blueprism.com/t5/Product-Forum/Collection-Maximum-Size/td-p/82883 

Best Regards,
Sayeed Bin Abdullah

[Neel1]

hello @JeremyRTDean  - i managed to perform this. although my collection was cooked up. having value in between rows.

How many column you are having

Rows - 5005, Column - 3

[JeremyRTDean]

The collection is 3,803 rows and 31 Columns as it stands.

As a workaround I created a workbook using the Excel VBO, Write Collection (Fast) and then upload that to SharePoint.  This only takes seconds but annoying that I can't use Graph 100%.