How to Export to excel keeping text colour same ?

Hi all,

I have a simple code that exports an HTML table on an ASP page to excel.
The code works fine, however if the original text in the HTML table had a particular colour, it is not exported in the same way.The resulting excel file has all text black only.
Pls. suggest how to solve this problem.

Any help would be greatly appreciated .

Here's the code:

Expand|Select|Wrap|Line Numbers

 <html>
 
<head>

<script type="text/javascript">
 
function CreateExcelSheet()

{
 
var x=myTable.rows
 
var xls = new ActiveXObject("Excel.Application")

xls.visible = true

xls.Workbooks.Add

for (i = 0; i < x.length; i++)

{

var y = x[i].cells
 
for (j = 0; j < y.length; j++)

{

xls.Cells( i+1, j+1).Value = y[j].innerText

}

}
 
}

</script>
 
</head>
 
<body marginheight="0" marginwidth="0">

<form>

<input type="button" onclick="CreateExcelSheet()" value="Export to Excel !">

</form>

<table id="myTable" border="1">

 <tr>

        <td>Test</td>

<td><font color="red">Test</td>

<td>Test</td>

<td>Test</td>

<td>Test</td>

    </tr>
 
 <tr>

        <td>Test</td>

<td>Test</td>

<td>Test</td>

<td>Test</td>

<td>Test</td>

    </tr> 

<tr>

        <td>Test</td>

<td>Test</td>

<td>Test</td>

<td>Test</td>

<td>Test</td>

    </tr> 

<tr>

        <td>Test</td>

<td>Test</td>

<td>Test</td>

<td>Test</td>

<td>Test</td>

    </tr>

</table>
 
</body>

</html>

Nov 20 '09 #1

Subscribe Post Reply

2676

rnd me

427

Expert 256MB

a couple other tricks to try:

in head:

Expand|Select|Wrap|Line Numbers

  
    <style type="text/css">

            .green {color:green;}

        </style>

in table:

Expand|Select|Wrap|Line Numbers

  
<tr>

        <td>Test</td>

<td>Test</td>

<td class="green">Test</td>

<td style="color:blue">Test</td>

<td>Test</td>

    </tr>

Nov 21 '09 #2

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

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

problem with export data to excel. Helppppp

by: forumaic | last post by:

Hello, I am trying to export data to excel from datagrid, and I am getting an error: "The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>)." ...

C# / C Sharp

Export a query to Excel

by: Simon | last post by:

Dear reader, With the export command you can export a query to Excel. By activate this command a form pop's up with the following text:

Microsoft Access / VBA

Export To Excel - ASP.NET 1.1

by: JawzX01 | last post by:

Hello All, First, thank you for any help you can provide. I'm trying to do a simple export to excel. I've used the classic code that is all over the internet, and of course it worked without a...

ASP.NET

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

Export Gridview to excel

by: johnlim20088 | last post by:

Hi, Hi, currently I have a code below on my Listcontact.aspx file to export my gridview data to excel:- It is work success, and export the 'Contacts.xls' to my folder. But have following...

.NET Framework

save a flat export data file as an excel file

by: =?Utf-8?B?YzY3NjIyOA==?= | last post by:

Hi all, I have a question for you. I have a .csv file which has many lines of data. Each line has many data fields which are delimited by ",". Now I need to extract part of data from this...

ASP / Active Server Pages

Export to excel mutiple sheet

by: hemantbasva | last post by:

Note We need to have a template on server for generating report in multiple sheet as we do not had msoffice on server moreover this require a batch job to delete excel file created by the...

.NET Framework

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

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

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

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

The easy way to turn off automatic updates for Windows 10/11

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

Windows Server

How to Export to excel keeping text colour same ?

Similar topics