topic Re: Is there a file size limit on the Microsoft 365 - Excel::Write Collection action? in Product Forum

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

JeremyRTDean — Tue, 06 May 2025 08:16:09 GMT

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

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

SayeedBinAbdullah — Tue, 06 May 2025 12:39:26 GMT

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

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

Neel1 — Tue, 06 May 2025 14:10:44 GMT

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

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

JeremyRTDean — Wed, 07 May 2025 04:02:06 GMT

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%.

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

naveed_raza — Mon, 01 Dec 2025 10:55:53 GMT

Graph API uses 4MB per request, probably due to payload exceeds limit its failing,

suggestion: try loading data in chunks like 500 rows per call request