468,753 Members | 1,278 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,753 developers. It's quick & easy.

Problem saving a file with .TXT extension.

9
Hi, I have a asp page where I have a Export to Excel button. When I click the button, I get the option to open or save or cancel.
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..
Dec 21 '07 #1
1 1395
leninv
9
The problem exists with notepad. Notepad doesnot support html code, i mean to say as the code has tags like <table>,etc. which are not supported, so this problem is faced. Hope this problem is understood.

Hi, I have a asp page where I have a Export to Excel button. When I click the button, I get the option to open or save or cancel.
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





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,






The code for this is writen in asp
Can anyone help me what can be done to overcome this issue..
Dec 27 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Hal Vaughan | last post: by
26 posts views Thread by HarryO | last post: by
5 posts views Thread by marcinka | last post: by
reply views Thread by Eugene | last post: by
1 post views Thread by Viktor Popov | last post: by
1 post views Thread by Sinan Alkan | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.