Sharepoint to fill in columns from saved excel files

Question

2.90K viewsMarch 22, 2016Search, Taxonomy & Metadata

0

Petri Puoli-Honka0 March 22, 2016 0 Comments

Hi,

Is it possible to get Sharepoint to fill in metadata from an excel-file when it is saved in Sharepoint?

We save a lot of excel files with the same format to a document library. We would like to have Sharepoint fill in the sum from one cell in the excel file to a column in the document library.

(Visited 129 times, 1 visits today)

Add a Comment

6 Answers

1 2 Next »

score 0 · Answer 1 · 2016-03-24T10:42:00+00:00

Hello,

as far as I know this is no standard function in SharePoint.

But you could easily use a third party tool. For example with www.dox42.com you can solve this issue within minutes. Moreover you gain more control over your documents.

Hope that helps!

(Visited 1 times, 1 visits today)

score 0 · Answer 2 · 2016-03-23T11:15:00+00:00

Hi Petri,

One way you can do it by JavaScript:

Using JavaScript you can get that cell value of excel and use REST or SPSERVICES using JavaScript you can save that value to your required field of your document library.

(Visited 1 times, 1 visits today)

score 0 · Answer 3 · 2016-03-23T07:27:00+00:00

0

Petri Puoli-Honka0 Posted March 23, 2016 0 Comments

Hi,

I can find this fuctionality in word and I can also get it working. I’m however unable to find this functionality in excel. Can you help me find this in excel?

(Visited 1 times, 1 visits today)

Add a Comment