ADO.NET Provider for Microsoft SharePoint Excel

Build 22.0.8462

Troubleshooting

Troubleshooting

413 Request Entity Too Large

This error occurs when a workbook has too much data per row. Generally, solution to this error will be to make the Excel table smaller or to make the rows less dense.

However, setting the following connection properties will enable you to work around this limitation. Note: This workaround is only supported when using the REST API.

  • DefineTables: Set this to the desired cell range in your sheet.
  • Other: Set this to PageSize=X to determine the number of records that will be paged through at once. Each page should contain less than 100kb. Note that smaller page sizes also entail slower perfomance.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462