Showing Excel Sheet on Webpage

[Rohit111111]

Hello Friends
I am using asp.net 2005 C#,I have to show a Excel Sheet on my Webpage,how can i do it.

[ammoos]

pls try this if u want to display as exsisting excelsheet in ur asp.net page

write the following code on the asp.net code page

lnkViewSpreadsheet.Attributes.Add("onclick","openE xcel('"+ excelSheetName +"')");

in this example 'lnkViewSpreadsheet' is a link button.. and the excelSheetName is the fullpath of the excel file

and then write the following javascript inthe asp.net html page


<script language=JavaScript>
<!--
onerror=handleErr
var txtErr=""
function handleErr(msg,url,l)//Function to handle errors
{
txtErr="There was an error on this page.\n\n"
txtErr+="Error: " + msg + "\n"
txtErr+="URL: " + url + "\n"
txtErr+="Line: " + l + "\n\n"
txtErr+="Click OK to continue.\n\n"
alert(txtErr)
return true

}
function openExcel(strExcelFile)// function to open the selected excel file

{
var excelApplication = new ActiveXObject("Excel.Application");//create the object of the excel
if (excelApplication != null)
{
excelApplication.visible = true;
excelApplication.workbooks.open(strExcelFile);// open the selected file
}
}
</script>

[kenobewan]

Please outline the problem that you are having. Thanks.

[Rohit111111]

pls try this if u want to display as exsisting excelsheet in ur asp.net page

write the following code on the asp.net code page

lnkViewSpreadsheet.Attributes.Add("onclick","openE xcel('"+ excelSheetName +"')");

in this example 'lnkViewSpreadsheet' is a link button.. and the excelSheetName is the fullpath of the excel file

and then write the following javascript inthe asp.net html page


<script language=JavaScript>
<!--
onerror=handleErr
var txtErr=""
function handleErr(msg,url,l)//Function to handle errors
{
txtErr="There was an error on this page.\n\n"
txtErr+="Error: " + msg + "\n"
txtErr+="URL: " + url + "\n"
txtErr+="Line: " + l + "\n\n"
txtErr+="Click OK to continue.\n\n"
alert(txtErr)
return true

}
function openExcel(strExcelFile)// function to open the selected excel file

{
var excelApplication = new ActiveXObject("Excel.Application");//create the object of the excel
if (excelApplication != null)
{
excelApplication.visible = true;
excelApplication.workbooks.open(strExcelFile);// open the selected file
}
}
</script>

Hi Thanks for the Quick Reply but I dont want to open that excel sheet in excel,I want to just show it on the same web page...For Exapmle I have a excel sheet say Book1.xls.Now when My web page loads than first of all io want to Boook1.xls on the same webpage.How can i do it.

[Rohit111111]

Please outline the problem that you are having. Thanks.

Hi,
When My pageloads i have to show a excel sheet on the same webpage,is there any way to show the Complete Excel sheet on webpage.