Thursday, March 26, 2009

Error: Cannot Get the List Schema Column Property from the SharePoint List

Ok, so you are looking at a SharePoint list and decide you'd like to export the data. So you go to Actions > Export to Spreadsheet.

The default file will be named owssvr.iqy which is an internet query file. Clicking Open will launch Microsoft Excel. Depending on your security settings you will likely get a security warning about opening query data. Yeah, no problem because you trust the source. So you click Open. Wah waaaah... you get an error: Cannot get the list schema column property from the SharePoint list.

This is most likely because there are columns in the list that are not supported by Excel, such as HTML. Hopefully this will atleast help you figure out why you get the error, but unfortunately I don't know of a work-around for this other than to remove the column.If you have any ideas, please feel free to comment.