9
When I click on save option I get the save dialogue box and save it.
I don't have any problem if I save it with .xls extension, but the problem comes when I save it with .TXT extension. When I open the file saved with .txt extension I am able to see some html code as seen below
<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=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
</head>
<body>
<table x:str border=1 cellpadding=0 cellspacing=0 width=2020 style='border-collapse:
collapse;table-layout:fixed;width:1518pt'>
<col width=64 span=3 style='width:48pt'>
<col class=xl24 width=64 style='width:48pt'>
<col width=64 span=2 style='width:48pt'>
<tr height=17 style='height:12.75pt'> <td colspan=3 width=192 style='mso-ignore:colspan;width:144pt'> Created by ProEdge Visual BOM - 12/17/2007 3:48:09 PM</td><td></td> <td> Applied Materials Confidential </td></tr>
<tr height=17 style='height:12.75pt'><td> PART </td> <td> LEVEL </td>
<td> DESCRIPTION </td>
<td> REV </td>
<td> ITEM NUMBER </td>
<td>QUANTITY</td>
<td> UOM</td>
<td> ITEM TYPE</td>
<td>ITEM STATUS</td>
<td>PLANNER </td>
<td>BUYER</td>
<td>MAKE/BUY </td>
<td>ECO</td>
<td>DISABLE DATE</td>
<td>EFFECTIVITY DATE</td>
<td>LEAD TIME</td>
<td>OP SEQ</td>
<td>REMARKS</td>
<td>SUPPLY TYPE</td>
<td>SUB INVENTORY</td>
<td>SUPPLIER</td>
<td>MIN QUANTITY</td>
<td>MAX QUANTITY</td>
<td>MRP PLANNING CODE</td>
<td>CUM LEAD TIME</td>
<td>REFERENCE DESIGNATOR</td> <td>REFERENCE DESIGNATOR COMMENT </td>
<td>PLANNING FACTOR</td>
<td>DEPARTMENT</td>
<td>CRITICAL PART</td><tr>
only part of data is pasted here..
But I am supposed to see the only the data not the html code, please see the sample data that I am supposed to see,
PART LEVEL DESCRIPTION REV ITEM NUMBER QUANTITY UOM ITEM TYPE ITEM STATUS PLANNER BUYER MAKE/BUY ECO DISABLE DATE EFFECTIVITY DATE LEAD TIME OP SEQ REMARKS SUPPLY TYPE SUB INVENTORY SUPPLIER MIN QUANTITY MAX QUANTITY MRP PLANNING CODE CUM LEAD TIME REFERENCE DESIGNATOR REF DESIGNATOR COMMENT PLANNING FACTOR DEPARTMENT CRITICAL PART SPARABLE FLAG
20764-RSC-CONT 0 CONTROLLER 005 0 1 EA Configured Production 0 N/A Make NONE 0 0 NONE NONE NONE 0 0 7 0 0 N/A N N
0242-34298 1 "KIT, CENTURA CONTROLLER I/O, DSM" 001 10 1 EA Kit \ Subassembly Production 0 N/A Make NONE 11-Feb-07 5 1
The code for this is writen in asp
Can anyone help me what can be done to overcome this issue..
