eTheory on Fri, 23 Sep 2016 04:27:41

I have an excel document that is used to do some extensive calculations based on a property valuation.
I want to save the excel doc in a SharePoint document library and then perform a lookup from another list in SharePoint to obtain some of the figures from within the excel document and save them in that SharePoint list.
Is this possible?



Wendy DZ on Mon, 26 Sep 2016 02:39:18

Hi eTheory,

From your description, you want to get a value from an Excel workbook stored in a SharePoint document library, and store it in another SharePoint list. Is it right?

In SharePoint, there is no OOB way to get values from an Excel workbook stored in a library.

As a workaround, you can download the workbook into your local, then create a Import Spreadsheet list using the downloaded workbook, then get the values from the Import Spreadsheet list.



Kamal Singh Kharayat on Mon, 26 Sep 2016 05:58:13


The following shall help you.