Re: display excel spreadsheet charts on webpage: the SOLUTION
thank you vince for your response. i checked the article you referred me
to. it was helpful. i also found a very simple SOLUTION to displaying individual
charts on a webpage. i decided to post the code so that it may help those
who are having the same problem.
this is what you do:
open a connection to your excel workbook from your webpage.
set the chart spreadsheet you wish to see to "visible".
set all other spreadsheets to hide.
set your workbook as read-only if you don't want users to change your data/charts.
here is a sample code:
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = true
objExcel.UserControl = true
objExcel.Sheets("chart").Visible = True
objExcel.Sheets("sheet1").Visible = False
objExcel.Sheets("sheet2").Visible = False
objExcel.Sheets("sheet3").Visible = False
this is a test page for displaying an excel chart...
<input type=button name=chartsheet value="display excel chart">
"Vince" <firstname.lastname@example.org> wrote:
>Link to an answer to this question, may help.
>"fareeda" <email@example.com> wrote:
>>i have excel spreadsheets that contain charts and graphs. i want to display
>>those charts on a webpage WITHOUT having to convert the charts into HTML
>>files. what is the best and easy way to do this? i tried to create a
>>to the charts using the <a href = ...> html method. it linked the workbook
>>but not the spreadsheet. i want to link ONLY the spreadsheets. something
>>like this: <a href='[c:\windows\desktop\test.xls]chart'> this didn't work.
>>to do this?
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center