从Excel下载Webi报告 [英] Download Webi report from Excel
问题描述
有了新发布的Webi，就无法像在DESKI时代那样使用VBA来处理报告。
With newly released Webi there's no way to manipulate reports with VBA like it was in DESKI era.
我想知道我是否有办法单击Excel工作表中带有参数的按钮并从服务器获取报告？
I'd like to know if there's a way for me to click a button with parameters in Excel sheet and get a report from the server?
我一直在考虑使用RESTful Web服务，但似乎有一个性能问题。
I've been thinking of using the RESTful Web-services but it seems that there is a performance problem.
我还考虑过在中间使用SDK的方式使用JAVA应用程序，但是当我添加一层时并不能令人满意。
I also considered using a JAVA app in the middle using the SDK but it's not really satisfying as I add one layer.
您知道是否还有其他方法可以从Excel下载Webi报告吗？
Do you know if there's an other way to download a Webi report from and to Excel?
推荐答案
对于此类要求，通常使用 OpenDocument 功能。但是，有一件事情是不会做的，至少对于Webi文档来说是不会的，那就是以Excel格式提供输出（HTML和PDF是Webi的两种可能的格式）。公平地说，导出到Excel选项仅需单击两到三下，但我可以理解，这不是理想的解决方案。
For this type of requirement, you'd normally use the OpenDocument feature. There is one thing that it won't do however, at least not for Webi documents, and that is deliver the output in Excel format (HTML and PDF are the two possible formats for Webi). In all fairness, the export to Excel option is only about two or three clicks away, but I can understand that this wouldn't be an ideal solution.
另一个选择是 Java SDK ，我不推荐这样做，因为ReBEAN SDK（需要与Webi文档进行交互的Java SDK的一部分）已被淘汰，并由REST SDK代替。
Another option is the Java SDK, which I would not recommend, as the ReBEAN SDK (the part of the Java SDK you need to interface with Webi documents) is deprecated and replaced by the REST SDK.
如果OpenDocument功能不完善， REST SDK 是最好的选择。请记住，这将涉及很多步骤，每次发送命令到WACS服务器，然后解码。步骤如下：
The REST SDK would be the way to go if the OpenDocument feature is not sufficient. Keep in mind that this would involve quite a few steps, each time sending a command to the WACS server and then decoding the answer. The steps would be:
- 验证并获得登录令牌
- 刷新文档（如有必要）传递提示值）
- 将文档导出到Excel
- 关闭文档
- Authenticate and get a logon token
- Refresh the document (if necessary pass prompt values)
- Export the document to Excel
- Close the document
仅WACS服务器支持REST接口，该接口应在BI4服务器上运行（除非您具有自定义的环境）。如果运行缓慢，我建议您调查此性能问题的根本原因，而不是完全丢弃该SDK。
The REST interface is only supported on the WACS server, which should run on your BI4 server (unless you have a customised landscape). If it's slow, I would suggest looking into the root cause of this performance issue, instead of discarding the SDK altogether.
如果您要使用REST接口，我建议选择JSON通过REST而不是XML进行通信。
If you're going to use the REST interface, I would recommend opting for JSON to communicate through REST instead of XML. It's easier to read and parse.
我不建议使用的最后一个选项是 LiveOffice 。这是一个单独的产品，使您可以将Webi文档中的内容嵌入到Office文档（最著名的是Excel）中。 LiveOffice总是遇到很多问题，并且在迫切需要的更新方面没有得到SAP的广泛支持。
A last option, which I wouldn't recommend, is LiveOffice. This is a separate product which allows you to embed contents from Webi documents into Office documents (most notably Excel). LiveOffice has always had its share of problems and has not received much love from SAP regarding much needed updates.
最后一个想法：该报告永远不会出现在同一张纸上，至少并非没有额外的编码量。无论最终选择哪种SDK，都将始终以Excel文件结尾。如果要在开始的Excel文件中显示结果，则需要对步骤进行编码，以打开生成的文件，获取内容，然后将其复制到工作表中。
One final thought: the report will never appear in the same sheet, at least not without an additional amount of coding. Whatever SDK you end up choosing, you will always end up with an Excel file. If you want to show the results in the Excel file you started from, you'll need to code the steps to open the generated file, grab the contents and then copy those to your worksheet.
这篇关于从Excel下载Webi报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
