none
奇怪的问题: wss3.0 导入电子表格失败! RRS feed

  • 问题

  • 系统: windows server 2008 standard / SQL Server 2008 CTP / WSS 3.0 sp1


    问题:进行创建自定义列表的"导入电子表格"操作时,在打开的excell文件中选择的范围(区域类型: 表格区域; 选择区域: Sheet1!Table1)后,  点击"导入"按钮, 出现错误提示: "方法'Post'作用于对象'IOWSPostData'时失败"。查看了logs目录下的日志,似乎没有相关信息。

     

    哪位能告知原因,在此表示感谢。

    2008年6月16日 0:59

答案

  • 本人已解决! 方案来自网上:

    Importing lists from Excel 2007 returns a Method 'Post' of object 'IOWSPostData' failed dialog. Again, not really a problem with WSS 3.0 but rather the 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 Team Services 1.0. By forcing the version lookup result variable to 2 or greater, Excel will use SOAP to communicate with WSS 3.0 and the publish request will be successful. To make this change, open the Excel Add-In EXPTOOWS.XLA locate 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). 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

    2008年6月16日 1:25

全部回复

  • 本人已解决! 方案来自网上:

    Importing lists from Excel 2007 returns a Method 'Post' of object 'IOWSPostData' failed dialog. Again, not really a problem with WSS 3.0 but rather the 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 Team Services 1.0. By forcing the version lookup result variable to 2 or greater, Excel will use SOAP to communicate with WSS 3.0 and the publish request will be successful. To make this change, open the Excel Add-In EXPTOOWS.XLA locate 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). 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

    2008年6月16日 1:25
  • 没有看明白具体解决的方法,我知道我的是需要打上office2007的SP1才OK

     

    2008年6月16日 11:44
    版主