export to excel issue

Neo

I am pasting sample code below which I call on a button click. My problem is
that 6/7 is shown by excel as 7-Jun. I want it to look as 6/7 in excel.
Please let me know if anyone has a solution.

Thanks

string temp = "<html><table><tr><td>6/7</label></td></tr></table></html>";
Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment; filename=test.xls");
Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.Charset = "";
EnableViewState = false;
Response.Write(temp);

Oct 8 '06 #1

Subscribe Reply

1342

Cowboy \(Gregory A. Beamer\)

Add a single quote ' before the 6/7. That will indicate you want text rather
than the Excel tendency to treat it as a date.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com/

*************************************************
Think Outside the Box!
*************************************************
"Neo" <Ne*@discussions.microsoft.comwrote in message
news:41**********************************@microsof t.com...

>I am pasting sample code below which I call on a button click. My problem
is
that 6/7 is shown by excel as 7-Jun. I want it to look as 6/7 in excel.
Please let me know if anyone has a solution.

Thanks

string temp = "<html><table><tr><td>6/7</label></td></tr></table></html>";
Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;
filename=test.xls");
Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.Charset = "";
EnableViewState = false;
Response.Write(temp);

Oct 8 '06 #2

Neo

Hi
Thanks for the reply. However if I add a quote it will show '6/7 in
excell cell. It doesn't look nice. Is there any way I can achieve this
without showing any other character in the cell.

Thanks

"Cowboy (Gregory A. Beamer)" wrote:

Add a single quote ' before the 6/7. That will indicate you want text rather
than the Excel tendency to treat it as a date.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com/

*************************************************
Think Outside the Box!
*************************************************
"Neo" <Ne*@discussions.microsoft.comwrote in message
news:41**********************************@microsof t.com...
I am pasting sample code below which I call on a button click. My problem
is
that 6/7 is shown by excel as 7-Jun. I want it to look as 6/7 in excel.
Please let me know if anyone has a solution.

Thanks

string temp = "<html><table><tr><td>6/7</label></td></tr></table></html>";
Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment;
filename=test.xls");
Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.Charset = "";
EnableViewState = false;
Response.Write(temp);

Oct 9 '06 #3

Similar topics

5226

Export to Excel From ASP: Text Data Interpretation issue

by: Saur | last post by:

Hi, I am using an export to excel functionality from my ASP page. I have set the content type as Response.ContentType = "application/vnd.ms-excel" The data i am exporting has values like 1-2,...

ASP / Active Server Pages

3109

Access 2K export to Excel - too much data

by: Gary Wright | last post by:

I have an Access 2K database split into front and back. Quite often the users want to do some data analysis that I have not created a report for so they want to export some subset of the data into...

Microsoft Access / VBA

13098

Reading records into Crystal Report for export as Excel?

by: Robin Cushman | last post by:

Hi all, I need some help -- I'm working with an A2K database, using DAO, and am trying to read records into a Crystal Report and then export it to a folder on our network as an Excel...

Microsoft Access / VBA

2890

Single Quote Problem in Excel to Export

by: Prasad Dannani | last post by:

Hi, We have to export our data in sql server table to any excel sheet. We have a template to export, using oledb we are inserting rows to this template and generating the excel output. The...

ASP.NET

2001

Export to Excel and firewalls

by: Marja Ribbers-de Vroed | last post by:

Hi, One of my clients has a strange problem with my webapplication which I think may be related to some firewall setting on his computer. On several screens in the application, it is possible...

ASP / Active Server Pages

13179

Export to Excel (Default File Type - Excel)

by: Hemant Sipahimalani | last post by:

The following piece of code is being used to export HTML to excel. HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"...

ASP.NET

2805

Export to Excel issue..

by: karthick | last post by:

Hi, I am exporting a Gridview to Excel and it works fine without any issues. But as one of the field holds values such as "71646E100" it gets converted to: "7.16E+104" (like a formula) in...

ASP.NET

9753

Access Tables to Excel Worksheet Export

by: smaczylo | last post by:

Hello, I've recently been asked to work with Microsoft Access, and while I feel quite comfortable with Excel, I'm at a complete loss with databases. If someone could help me with this issue I'm...

Microsoft Access / VBA

1759

Export Datagrid rows to excel : no of rows issue

by: leena13 | last post by:

Hi, The number of rows in the datagrid on my page are approx. around 14130. When I click on the button that exports the records to excel sheet, the page goes blank (I observed that none of the...

.NET Framework

11206

export datatable to excel

by: cj2 | last post by:

#1 Is there a quick way to export a datatable to an excel file? Or delimited file? #2 Where is the appropriate Microsoft monitored group to ask about writing reports in SQL Reporting services...

Visual Basic .NET

7134

What is ONU?

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,...

General

7014

Changing the language in Windows 10

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...

Windows Server

7180

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7229

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

7395

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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...

General

5485

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4609

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

1429

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

667

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP