houn problema con uno scrip che mi crea un foglio excel
prendendo i dati da un DB access, in pratica lo script funziona ma
non appena apro la pagina asp che lo contiene invece di visualizzarmi la pagina stessa parte in auto lo script chiendedomi di salvare ( o aprire) la pagina excel.Io vorrei invece che la pagina si aprisse normalmente e che poi clikkando su un pulsante mi kiedesse di salvare il file excel.
Se è possbile mi piacerebbe anke ke lo script mi salvasse il doc excel ogni volta con nomi diversi (forse con una funzione random?) o meglio con uno dei campi del record interessato.
Spero di essere stato kiaro..
e cmq grazie sempre..
Posto la pagina con lo script in questione:
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@LANGUAGE="VBSCRIPT"%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<%
idfattura=request.querystring("idfattura")
sql="SELECT * from fatture where idfattura like '"&idfattura&"'"
Set OBJdbConnection=Server.CreateObject("ADODB.Connect ion")
OBJdbConnection.open"driver={Microsoft Access Driver (*.mdb)};dbq="&server.mapPath("../mdb-database/fatture.mdb")
Set Rs=OBJdbConnection.Execute(sql)
idfattura=rs("idfattura")
datafattura=rs("datafattura")
acconto=rs("acconto")
incentivi=rs("incentivi")
recupero=rs("recupero")
imponibile=rs("imponibile")
IVA=rs("IVA")
totale=rs("totale")
enasarco=rs("enasarco")
ritenuta=rs("ritenuta")
netto=rs("netto")
azienda=rs("azienda")
%>
<title>Gestione fatture Fabio Di Maria - <%=datafattura%> - <%=azienda%></title>
<style type="text/css">
<!--
body {
font-family: "Century Gothic";
color: #000099;
}
.Stile1 {color: #000000}
.Stile7 {
color: #FF0000;
font-weight: bold;
}
.Stile9 {color: #000000; font-weight: bold; }
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
<body>
<table cellspacing="0" cellpadding="0">
<tr>
<td colspan="2"><h3><span class="Stile1">DI MARIA FABIO</span></h3></td>
<td width="226"><h3><span class="Stile1"></span></h3></td>
</tr>
<tr>
<td colspan="3"><h3><span class="Stile1">VIALE M. SS. MEDIATRICE 17</span></h3></td>
</tr>
<tr>
<td colspan="2"><h3><span class="Stile1">90129PALERMO</span></h3></td>
<td><h3><span class="Stile1"></span></h3></td>
</tr>
<tr>
<td colspan="3"><h3><span class="Stile1">DMR FBA 65B28 G273U</span></h3></td>
</tr>
<tr>
<td colspan="2"><h3><span class="Stile1">P.I 03320590825</span></h3></td>
<td><h3><span class="Stile1"></span></h3></td>
</tr>
</table>
</p>
</p>
<p align="left"></p>
<table width="365" height="446" border="0" align="left" cellpadding="2" cellspacing="2" bordercolor="#000000" id="fattura">
<tr align="left" valign="middle">
<td width="212" height="34"> <div align="justify" class="Stile9 Stile1">ID fattura: </div></td>
<td width="117"> <div align="justify" class="Stile7 Stile1"><%=idfattura%></div></td>
</tr>
<tr align="left" valign="middle">
<td height="36"> <div align="justify" class="Stile9 Stile1">Data fattura : </div></td>
<td><span class="Stile9 Stile1"><%=datafattura%></span> </td>
</tr>
<tr align="left" valign="middle">
<td height="36"><div align="justify" class="Stile9 Stile1">Acconto/provvigioni:</div></td>
<td class="Stile7 Stile1"> <span class="Stile1"><%=acconto%> </span></td>
</tr>
<tr align="left" valign="middle">
<td height="36"><div align="justify" class="Stile9 Stile1">Incentivi/vari:</div></td>
<td class="Stile7 Stile1"> <span class="Stile1"><%=incentivi%> </span></td>
</tr>
<tr align="left" valign="middle">
<td height="36"><div align="justify" class="Stile9 Stile1">Recupero/acconto:</div></td>
<td class="Stile7 Stile1"> <span class="Stile1"><%=recupero%> </span></td>
</tr>
<tr align="left" valign="middle">
<td height="36" class="Stile9 Stile1">Imponibile:</td>
<td class="Stile7 Stile1"><span class="Stile1"> <%=imponibile%> </span></td>
</tr>
<tr align="left" valign="middle">
<td height="36"><div align="justify" class="Stile9 Stile1">IVA 20%:
<div align="center">
<div align="justify"></div>
</div>
</div></td>
<td><div align="justify" class="Stile7 Stile1">
<div align="center">
<div align="justify"><span class="Stile1"> <%=IVA%> </span></div>
</div>
</div></td>
</tr>
<tr align="left" valign="middle">
<td height="36" class="Stile9 Stile1">Totale:</td>
<td><span class="Stile9 Stile1"> <%=totale%> </span></td>
</tr>
<tr align="left" valign="middle">
<td height="36"><div align="justify" class="Stile9 Stile1">Enasarco 6,25%: </div></td>
<td class="Stile7 Stile1"><span class="Stile1"><%=enasarco%> </span></td>
</tr>
<tr align="left" valign="middle">
<td height="36"><div align="justify" class="Stile9 Stile1">Ritenuta:
<div align="justify" class="Stile1">
<div align="center">
<div align="justify"></div>
</div>
</div>
<div align="center">
<div align="justify"></div>
</div>
</div></td>
<td class="Stile7 Stile1"><span class="Stile1"><%=ritenuta%> </span></td>
</tr>
<tr align="left" valign="middle">
<td height="36"><div align="justify" class="Stile9 Stile1"><span class="Stile1">Netto:</span>
<div align="justify" class="Stile1">
<div align="center">
<div align="justify"></div>
</div>
</div>
<div align="center">
<div align="justify"></div>
</div>
</div></td>
<td class="Stile7 Stile1"><span class="Stile1"><%=netto%> </span></td>
</tr>
</table>
<div align="center">
<div align="justify">
</p>
</p>
</p>
</p>
</p>
</p>
</p>
</p>
</p>
</p>
</p>
</p>
</p>
<table width="200" border="1" align="center">
<tr>
<td>
<script language="JavaScript" type="text/javascript">
function printit(){
if (window.print) {
window.print() ;
} else {
var WebBrowser = '<OBJECT ID="WebBrowser1" WIDTH=0 HEIGHT=0 CLASSID="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2"></OBJECT>';
document.body.insertAdjacentHTML('beforeEnd', WebBrowser);
WebBrowser1.ExecWB(6, 2);//Use a 1 vs. a 2 for a prompting dialog box WebBrowser1.outerHTML = "";
}
}
</script>
<script language="JavaScript1.2" type="text/JavaScript1.2">
var message = "Stampa Fattura";
function printpage() {
window.print();
}
document.write("<form><input type=button "
+"value=\""+message+"\" onClick=\"printpage()\"></form>");
</script>
</td>
<td>
<%
' estraggo i dati
Set rs = OBJdbConnection.Execute("SELECT * FROM fatture where idfattura like '"&idfattura&"'")
for i = 0 to rs.Fields.Count-1
risultato = risultato & rs.Fields(i).Name & "</td><td>"
next
risultato = risultato & "</td></tr><tr><td>"
risultato = risultato & rs.GetString(,,"</td><td>","</td></tr><tr><td>", "-")
' chiusura
rs.Close
set rs = Nothing
OBJdbConnection.Close
set OBJdbConnection = Nothing
' modifico header per forzare l'apertura in Excel
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "content-disposition", "inline; filename=tabella.xsl"
' scrivo a video
'Response.Write ("<table><tr><td>" & risultato & "</td></tr></table>")
%>
</td>
</tr>
</table>
</body>
</head>
</html>
Rispondi quotando