You’re offline. This is a read only version of the page.
Announcements
4
I am trying to auto populate a column in a sharepoint document library based on the file of that row.
Each excel document is the same with different data, for example each document has a column with quantity and one row with a number eg 2 I would like the column in the library also, named quantity, to return the value 2 by reading the document
Is this possible? Any help would be greatly appreciated
You can do this, but the data in each Excel file must be formatted as a table.
Then you can retrieve the row(s) you need from the Excel.
Here an example. It gets an array with a list of file names for the excel files. And than it gets the row from each file where column quantity is equal to 1 within table "Table1".
So the key is standardization within filenames, tables names and formatting of the Excel files.
Regards,
Leo
-------------------------------------
If my answer solved your issue, please mark it as a solution.
If what I wrote helped you, please give it a thumbs up.
Share
Report
All responses (
Answers (
