3

When I export a SharePoint list to Excel using the built-in functionality, it also exports two columns called Item Type and Path.

Is there a way OOTB or programatically to exclude these columns from the export?

  • sir @charles if you find solution for this, please write as an answer for us – saber tabatabaee yazdi Feb 22 '17 at 7:57
1

If the export is data that users will routinely access in Excel, you can hide the Item Type and Path columns in Excel, and then create a data connection between the workbook and the list. Each time the workbook is opened the list data will be updated in Excel and the columns remain hidden. Click here for step-by-step instructions for creating the data connection. When I use this method, to make access easy for users, I add a link to the workbook on a web page in a site.

-1

You can use the SharePoint List API to do this, start here: msdn article

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.