tengo este archivo en el servidor y me gustaria leerlo con asp y poder sacar lo que me sirva de ese archivo para irlometiendo a una BD
Código HTML:
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=Content-Type content="text/html; charset=us-ascii"> <meta name=ProgId content=Excel.Sheet> <meta name=Generator content="Microsoft Excel 11"> <link rel=File-List href="excel_SAR_archivos/filelist.xml"> <link rel=Edit-Time-Data href="excel_SAR_archivos/editdata.mso"> <link rel=OLE-Object-Data href="excel_SAR_archivos/oledata.mso"> <!--[if gte mso 9]><xml> <o:DocumentProperties> <o:LastAuthor>oktopus</o:LastAuthor> <o:LastSaved>2009-05-28T12:25:23Z</o:LastSaved> <o:Version>11.9999</o:Version> </o:DocumentProperties> </xml><![endif]--> <style> <!--table {mso-displayed-decimal-separator:"\,"; mso-displayed-thousand-separator:"\.";} @page {margin:.98in .79in .98in .79in; mso-header-margin:0in; mso-footer-margin:0in;} tr {mso-height-source:auto;} col {mso-width-source:auto;} br {mso-data-placement:same-cell;} .style0 {mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; mso-rotate:0; mso-background-source:auto; mso-pattern:auto; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; border:none; mso-protection:locked visible; mso-style-name:Normal; mso-style-id:0;} td {mso-style-parent:style0; padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl24 {mso-style-parent:style0; vertical-align:top; border:.5pt solid black; white-space:normal;} .xl25 {mso-style-parent:style0; font-weight:700; vertical-align:top; border:.5pt solid black; white-space:normal;} .xl26 {mso-style-parent:style0; text-align:center; vertical-align:top; border:.5pt solid black; white-space:normal;} .xl27 {mso-style-parent:style0; font-weight:700; text-align:center; vertical-align:top; border:.5pt solid black; white-space:normal;} --> </style> <!--[if gte mso 9]><xml> <x:ExcelWorkbook> <x:ExcelWorksheets> <x:ExcelWorksheet> <x:Name>excel_SAR</x:Name> <x:WorksheetOptions> <x:DefaultColWidth>10</x:DefaultColWidth> <x:Selected/> <x:DoNotDisplayGridlines/> <x:Panes> <x:Pane> <x:Number>3</x:Number> <x:ActiveRow>7</x:ActiveRow> <x:ActiveCol>7</x:ActiveCol> </x:Pane> </x:Panes> <x:ProtectContents>False</x:ProtectContents> <x:ProtectObjects>False</x:ProtectObjects> <x:ProtectScenarios>False</x:ProtectScenarios> </x:WorksheetOptions> </x:ExcelWorksheet> </x:ExcelWorksheets> <x:WindowHeight>9345</x:WindowHeight> <x:WindowWidth>18780</x:WindowWidth> <x:WindowTopX>240</x:WindowTopX> <x:WindowTopY>105</x:WindowTopY> <x:ProtectStructure>False</x:ProtectStructure> <x:ProtectWindows>False</x:ProtectWindows> </x:ExcelWorkbook> </xml><![endif]--> </head> <body link=blue vlink=purple> <table x:str border=0 cellpadding=0 cellspacing=0 width=1028 style='border-collapse: collapse;table-layout:fixed;width:772pt'> <col width=93 style='mso-width-source:userset;mso-width-alt:3401;width:70pt'> <col width=149 style='mso-width-source:userset;mso-width-alt:5449;width:112pt'> <col width=76 style='mso-width-source:userset;mso-width-alt:2779;width:57pt'> <col width=56 style='mso-width-source:userset;mso-width-alt:2048;width:42pt'> <col width=100 style='mso-width-source:userset;mso-width-alt:3657;width:75pt'> <col width=320 style='mso-width-source:userset;mso-width-alt:11702;width:240pt'> <col width=108 style='mso-width-source:userset;mso-width-alt:3949;width:81pt'> <col width=126 style='mso-width-source:userset;mso-width-alt:4608;width:95pt'> <tr height=20 style='mso-height-source:userset;height:15.0pt'> <td height=20 class=xl25 width=93 style='height:15.0pt;width:70pt'>CODIGO_SAR</td> <td class=xl25 width=149 style='border-left:none;width:112pt'>CODIGO_PROVEEDOR</td> <td class=xl27 width=76 style='border-left:none;width:57pt'>ID_UNIDAD</td> <td class=xl27 width=56 style='border-left:none;width:42pt'>UNIDAD</td> <td class=xl27 width=100 style='border-left:none;width:75pt'>ID_PRODUCTO</td> <td class=xl25 width=320 style='border-left:none;width:240pt'>NOMBRE_PRODUCTO</td> <td class=xl25 width=108 style='border-left:none;width:81pt'>PRECIO_PESOS</td> <td class=xl25 width=126 style='border-left:none;width:95pt'>PRECIO_DOLARES</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl24 align=right width=93 style='height:12.75pt; border-top:none;width:70pt' x:num>1010001</td> <td class=xl26 width=149 style='border-top:none;border-left:none;width:112pt'>-</td> <td class=xl26 width=76 style='border-top:none;border-left:none;width:57pt' x:num>2</td> <td class=xl24 width=56 style='border-top:none;border-left:none;width:42pt'>UNIDAD</td> <td class=xl26 width=100 style='border-top:none;border-left:none;width:75pt' x:num>1</td> <td class=xl24 width=320 style='border-top:none;border-left:none;width:240pt'>WT 1 73PULG X 15 M ANSI 150</td> <td class=xl24 align=right width=108 style='border-top:none;border-left:none; width:81pt' x:num>5000</td> <td class=xl24 align=right width=126 style='border-top:none;border-left:none; width:95pt' x:num>5000</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl24 align=right width=93 style='height:12.75pt; border-top:none;width:70pt' x:num>1010002</td> <td class=xl26 width=149 style='border-top:none;border-left:none;width:112pt'>-</td> <td class=xl26 width=76 style='border-top:none;border-left:none;width:57pt' x:num>2</td> <td class=xl24 width=56 style='border-top:none;border-left:none;width:42pt'>UNIDAD</td> <td class=xl26 width=100 style='border-top:none;border-left:none;width:75pt' x:num>2</td> <td class=xl24 width=320 style='border-top:none;border-left:none;width:240pt'>WT 2 ANSI 150 48PULG X 15'</td> <td class=xl24 align=right width=108 style='border-top:none;border-left:none; width:81pt' x:num>0</td> <td class=xl24 align=right width=126 style='border-top:none;border-left:none; width:95pt' x:num>0</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl24 align=right width=93 style='height:12.75pt; border-top:none;width:70pt' x:num>1010003</td> <td class=xl26 width=149 style='border-top:none;border-left:none;width:112pt'>-</td> <td class=xl26 width=76 style='border-top:none;border-left:none;width:57pt' x:num>2</td> <td class=xl24 width=56 style='border-top:none;border-left:none;width:42pt'>UNIDAD</td> <td class=xl26 width=100 style='border-top:none;border-left:none;width:75pt' x:num>3</td> <td class=xl24 width=320 style='border-top:none;border-left:none;width:240pt'>WT 3 ANSI 600 42PULG X 10'</td> <td class=xl24 align=right width=108 style='border-top:none;border-left:none; width:81pt' x:num>0</td> <td class=xl24 align=right width=126 style='border-top:none;border-left:none; width:95pt' x:num>0</td> </tr> <tr height=17 style='height:12.75pt'> <td height=17 class=xl24 align=right width=93 style='height:12.75pt; border-top:none;width:70pt' x:num>1010004</td> <td class=xl26 width=149 style='border-top:none;border-left:none;width:112pt'>-</td> <td class=xl26 width=76 style='border-top:none;border-left:none;width:57pt' x:num>2</td> <td class=xl24 width=56 style='border-top:none;border-left:none;width:42pt'>UNIDAD</td> <td class=xl26 width=100 style='border-top:none;border-left:none;width:75pt' x:num>4</td> <td class=xl24 width=320 style='border-top:none;border-left:none;width:240pt'>WT 4 ANSI 600 42PULG X 15'</td> <td class=xl24 align=right width=108 style='border-top:none;border-left:none; width:81pt' x:num>0</td> <td class=xl24 align=right width=126 style='border-top:none;border-left:none; width:95pt' x:num>0</td> </tr> <![if supportMisalignedColumns]> <tr height=0 style='display:none'> <td width=93 style='width:70pt'></td> <td width=149 style='width:112pt'></td> <td width=76 style='width:57pt'></td> <td width=56 style='width:42pt'></td> <td width=100 style='width:75pt'></td> <td width=320 style='width:240pt'></td> <td width=108 style='width:81pt'></td> <td width=126 style='width:95pt'></td> </tr> <![endif]> </table> </body> </html>
si lo copiaran y pegaran en dreamweaver verian que solo sale una tabla con filas y columnas y realmente eso es solo lo qeu me interesaria sacar lo qeu va en esas tablas. lo edmas no lo necesito. es decir necsito un codigo ke me lea fila por fila para yo manipular esos datos.
gracias.
qeu pena preguntar tanto sobre este tema pero me tiene desesperado esto.
