Vishal_96707
Feb 11, 2009Nimbostratus
sharepoint "Export to Excel" not working
We have deployed sharepoint 2007 behind F5 LTM. Sharepoint uses a feature in which export to excel which is not working for us in HTTPS environment. Here is the info which i got export to excel feature.
********
9. Leverage Excel for data management
Exporting data to Excel is well-supported in SharePoint and makes graphing and printing convenient (via the Print with Excel and Chart with Excel options). But it's also possible (and may often be desirable) to export data to Excel just for the sake of manageability. The Excel Export function creates an Excel Web query linking to the original data. In this way, you can create spreadsheets that will accept data, and then push that data to SharePoint.
This can be done by generating an Excel spreadsheet, then linking the spreadsheet to SharePoint (by using Export and Link to Excel from a Datasheet Task Pane). Once this is done, data can be entered into the spreadsheet and pushed from the spreadsheet to Excel with the Synchronize List option.
*********
Everything works fine when the VS is configured on HTTP mode. The servers are listening on port 80. The problem is with HTTPS connection only. In standard setup we are redirecting all HTTP requests to HTTPS.
POST /it/sites001/_vti_bin/lists.asmx HTTP/1.1
Content-Type: text/xml; charset=utf-8
SOAPAction: http://schemas.microsoft.com/sharepoint/soap/GetListAndView
X-Office-Version: 12.0.6020
User-Agent: Microsoft Office/12.0 (Windows NT 5.1; Microsoft Office Excel 12.0.6020; Pro)
Host: mysite.mydomain.com
Content-Length: 340
Connection: Keep-Alive
Cache-Control: no-cache
Cookie: MSOWebPartPage_AnonymousAccessCookie=80
{C5B5DCE4-BF3E-4715-9BD8-1A8AA36A5064}
{38C6017E-7CE6-4AB3-B3F6-1280E26CD806}
HTTP/1.0 302 Found
Location: https://mysite.mydomain.com/it/sites001/_vti_bin/lists.asmx
Server: BigIP
Connection: Keep-Alive
Content-Length: 0
If i user the uri part above and connect to HTTPS then it is not working.
This is the .iqy file which gets generated when you do "export to excel"
WEB
1
http://mysite.mydomain.com/it/sites001/_vti_bin/owssvr.dll?XMLDATA=1&List={C5B5DCE4-BF3E-4715-9BD8-1A8AA36A5064}&View={38C6017E-7CE6-4AB3-B3F6-1280E26CD806}&RowLimit=0&RootFolder=%2fit%2fsites001%2fLists%2fSite%20Provisioning%20List
Selection={C5B5DCE4-BF3E-4715-9BD8-1A8AA36A5064}-{38C6017E-7CE6-4AB3-B3F6-1280E26CD806}
EditWebPage=
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
SharePointApplication=http://intranetpp.bmc.com/it/sites001/_vti_bin
SharePointListView={38C6017E-7CE6-4AB3-B3F6-1280E26CD806}
SharePointListName={C5B5DCE4-BF3E-4715-9BD8-1A8AA36A5064}
RootFolder=/it/sites001/Lists/Site Provisioning List