Send form results to an excel sheet
MS Frontpage
Send form results to an excel sheet
wafaa
02-17-2007, 1:14 AM
Dear all,
I followed all the steps and instructions to send the form results to an excel sheet, every thing is working fine but when I open the excel sheet there is no data.
I don't know what's the problem
Please help
Thanks
Re: Send form results to an excel sheet
zeke
08-10-2007, 3:25 PM
This is what it takes to put an Excel 2003 spreadsheet in a WSS3.0 web page, according to
fhttp://www.microsoft.com/downloads/details.aspx?FamilyID=dc3d8474-d960-4d14-a9df-9024e39f5463&DisplayLang=en
"Before a SharePoint site can support Spreadsheet Web Parts, the server administrator must install the (MOCSPT)
Microsoft Office Components for SharePoint Products and Technologies on that server or in a server farm deployment,
install it on all front-end Web servers. The server administrator must install this component only once per server to support
any number of Spreadsheet Web Parts on SharePoint sites within the deployment.
The Microsoft Office 2003 Spreadsheet Web Component must be installed on all client computers in order to successfully
use the Spreadsheet Web Part. The Spreadsheet Web Component is installed as part of the Office 2003 Web Components.
By default, the Office 2003 Web Components are installed as part of Microsoft Office 2003.
"To use the Spreadsheet Web Part Add-In, set up a workbook in Excel. Add any data bindings, XML Maps, formatting and
formulas you want. Then, using the Add-in wizard , put the finishing touches on the customized Spreadsheet Web Part by
giving it a name and defining any Web Part connections you may need. The Add-in wizard creates all of the configuration files
for the Web Part such as the Solution Specification, XML Spreadsheet and Web Part Definition files, and saves them to the
SharePoint site. This Web Part allows you to use your spreadsheet on any Web Part Page."
How? The MOCSPT " contains a the Datasheet Web Part (which) embeds spreadsheet functionality into a SharePoint site,"
according to MS Technet http://www.microsoft.com/technet/windowsserver/sharepoint/v2/spoffint.mspx.
Another doc sums it up. "The increasing levels of functional capabilities have been deemed “fair” for Office 2000, “good” for
Office XP, “better” for the Office 2003 Editions, and “best” for the 2007 Office Suites in terms of how they work together with
SharePoint." http://www.microsoft.com/downloads/details.aspx?FamilyID=e0d05a69-f67b-4d37-961e-
2db3c4065cb9&DisplayLang=en.
That leaves what for the Vista + MOSS 2007 functionality, "most excellent" ?
I'll take "better" and "best" while we wait.
webhost4life.com