entonces mas bien como hago para leer ese archivo generado por el asp. sabes?
el resultado final del archivo .xls es este..
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-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>
sera que mas bien al hacer el upload con xelupload le cambio la extension a html o xml o algo asi y busco otra forma de leer el archivo? es decir ya dejo de leer un xls y tengo ke leer un html?
alguien sabe como leer un archivo asi con este formato?
gracias.