Tema: leer un excel exportado desde asp.
Ver Mensaje Individual
  #8 (permalink)  
Antiguo 27/05/2009, 20:26
Avatar de lexus
lexus
 
Fecha de Ingreso: enero-2002
Ubicación: Cali - Colombia
Mensajes: 2.234
Antigüedad: 23 años, 3 meses
Puntos: 4
Respuesta: leer un excel exportado desde asp.
le di click derecho al .xls y lo abri con block de notas y me salio este codigo..


Código: 
<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-28T02:26:24Z</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_productos</x:Name>
    <x:WorksheetOptions>
     <x:DefaultColWidth>10</x:DefaultColWidth>
     <x:Print>
      <x:ValidPrinterInfo/>
      <x:VerticalResolution>0</x:VerticalResolution>
     </x:Print>
     <x:Selected/>
     <x:Panes>
      <x:Pane>
       <x:Number>3</x:Number>
       <x:ActiveRow>4</x:ActiveRow>
       <x:RangeSelection>$5:$128</x:RangeSelection>
      </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>10005</x:WindowHeight>
  <x:WindowWidth>10005</x:WindowWidth>
  <x:WindowTopX>120</x:WindowTopX>
  <x:WindowTopY>135</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=512 style='border-collapse:
 collapse;table-layout:fixed;width:384pt'>
 <col width=64 span=256 style='mso-width-source:userset;mso-width-alt:2340;
 width:48pt'>
 <tr height=20 style='mso-height-source:userset;height:15.0pt'>
  <td height=20 class=xl25 width=64 style='height:15.0pt;width:48pt'>CODIGO_SAR</td>
  <td class=xl25 width=64 style='border-left:none;width:48pt'>CODIGO_PROVEEDOR</td>
  <td class=xl27 width=64 style='border-left:none;width:48pt'>ID_UNIDAD</td>
  <td class=xl27 width=64 style='border-left:none;width:48pt'>UNIDAD</td>
  <td class=xl27 width=64 style='border-left:none;width:48pt'>ID_PRODUCTO</td>
  <td class=xl25 width=64 style='border-left:none;width:48pt'>NOMBRE_PRODUCTO</td>
  <td class=xl25 width=64 style='border-left:none;width:48pt'>PRECIO_PESOS</td>
  <td class=xl25 width=64 style='border-left:none;width:48pt'>PRECIO_DOLARES</td>
 </tr>
 <tr height=68 style='height:51.0pt'>
  <td height=68 class=xl24 align=right width=64 style='height:51.0pt;
  border-top:none;width:48pt' x:num>1010001</td>
  <td class=xl26 width=64 style='border-top:none;border-left:none;width:48pt'>-</td>
  <td class=xl26 width=64 style='border-top:none;border-left:none;width:48pt'
  x:num>2</td>
  <td class=xl24 width=64 style='border-top:none;border-left:none;width:48pt'>UNIDAD</td>
  <td class=xl26 width=64 style='border-top:none;border-left:none;width:48pt'
  x:num>1</td>
  <td class=xl24 width=64 style='border-top:none;border-left:none;width:48pt'>WT
  1 73PULG X 15 M ANSI 150</td>
  <td class=xl24 align=right width=64 style='border-top:none;border-left:none;
  width:48pt' x:num>0</td>
  <td class=xl24 align=right width=64 style='border-top:none;border-left:none;
  width:48pt' x:num>0</td>
 </tr>
 <tr height=68 style='height:51.0pt'>
  <td height=68 class=xl24 align=right width=64 style='height:51.0pt;
  border-top:none;width:48pt' x:num>1010002</td>
  <td class=xl26 width=64 style='border-top:none;border-left:none;width:48pt'>-</td>
  <td class=xl26 width=64 style='border-top:none;border-left:none;width:48pt'
  x:num>2</td>
  <td class=xl24 width=64 style='border-top:none;border-left:none;width:48pt'>UNIDAD</td>
  <td class=xl26 width=64 style='border-top:none;border-left:none;width:48pt'
  x:num>2</td>
  <td class=xl24 width=64 style='border-top:none;border-left:none;width:48pt'>WT
  2 ANSI 150 48PULG X 15'</td>
  <td class=xl24 align=right width=64 style='border-top:none;border-left:none;
  width:48pt' x:num>0</td>
  <td class=xl24 align=right width=64 style='border-top:none;border-left:none;
  width:48pt' x:num>0</td>
 </tr>
 <tr height=68 style='height:51.0pt'>
  <td height=68 class=xl24 align=right width=64 style='height:51.0pt;
  border-top:none;width:48pt' x:num>1010003</td>
  <td class=xl26 width=64 style='border-top:none;border-left:none;width:48pt'>-</td>
  <td class=xl26 width=64 style='border-top:none;border-left:none;width:48pt'
  x:num>2</td>
  <td class=xl24 width=64 style='border-top:none;border-left:none;width:48pt'>UNIDAD</td>
  <td class=xl26 width=64 style='border-top:none;border-left:none;width:48pt'
  x:num>3</td>
  <td class=xl24 width=64 style='border-top:none;border-left:none;width:48pt'>WT
  3 ANSI 600 42PULG X 10'</td>
  <td class=xl24 align=right width=64 style='border-top:none;border-left:none;
  width:48pt' x:num>0</td>
  <td class=xl24 align=right width=64 style='border-top:none;border-left:none;
  width:48pt' x:num>0</td>
 </tr>
 <![if supportMisalignedColumns]>
 <tr height=0 style='display:none'>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
  <td width=64 style='width:48pt'></td>
 </tr>
 <![endif]>
</table>
</body>
</html>
__________________
Control de Visitantes, Control de Accesos, Minutas digitales, Manejo de Correspondencia
http://www.controldevisitantes.com