Excel speradsheet toolbar in web page

[Amal Kamel]

Dear All,
I want to use the office web components in order to retreive reports from
SQL data base.
Using MS Excel, I had created the report, then saved as interactive web
page. I have two issues:
1. if the data changes in the data base, the web page is not reflected. I
need to open the excel, click the refresh data button, republish then view
the page. That way, the report is not dynamic?What is wrong in the previous
procedure
2. I need to add a print button in the toolbar (that 's why I am using
office web component to print)

I appreciate any suggestions and comments
Thanks in advance
Amal

 

[Alvin Bruney]

follow this link to manipulate the toolbar
http://www.networkip.net/tidbits/toolbar.htm
regards

 

[Wei-Dong Xu [MSFT]]

Hi Amal,

Thank you for posting in MSDN managed newsgroup!

I think the suggestion from Alvin may help you some on this issue.

Based on my expeirence, if you use pivotTable in Excel to build your report, you can produce interactive web page from Excel directly. For example,
you have inserted one pirvottable into the worksheet1 of Excel from "Data->PivotTable and PivotChart report...". After the settings for this
pivottable, select file->save as...->webpage->publish.... In the choose listbox of "Publish as web page" window, please select "Items on Sheet1" and
then choose pivottable item at the listbox below. Then in "Add interactivity with:" of View options, choose "PivotTable functionality". Then you can
publish the excel file into web page.

When open the published web page, you will find the pivotTable web component is displayed in the web page and you can update the data by
clicking the "refresh" button from the control line of pibotTable.

Furthermore, you can also export the pivotTable content into one Excel then print it in the web page.

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Wei-Dong Xu [MSFT]]

Hi Amal,

I'd also suggest you can download the office xp web component toolpack for more information about the usage of Office Web component. The
toolpack contains many example which may provide some assistance for your scenario. You can download the toolpack from Microsoft.com. Please go
to:
http://www.microsoft.com/downloads/...77-2100-4586-A13C-50E56F101720&displaylang=en

Please feel free to let me know if you have any further questions.

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Wei-Dong Xu [MSFT]]

Hi Amal,

For the print usage of pivotTable, there is one MSDN article which may help you some on this issue. Please go to:
Code Walkthrough: Printing the PivotTable Component from Microsoft Internet Explorer
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnowc/html/odc_pvtprint.asp

Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Amal Kamel]

Thank you a lot for your replies.
I am using spread sheet component not the pivot table component.

Hi Amal,

For the print usage of pivotTable, there is one MSDN article which may

help you some on this issue. Please go to:

 

[Wei-Dong Xu [MSFT]]

Hi Amal,

Thank you for replying!

From my understanding to your issue now, I'd suggest you can write one javascript to refresh the web page at a interval time for retrieving the data
from SQL server intervally. You can also build one ActiveX for this update which is running in client side. The ActiveX control will check the SQL
server to see whether there is any update in the SQL server. if get one, the ActiveX control will get the data back from SQL to update the speard
sheet.

Furthermore, you can also take advantage of .Net to build one winForm control in the web page which can do the same thing as the ActiveX. When
the customer visits the web page, IE will download the winform control to client side and then work for you.

For the ActiveX control, there is one sample for you from MSDN.microsoft.com. Please go to:
SMILEY Sample: A Simple ActiveX Control Container
http://msdn.microsoft.com/library/en-us/vcsample/html/_sample_mfc_smiley.asp?frame=true

For the winform control, you can obtain several samples from gotdotnet.com. Please go to:
http://samples.gotdotnet.com/quickstart/winforms/doc/WinFormsAxHosting.aspx

Please feel free to let me know if you have any further questions.

Does this answer your question? Thank you for using Microsoft NewsGroup!

Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.