Showing posts with label method 'post' of object 'iowspostdata' failed. Show all posts
Showing posts with label method 'post' of object 'iowspostdata' failed. Show all posts

08 June, 2012

Method 'Post' of object 'IOWSPostData' failed SharePoint 2010

Guys, before I start writing on this error message, let me clarify that I have tested this issue in two environments:
·         SharePoint 2010 and Office 2007
·         SharePoint 2010 and Office 2010
Directly Jumping on to the troubleshooting steps, let me brief some details as how I reproduced that error message:
·         Open your SharePoint site
·         View all site content / http://SharePoint2010/sites/SPAdmin/_layouts/create.aspx  
·         Custom list section
·         Import a spreadsheet (refer the following screenshot)
·         Provide appropriate details for the Name field
·         Select an excel spreadsheet that you wants to import by means of Browse option
·         Range of cells
·         As soon as you selects the range of cells and click Ok then you will get the below mentioned error message:
Method 'Post' of object 'IOWSPostData' failed
First condition: SharePoint 2010 and Office 2007
If you are using the above combination then it’s never going to work.
Second condition: SharePoint 2010 and Office 2010
Its working perfectly without any problems, if you are facing the mentioned error message for this combination then here is the resolution for this:
·         Go to “C:\Program Files\Microsoft Office\Office14\1033”.
·         Find “EXPTOOWS.XLA” and double click on it.
·         Press “Alt+F11” to display VB code editor.
·         Select code window and find “lVer = Application.SharePointVersion(URL)”
·         Add following line “lVer = 2”.
·         Save and close the window.
·         Restart and see if it worked.
·         If not, change “lVer = 3”.
·         Restart and see if it worked.
If you have any queries/questions regarding the above mentioned information then please let me know, Thank you.

how to import a spreadsheet into sharepoint list 2010

Just like SharePoint 2007, SharePoint 2010 also provides this functionality in which we can directly import an excel spreadsheet and creates a custom list based on the number of the columns.
How to import? Here is the step by step guide for you:

·         Open your sharepoint site
·         Click on view all site content
·         Create
·         Select the List category from the left
Note: If you do not wants to follow the above mentioned steps then please make some adjustments in your site URL (like the below one)
You will be wondering as what exactly we need to do in the URL, it’s very easy
Just append _layouts/create.aspx after the site name. That’s it
·         Okay, continuing the same point


·         As soon as you click on ‘Import a spreadsheet’ then Provide the list name as per your project requirements
·         Click on Browse and select your excel file that you wants to import
·         Select the range of cells that you want to import
·         Click OK
-That’s it-Job Done J Very Easy Right J-
If you face any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues. Thank you.

30 December, 2009

Method 'Post' of object 'IOWSPostData' failed

The error message --Method 'Post' of object 'IOWSPostData' failed --appears when I import a spreadsheet in the Create -Import Spreadheet menu of MOSS 2007.
Importing lists from Excel 2007 returns a Method 'Post' of object 'IOWSPostData' failed dialog. The problem is not with the sharepoint but result of a failed Application.SharePointVersion() call in the Excel Add-In which results in Excel attempting to use the IOWSPostData.Post() method to publish the Excel range which is used with SharePoint Services.

By forcing the version lookup result variable to 2 or greater, Excel will use SOAP to communicate with SharePoint and the publish request will be successful.

To make this change, Please follow these steps:

1. open the Excel Add-In EXPTOOWS.XLA locate in

C:\Program Files\Microsoft Office\Office12\1033.

2. Press Alt+F11 to display the Visual Basic code editor and search (Ctrl+F) for the line lVer = Application.SharePointVersion(URL).

3. Comment out that line with a single quote and add the line lVer=2 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 = 2
End Sub

If you have any doubts or queries regarding the above procedure then please let me know...
I hope the above information will helps you to resolve your issue..Thanks !!


Reff:http://social.technet.microsoft.com/forums/en-US/sharepointgeneral/thread/75b2be6b-44df-4389-bf34-c7a01c12372c/