Forum Discussion
Issue with appending to a table in Office Scripts
I have automated the updating of a table in Existing Excel file with data from a table in new file. Both files are Excel online files. The process amounts to: 1. Find the date/time of the oldest rec...
Office script has limitations in how many records you can read/write in one go indeed. You'll simply have to experiment I'm afraid.
JKPieterse, yes I will look at making the block size smaller but this behaviour (ie random silent failure) shouldn't be tolerated in a professional product. Ideally I want someone from Microsoft to look into this to see what the underlying issue is.
MarkBOWLER I suspect the issue is that Microsoft never intended this kind of use for Office Script; it is intended to be a user-automation tool, not a tool to build larger business solutions with. Whatever that may be. However, I totally agree such a silent failure is unacceptable.
