Failed to import spreadsheet - Solved

Alright, today I wanted to import an excel spreadsheet with 610 rows and 1 column into MOSS. So I choose Create > Import Spreadsheet, typed a name and browsed for the excelsheet.
After opening the spreadsheet and changing the inputbox “Import to Windows SharePoint Services List” to Range of Cells and choosing Import the error “method ‘post’ of object ‘IOWSPostData’ failed” would appear.

It didn’t make sense to me. I use Vista x64 (Ultimate - fully patched), Office 2007 with SP1 and the MOSS server is patched until Infrastructure Update. No problems there I thought. So I googled for it and found the following solution:

Open the Excel Add-In EXPTOOWS.XLA located in C:\Program Files\Microsoft Office\Office12\1033 by default.
Press Alt+F11 to display the Visual Basic code editor and search (Ctrl+F) for the line lVer = Application.SharePointVersion(URL).
Add the line lVer=3 so your Intialize() method should now look like this:

Sub Initialize(List, Title, URL, QuickLaunch)
  strQuickLaunch = QuickLaunch
  aTarget(iPublishURL) = URL
  aTarget(iPublishListName) = List
  aTarget(iPublishListDesc) = Title
  lVer = Application.SharePointVersion(URL)
  lVer = 3
End Sub

Now I wanted to save it as EXPTOOWS.XLA. That was not possible and the program saved it as EXPTOOWS.XLS.
So I browsed to C:\Program Files\Microsoft Office\Office12\1033, renamed the .XLA file and renamed the .XLS to .XLA.

Now it all works like a charm!

Tags: error