open connection to excel from a webpage
hello,
i have excel spreadsheets that contain charts. i want to display those charts on a webpage WITHOUT converting the spreadsheets to HTML files? how do i do that? which one of these methods is easier to get the job done: asp, cgi, java, jsp, etc.? anyone?
thank you,
fareeda
[300 byte] By [
fka52] at [2007-11-17 16:45:14]
# 1 Re: open connection to excel from a webpage
the only solution you have is to make a HREF link to your excel spreadsheet and the navigator will open it inside (IE)
if you don't want this method i'm affraid you'll have to transform your excel in HTML ...
regards
Elise
tyris at 2007-11-8 0:12:42 >
# 2 Re: open connection to excel from a webpage
thank you for your response elise. i tried creating a href link to excel spreadsheet, but i couldn't link directly to the specific chart spreadsheet. it linked to workbook, not the spreadsheet. do you know the syntax that links ONLY the spreadsheet, not the workbook?
this creates a link to the workbook.
<a href="c:/windows/desktop/test.xls">
i tried this to link to the spreadsheet, but didn't work.
<a href="[c:/windows/desktop/test.xls]sheet">
any idea?
thank you,
fareeda
fka52 at 2007-11-8 0:13:36 >
# 3 Re: open connection to excel from a webpage
add a code (ALT + F11) in your excel file to hide all spreadsheet but the one you want to display ?
something like :
Sub Auto_open()
Sheets("my sheet").Visible = False
End Sub
may this help you ?
Elise
tyris at 2007-11-8 0:14:40 >
# 4 Re: open connection to excel from a webpage
hello,
thank you elise so much for your inputs. i tried what you suggested and it WORKED!!! :) the solution is soo simple. thanks again elise!
i'v decided to post the solution so that it may help those who are having the same problem.
here is a sample code:
<html><head>
<script language=vbscript>
Dim objExcel
Sub chartsheet_onclick()
call OpenWorkbook("c:\test\testfile.xls")
End Sub
Sub OpenWorkbook(strLocation)
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = true
objExcel.Workbooks.Open strLocation
objExcel.UserControl = true
objExcel.Sheets("chart").Visible = True
objExcel.Sheets("sheet1").Visible = False
objExcel.Sheets("sheet2").Visible = False
objExcel.Sheets("sheet3").Visible = False
End Sub
</script>
<title></title></head><body><br>
this is a test page for displaying an excel chart...
<br><br>
<input type=button name=chartsheet value="display excel chart">
</body></html>
fareeda
fka52 at 2007-11-8 0:15:45 >
# 5 Re: open connection to excel from a webpage
i'm happy it helped you, i have often been helped for XML or Webservices so if i can sometime help i'm glad
regards
Elise
tyris at 2007-11-8 0:16:44 >
