Inserting Webi Report Content Into an Excel Spreadsheet

To insert content from a Webi report into an Excel spreadsheet:

1.    Open Microsoft Excel.

2.    Click the Web Intelligence icon shown below.
08.png

3.    The Live Office Insert Wizard opens as displayed below.
09.png

4.    Select the appropriate document and click Next.
If there are any prompts in the document, it would display as shown below.
10.png

5.    Enter the appropriate value for the prompt and click Next.
Clicking Next displays the result.
11.png

6.    Drag the mouse and select the entire report or any particular section of the report.
Once the selection is made, Next enables.

7.    Click Next.
It prompts you for the object name as shown below.
12.png

8.    Enter the appropriate name and click Finish.
This places the content in the spread sheet.
13.png

Note.pngThe data can be refreshed in the spread sheet any time by right click the document and refresh object as shown above. The exact same task can be accomplished in Word or PowerPoint too.