Importing a Spreadsheet
We like to think that the transition from list to spreadsheet is almost seamless. And I've delivered some great solutions that allow users to manipulate spreadsheets on their local hard-drive and then upload the data to a suitable list on the portal.
However, this time, I'm trying to get the spreadsheet import to work.
So I have this spreadsheet with field validation, hidden columns and conditional formatting and I try to point my import browse button to it and I get an error box that says:
Import to Windows SharePoint Services list
Object doesn't support this property or method
When I click OK, I get the spreadsheet and the Import to Windows SharePoint Services list dialog box where I can select a Range of Cells, a Table Range, or a Named Range.
When I select a range of cells, drag my mouse across the desired cells and click Import, after I get prompted for a login, I get this error:
Import to Windows SharePoint Services list
Method 'Post' of object 'IOWSPostData' failed
Turns out this was all my fault because I've installed the SharePoint Designer which is an Office 12 product.
This action created an Office12 Folder under C:program filesmicrosoft office.
The problem is the EXPTOOWS.XLA file and it's accompanying EXPTOOWS.DLL file that live in the Office 121033 folder. So I renamed these two files by adding a .12 extension to them and I copied the same files out of my
C:program filesmicrosoft officeOffice 111033 folder
and pasted them into my Office 121033 folder
No more problem importing spreadsheets.
hth
-robot
Tags: