英文:
Java Webpage - open editable excel and save it
问题
我们有一个现有的用例，外部用户从我们基于Java的网页下载Excel工作表，然后在他/她的计算机上离线编辑，然后再上传回我们的网页进行处理。电子表格使用内置函数和条件格式。我们大约有1.2万用户。
随着微软推出更新版本和API，我注意到一些网站（如box.com）可以在浏览器中直接打开可编辑的Excel文件，让用户进行编辑，并在该页面上直接保存。
我尝试在微软文档和谷歌上查找，但除了个人OneDrive文件可以在浏览器中打开外，找不到其他任何指示。我找到了MS Graph，但也没有帮助。
请问是否有人可以指导我，或者指点一些相关文档，以实现这一功能。我们公司的员工和内部使用都在使用活跃的Office 365商业账户。
谢谢！
英文:
We have an existing usecase where external user downloads an excel worksheet from our java based webpage -> edits offline on his/her machine -> uploads back on our webpage to process it. Spreadsheet uses built in functions and conditional formatting. We have around 12K users.
With newer versions and apis from microsoft, i have seen websites (like box.com) opening editable excel right in browser -> lets user make edits -> save it right there.
I tried to find on microsoft docs and google but couldn't find any pointers except personal one-drive file that can be opened on browser. Found MS graph but that didn't help either.
Can someone please guide me or point to some documentation to achieve this. My company has active office 365 business account for employees and internal use.
thanks you!
答案1
得分: 0
基于更多的研究（参考谷歌）以及分析 box.com 网站的网络调用，发现 Microsoft 有一个名为 WOPI 的 API 可以实现这一功能。
详细信息请参阅：https://wopi.readthedocs.io/en/latest/
你需要注册自己作为云服务提供商。更多信息请查看：https://learn.microsoft.com/en-us/office/client-developer/integration/integrate-with-office
因此，你拥有并保存你的文件，但可以将 Microsoft 应用作为纯软件服务来使用。
英文:
Based on more research (read google) and analyzing netwrork calls for box.com website, found that Microsoft has an api called WOPI to do this
https://wopi.readthedocs.io/en/latest/
You will need to register yourself as cloud provider. More at
https://learn.microsoft.com/en-us/office/client-developer/integration/integrate-with-office
So you own and keep your files with you but use MS apps as pure software as service.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论