Thomson ONE: Excel add-on
Download the Thomson ONE Excel Add-in, if you haven't already done so.
In Excel, use the Item Lookup from the Thomson ONE menu tab.
You will get a menu as follows:
Make your selections for the Company, Period, Value, and Layout And Caption. Then double click on the item you want where the results of the search are displayed. The values and caption will then be inserted into the cells in your spreadsheet.