Please increase the size of the related variables and field "Cell Value as Text" from 250 to 2048.

The 250 character limit is inherited from the old NAV, but it can be easily extended to 2048 in business central.

In my scenario, these are the functions from the standard Excel Buffer temporary table and the ReadSheetContinous will only read 250 characters maximum from Excel cells, loosing the rest of the information.

Since Microsoft included another field called "Cell Value as Blob" that can hold longer values, we can used that instead of increasing field size, however there may still be other scenarios that may find it easier to just use "Cell Value as Text", such as data migrations from NAV to BC Cloud.

https://learn.microsoft.com/en-us/business-applications-release-notes/april19/dynamics365-business-central/max-length-of-variable-length-table-fields-has-been-expanded

Thank you,

Robert Bulugea