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:sc hemas-microsoft-com:office:offi ce"
xmlns:x="urn:sc hemas-microsoft-com:office:exce l"
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.S heet>
<meta name=Generator content="Micros oft Excel 11">
</head>
<body>
<table x:str border=1 cellpadding=0 cellspacing=0 width=2020 style='border-collapse:
collapse;table-layout:fixed;wi dth:1518pt'>
<col width=64 span=3 style='width:48 pt'>
<col class=xl24 width=64 style='width:48 pt'>
<col width=64 span=2 style='width:48 pt'>
<tr height=17 style='height:1 2.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:1 2.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>EFFECTIVI TY 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>DEPARTMEN T</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..
1 1571
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..
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Hal Vaughan |
last post by:
I am using OpenOffice files in my app. They're stored in .zip format, so
the zip format is much more important, in this case, than that they're OOo
files (other than that the extension is .sxw and not .zip).
(I know these code sections use outside variables, but it's probably pretty
clear what the outside variables are -- if not, I can clarify.)
I read the files in this way:
int i = 0;
byte bIn = new byte, bData;
|
by: HarryO |
last post by:
I created an external stylesheet file 'styles.css' and an html file that
includes the line:
<LINK REL="stylesheet" TYPE="text/css" HREF="styles.css"
Both the .css file and the html file reside on my local PC. When I open the
html file with IE6 the styles are not seen in the webpage. Everything looks
fine if I upload the .css and html files to my web server.
Any ideas on why the styles don't appear on my local PC?
|
by: Dobedani |
last post by:
Dear All,
I am developing / maintaining a web application which generates GIF
images on the fly. When I send the image, I make sure a header is sent
first with MIME-type image/gif. My HTML-code to show the image looks
like this:
<IMG SRC="http://myserver/scripts/mycgi.exe?page=graphsym&favid=myfav4&numlines=1&key=18"
BORDER="0">
|
by: marcinka |
last post by:
Hello
This is the program, that I wrote.
#include <stdio.h>
#define MAX 4096
typedef unsigned short int int16;
int16 o;
unsigned char i;
|
by: Kidus Yared |
last post by:
I am having a problem displaying Unicode characters on my Forms labels and
buttons. After coding Button1.Text = unicode; where the unicode is a Unicode
character or string (‘\u1234’ or “\u1234”) It seems to work the first time I
set the button to the Unicode character. After a while, when saving my code,
I get a pop-up window stating that I need to save the file as a Unicode else
my changes will not be saved.
Seance I do not want...
| |
by: Eugene |
last post by:
Hi,
I have a template in html and want to use web matrix to create a form. I am
able to open the file and use the web controls after changing the file
extension to aspx. But after saving the file, the textbox and the other
input web controls disappear from the design tab. I can still find them in
the properties pane. Is this normal when saving apsx from html pages?
Another issue that I have is I can create a new database on my SQL...
|
by: Viktor Popov |
last post by:
Hi,
I'm trying to upload a file and I do that with this code, but there is a
thing which doesn't work. I can't understand how to check if it isn't
written the path to the file(the text field of <input> control is empty) or
it is.
I have tryed with the following:
if( filMyFile.PostedFile != null) //HtmlInputFile filMyFile;
{
code
|
by: Sinan Alkan |
last post by:
Hi All,
I have a method to resize any image file to the specific dimensions and
save this new image to a path.
I found it on a web page(By Joel Neubeck) and i changed it for my project.
The code is as follows;
---------------------------------
// usings part
using System.Drawing;
using System.Drawing.Imaging;
|
by: shahidrasul |
last post by:
i want to download a file which user select from gridview, downloading is completing without problem but after download i want to refresh my page because i do some changes in db .
but when refresh.redirect() occure it give me error that
can't redirect because headers have been sent
following are my code to download file
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |