Tag Info

New answers tagged

0

You can use the SharePoint List API to do this, start here: https://msdn.microsoft.com/EN-US/library/office/dn531433(v=office.15).aspx Alternatively, you can try opening the list in DataSheet view and cut-and-paste the block of rows and columns that you are interested in.


0

Instead of the Macro, you can also use the Left and Find formulas to rid yourself of the meta data for each column containing it. This is annoying if you have several columns, but it also works like a charm without adding macros. Another drawback is that you'll have to add the formula each time. My solution: Say cell A1 has the metadata and it looks like ...


0

The issue is not being addressed. The problem is that only xlsx files being opened from sharepoint 2010 are opening in the browser regardless of the states of the Open Documents in the Client Applications by Default. The problem is that there is a lingering association to xlsx files either in the office install or in windows that is not performing as it ...


0

If you want actual security in place, then you should break the inheritance and provide item level permission. i.e give explicit permission to manager Joe Bloggs to all employee items where Joe Bloggs is the manager. Another option is to create a View which filter "Manager = Current User". And remove all other views. Don't give permissions to managers to ...


0

You can open the list in datasheet view (or create a datasheet view) and just copy & paste your excel sheet rows into the list. Just be careful that the columns are in the same order as in your sheet. If this is not possible, you need to use script or code. The problem here is to use the right format for your fields. Example: (src: ...


0

There is no out of the box way to achieve this. Possible work arounds Export the existing data into excel. Append the new data into the same excel file. Then edit the list in data sheet view, copy and paste the data from excel file Open the list in Access application and then do a copy and paste of missing row. Using programming Powershell VB Script ...


1

AFAIK their is no such OOTB web part which will give you the editable Access database. But if you configure the Access Services 2013 then you can use Access web app http://technet.microsoft.com/en-us/library/ee748634(v=office.15).aspx You can also check this, i dont know if it write back or not: ...


2

SharePoint 2010 supports client object model. So using client object model (JavaScript) get all the data from the list (into any format of your choice). Another option is using the web services (spservices) or REST endpoints to get the data. Then use that to bind to any of the jQuery grid control. Handle the grid events and on those event use client ...


0

The Export to Exel option, export the whole library to Excel. I want to open the SharePoint item which is an Excel document and prompt certain SharePoint columns into the header....


0

InfoPath forms can use URL input parameters - you can add a parameter to the link in the Excel file like "clientid=123" and then add code to your InfoPath form to handle for passed in parameters. Here is a link to the MSDN page on the code needed - LoadingEventArgs.InputParameters property Here is a link to the former InfoPath team blog that has more ...


0

Go to your list > in Ribbon and you will find export to excel option you can simply use it


0

Excel file remained locked. I lifted the locks fix the problem.



Top 50 recent answers are included