locked
Import List from Spreadsheet - Method 'Post' of object 'IOWSPostData' failed error RRS feed

  • Question

  • I'm trying to import a spreadsheet into SharePoint to create a list and I get an error - Method 'Post' of object 'IOWSPostData' failed

    I've tried changing the range etc to trouble shoot the problem but so far no luck - gotta love this great product!

    Wednesday, December 8, 2010 7:13 PM

Answers

  • check this one, http://www.tek-tips.com/viewthread.cfm?qid=1330234

    or 

    http://farhanfaiz.wordpress.com/2009/05/05/import-spreadsheet-error-method-post-of-object-iowspostdata-failed/

     

    you need to make some changes in the EXPTOOWS.XLA.

     

    hope this help

    thanks

    -ws


    SharePoint administrator, MCTS,MCITP
    • Marked as answer by Emir Liu Thursday, December 16, 2010 3:02 AM
    Wednesday, December 8, 2010 8:23 PM
  • Excel queries SharePoint to determine the version. What’s most likely happening is that Sharepoint queries the root site such as http://sharepoint, which might not contain a SharePoint site or, more likely, your user does not have the rights to query this hidden SharePoint service.  There are many other reasons why this might fail but the long and short of it is that you need to change excel’s call to check SharePoint’s version.

    If you get this error while building a new list in MOSS or WSS from Excel 2007 or 2003 spreadsheet, then reason could be due to Excel add-in's. Importing a list from Excel returns a method "POST" of object "IOWSPostData" failed dialog. Its not a problem with either MOSS or WSS 3.0 but rather the result of a failed Application.SharePointVersion() called in Excel Add-In which Excel attempting to use IOWSPostData.Post() method to publish Excel range, which was used with the SharePoint Team Services 1.0. Hence by setting STS versions to 2 or above forces Excel to use SOAP as a medium of communication with WSS 3.0.

    Therefore publish request will be successful. Files used for performing these request located at the fallowing folder C:\Program Files\Microsoft Office\Office12\1033\EXPTOOWS.xla

    Solution:

    • Open file "EXPTOOWS.XLA
    • Goto Visual Basic Code Editor Mode by pressing (Alt + F11)
    • Search for the function -> Initialize(List, Title, URL, QuickLaunch)
    • Comment out the line with single quote -> 'lVer = Application.SharePointVersion(URL)
    • Add the new line as -> lVer = 3 or IVer = 2 ' IVer = 2 or 3 Sets this macro to always use soap-method of saving data to sharepoint

    New updated function should look something like this:

    Sub Initialize(List, Title, URL, QuickLaunch)
     strQuickLaunch = QuickLaunch
     aTarget(iPublishURL) = URL
     aTarget(iPublishListName) = List
     aTarget(iPublishListDesc) = Title
     lVer = -1 ' can't tell STS server version
     If Val(Application.Version) >= 12 Then
      'lVer = Application.SharePointVersion(URL)
       lVer = 3 
     End If
    End Sub
    


    Thanks! Raj
    • Marked as answer by Emir Liu Thursday, December 16, 2010 3:02 AM
    Wednesday, December 8, 2010 8:47 PM

All replies

  • check this one, http://www.tek-tips.com/viewthread.cfm?qid=1330234

    or 

    http://farhanfaiz.wordpress.com/2009/05/05/import-spreadsheet-error-method-post-of-object-iowspostdata-failed/

     

    you need to make some changes in the EXPTOOWS.XLA.

     

    hope this help

    thanks

    -ws


    SharePoint administrator, MCTS,MCITP
    • Marked as answer by Emir Liu Thursday, December 16, 2010 3:02 AM
    Wednesday, December 8, 2010 8:23 PM
  • Excel queries SharePoint to determine the version. What’s most likely happening is that Sharepoint queries the root site such as http://sharepoint, which might not contain a SharePoint site or, more likely, your user does not have the rights to query this hidden SharePoint service.  There are many other reasons why this might fail but the long and short of it is that you need to change excel’s call to check SharePoint’s version.

    If you get this error while building a new list in MOSS or WSS from Excel 2007 or 2003 spreadsheet, then reason could be due to Excel add-in's. Importing a list from Excel returns a method "POST" of object "IOWSPostData" failed dialog. Its not a problem with either MOSS or WSS 3.0 but rather the result of a failed Application.SharePointVersion() called in Excel Add-In which Excel attempting to use IOWSPostData.Post() method to publish Excel range, which was used with the SharePoint Team Services 1.0. Hence by setting STS versions to 2 or above forces Excel to use SOAP as a medium of communication with WSS 3.0.

    Therefore publish request will be successful. Files used for performing these request located at the fallowing folder C:\Program Files\Microsoft Office\Office12\1033\EXPTOOWS.xla

    Solution:

    • Open file "EXPTOOWS.XLA
    • Goto Visual Basic Code Editor Mode by pressing (Alt + F11)
    • Search for the function -> Initialize(List, Title, URL, QuickLaunch)
    • Comment out the line with single quote -> 'lVer = Application.SharePointVersion(URL)
    • Add the new line as -> lVer = 3 or IVer = 2 ' IVer = 2 or 3 Sets this macro to always use soap-method of saving data to sharepoint

    New updated function should look something like this:

    Sub Initialize(List, Title, URL, QuickLaunch)
     strQuickLaunch = QuickLaunch
     aTarget(iPublishURL) = URL
     aTarget(iPublishListName) = List
     aTarget(iPublishListDesc) = Title
     lVer = -1 ' can't tell STS server version
     If Val(Application.Version) >= 12 Then
      'lVer = Application.SharePointVersion(URL)
       lVer = 3 
     End If
    End Sub
    


    Thanks! Raj
    • Marked as answer by Emir Liu Thursday, December 16, 2010 3:02 AM
    Wednesday, December 8, 2010 8:47 PM
  • Hi

    Have a look at this article.

    Import Excel Sheet to SharePoint List

    Hope this helps you!


    Cheers! Maruthu | http://sharepoint-works.blogspot.com


    Thursday, May 10, 2012 6:20 AM
  • Hey. I am using SPS 2013 foundation and MS Office 2013 and also get this error.

    There is no such file, cause it for Office 2010 only - C:\Program Files\Microsoft Office\Office12\1033\ EXPTOOWS.XLA

    Any sugggestions how I can fix this?

    Tuesday, September 27, 2016 2:56 PM
  • Well, the same tbh, but differnt path for Office 2013:

    C:\Program Files (x86)\Microsoft Office\Office15\1033
    C:\Program Files (x86)\Microsoft Office\Office15\1049

    I searched code in wrong place - you need to open form and than form's code. Best instruction I've ever seen on this topic - http://sharepoint-works.blogspot.ru/2012/05/import-excel-sheet-to-sharepoint-list.html.

    Wednesday, September 28, 2016 6:17 AM