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)

http://SharePoint2010site/sites/SPAdmin/_layouts/create.aspx

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.

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/