Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > XML > Not able to display color in excel not able to display color in excel using xml

Reply
Thread Tools

Not able to display color in excel not able to display color in excel using xml

 
 
sed_y sed_y is offline
Junior Member
Join Date: Jun 2011
Posts: 6
 
      02-15-2012
Hi, I have the following code for a text displayed in excel cell.

Code:
<style Halign="center" Valign="center" wrapText="true" includeAlign="true" includeFont="true" includeBorder="true">
    Pass_indicator
    <font  font="Arial" size="12" bold="true" italic="true" underline="None" Color = "Red" />
  </style>
When I Call this code from C# as
Code:
AddCellHeaderRowStyle_color(bool2str(PassFailStatusOverAll), 2, htBaseFormat, data);
where the function definition is as below
Code:
 private void AddCellHeaderRowStyle_color(string cellValue, int column, Hashtable htBaseFormat, ArrayList rowData)
{
    Hashtable htModifiedFormat = (Hashtable)htBaseFormat.Clone();
    htModifiedFormat[Common.COLUMNCOUNT] = column.ToString();
    htModifiedFormat[Common.ROWHEIGHT] = "36";
    htModifiedFormat[Common.STYLENAME] = "Pass_indicator";
    rowData.Add(cellValue);
    rowData.Add(htModifiedFormat);
}
in excel file, The text changes as I change the size, bold, italic attributes but not the color. I tried changing color to "#00FF00", putting it before other attributes but nothing works. .

Help needed please
sedy
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing font color from current font color to black color Kamaljeet Saini Ruby 0 02-13-2009 04:58 PM
Problem with Excel reports ::::Excel 2003 Migration To Excel 2007 =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= ASP .Net 15 10-24-2007 01:34 PM
Different results parsing a XML file with XML::Simple (XML::Sax vs. XML::Parser) Erik Wasser Perl Misc 5 03-05-2006 10:09 PM
not able to parse this xml , i wana use xml::simple preferably HP Perl Misc 9 01-02-2006 06:52 PM
Web service in .net not able to create Excel com object Nalina Vemparala via .NET 247 ASP .Net Web Services 3 05-21-2004 12:56 PM



Advertisments