Frequently Asked Question

How to copy to Excel the data used in any N4V widget

Last Updated 10 months ago

Simply way to copy/paste to Excel the data used in any N4V Widget (Webi dataset)

The best and easy way to copy/paste to Excel all the data used in any N4V Widget, is the following :

In the Extended Parameter, in the Menu category, Add the Table Data button :
Now in the corner of the Widget, you can see the N4V Menu burger (if more than one feature is available) or just the Data Table View icon
Open the Data Table View and clic on the 3 vertical point behind any label of the header :
In the menu displayed, clic on "Copy data":
As soon as data is copied in the clipboard, a message is displayed during few seconds:
Now you can open an Excel workbook and press Ctrl+V in a new tab:

Data is copied without any formating so you can use your measures directly in Excel.