Modificare il file:
\Backup 02-06-2024\Esempio.asp
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <BODY> <TABLE BORDER=1> <TR><TH>ID</TH><TH>Codice</TH><TH>Nome</TH><TH>Descrizione</TH><TH>Prezzo</TH><TH>Foto</TH><TH>Marca</TH><TH>Vuoto</TH><TH>Dispo</TH><TH>Prenotato</TH><TH>E-Mail</TH></TR> <% Const ColonnaCod=1 Const ColonnaNome=2 Const ColonnaDescrizione=3 Const ColonnaPrezzo=4 Const ColonnaFoto=5 Const ColonnaMarca=6 Const ColonnaVuoto=7 Const ColonnaDispo=8 Const ColonnaPrenotato=9 Const ColonnaE_Mail=10 Set objExcel = CreateObject("Excel.Application") objExcel.Visible = false ' Inserire Procedura automatica di lettura file objExcel.Workbooks.Open("L:\! Martinucci\2015\Testi\Marazzi.xls") Set objWorkbook = objExcel.Workbooks("Marazzi.xls").sheets("Foglio1") riga= 2 Do While (objWorkbook.Cells(riga,ColonnaCod).Value <> "") response.write "<TR><TD>" & objWorkbook.Cells(riga, ColonnaCod).Value & "</TD>"+vbcrlf response.write "<TD>" & objWorkbook.Cells(riga, ColonnaNome).Value & "</TD>"+vbcrlf response.write "<TD>" & objWorkbook.Cells(riga, ColonnaDescrizione).Value & "</TD>"+vbcrlf response.write "<TD>" & objWorkbook.Cells(riga, ColonnaPrezzo).Value & "</TD></TR>"+vbcrlf response.write "<TD>" & objWorkbook.Cells(riga, ColonnaFoto).Value & "</TD>"+vbcrlf response.write "<TD>" & objWorkbook.Cells(riga, ColonnaMarca).Value & "</TD></TR>"+vbcrlf response.write "<TD>" & objWorkbook.Cells(riga, ColonnaVuoto).Value & "</TD>"+vbcrlf response.write "<TD>" & objWorkbook.Cells(riga, ColonnaDispo).Value & "</TD></TR>"+vbcrlf response.write "<TD>" & objWorkbook.Cells(riga, ColonnaPrenotato).Value & "</TD>"+vbcrlf response.write "<TD>" & objWorkbook.Cells(riga, ColonnaE_mail).Value & "</TD></TR>"+vbcrlf riga = riga + 1 Loop objExcel.Quit Set objExcel=Nothing %> </TABLE> </BODY> </HTML>
[
Íàçàä
]