When you try to export the contents of a list to an excel, things would seem to start working, but then Excel would pop up an error: “Cannot get the list schema column property from the SharePoint list”.
Searching over the internet I got to know its due to the presence of DateTime field in SharePoint which when exported to excel raises a mismatch in data type. To solve this issue I found 2 ways
- Remove the DateTime field from the view you want to export to excel. if you really t want those date columns, then you have to try step 2.
- Convert the date field to a single line of text. Then, convert it back to a date. It was nice to see that the conversion worked, actually. It was quite nervous that converting things this way would fail, but it did not.
Another way I found is creating a new page, placing a Data View webpart (A fine article on creating Data View Web Part) in at with the data source as your list. This will display all the items in your list. Now open this page in the browser, right click & select Export to excel.