Excel Add in的办公室设置限制是什么 [英] What is the office setting limitation for Excel Add in
问题描述
我正在使用此OfficeJs API来保存与excel add in应用程序相关联的元数据，我想知道设置可以在Excel中添加多少大数据，我们注意到当设置达到几MB时，它并没有得到保存.Office.context.document.settings.set('mySetting'，'mySetting value');
I am using this OfficeJs API to save metadata associated with excel add in app, and I am wondering how big data the setting can support in Excel add in, we notice when the setting get to a few MB, it doesn't get saved. Office.context.document.settings.set('mySetting', 'mySetting value');
推荐答案
Excel JS的每个加载项设置都有2 MB的限制，但是由于客户的要求，此限制自Office 2016起已被删除.因此，目前，设置应该没有限制，但是，如果您使用的是Excel Online，则在以下方面会有一些大小限制:
Excel JS ever had a 2 MB limitation for the settings for each add-in, but this limitation was removed since office 2016 due to customer requests. therefore, right now, there should not have a limit for the settings, however, if you are working on Excel Online, there would be some size limitation on:
-
有效负载大小限制网络上的Excel对请求和响应的有效负载大小限制为5MB.RichAPI.如果超出该限制，将引发错误.因此当保存设置超过5MB时，您可能无法成功.
Payload size limits Excel on the web has a payload size limit for requests and responses of 5MB. RichAPI.The error will be thrown if that limit is exceeded. so you may not be able to success when saving setting more than 5MB.
File size limits for workbooks in SharePoint: Microsoft SharePoint has some file size limits for workbooks. When you upload an Excel for the web workbook to a SharePoint document library that's too large, it will either not open in a browser window, or let you edit or refresh data in the browser. To keep from consuming too much disk or memory space, Microsoft 365 SharePoint puts some file size limits on the files or workbooks you can upload and work with online.
您是否看到错误消息?如果是，请与我们分享一下吗?您能否与我们分享示例代码，我们想对其进行研究.谢谢.
Do you observe the error message? if yes, could you please share it with us? could you please share us the sample code, we would like to look into it. thanks.
这篇关于Excel Add in的办公室设置限制是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
