Hi all.
I must publish data from an Excel Worksheet into a web page.
For this i use activeX controls in javascript :
<script language="JavaScript">
var fichier_excel;
var valeur_cellule;
fichier_excel=new ActiveXObject("excel.application"
;
fichier_excel.visible=false;
function importation_cellules_1(y,x){
fichier_excel.Workbooks.Open("C:\\fiche.xls"
;
var valeur_cellule = fichier_excel.ActiveSheet.Cells(y,x).Value
document.write(valeur_cellule);
}
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000"onload="importation_cellules_1(18,2)">
All this works very fine but i have a problem with an IE functionality. Before the web page opens, a msg box appears. It says there are ActiveX controls in the current page and that it could be unsafe etc...
I need to click "OK" to load the page and this is very annoying for other functionalities of the page on other frames.
I thought that this message was related to the security level in IE. I set up the IE security parameters to the lowest level : it does not solve my problem.
I tried the script with several PC and IE versions (5 / 5.5 / 6) : same problem.
My question is : do you know some way to directly skip or validate the msg box without human intervention?
Thanks a lot for your help.
Pierre.
I must publish data from an Excel Worksheet into a web page.
For this i use activeX controls in javascript :
<script language="JavaScript">
var fichier_excel;
var valeur_cellule;
fichier_excel=new ActiveXObject("excel.application"
fichier_excel.visible=false;
function importation_cellules_1(y,x){
fichier_excel.Workbooks.Open("C:\\fiche.xls"
var valeur_cellule = fichier_excel.ActiveSheet.Cells(y,x).Value
document.write(valeur_cellule);
}
</script>
</head>
<body bgcolor="#FFFFFF" text="#000000"onload="importation_cellules_1(18,2)">
All this works very fine but i have a problem with an IE functionality. Before the web page opens, a msg box appears. It says there are ActiveX controls in the current page and that it could be unsafe etc...
I need to click "OK" to load the page and this is very annoying for other functionalities of the page on other frames.
I thought that this message was related to the security level in IE. I set up the IE security parameters to the lowest level : it does not solve my problem.
I tried the script with several PC and IE versions (5 / 5.5 / 6) : same problem.
My question is : do you know some way to directly skip or validate the msg box without human intervention?
Thanks a lot for your help.
Pierre.