You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Zsolt Koppany <zk...@intland.com> on 2009/03/13 19:30:45 UTC
How to convert characterRun.getColor() to RGB
Hi,
I would like display a word document in html. Actually the code works
more or less, I can even use font-names (using characterRun.getFontName()).
What does "characterRun.getColor()" return? How can I convert it to RGB?
Zsolt
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: How to convert characterRun.getColor() to RGB
Posted by Biju <bi...@gmail.com>.
Zsolt,
Did you check "characterRun.getColor()" gives RBG or not?
I think return value equals R*256*256 + B*256 + G
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: How to convert characterRun.getColor() to RGB
Posted by MSB <ma...@tiscali.co.uk>.
OK, I understand and you are quite correct about Linux and OLE - I believe it
is down to the those .dll's that Microsoft so loves - although there is an
exciting project called Wine that does offer the promise of bridging this
gap so to speak. At the moment it is not mature enough to use in a
production environment in my opinion.
Another option could be OpenOffice but I would have reservations. Whilst it
does do quite a good job of rendering Word documents, I cannot promise the
rendering of complex ones would be totally accurate. Furthermore, the UNO
interface is quite a challenge to master and there are problems using
OpenOffice as a document server in a distributed environment. Maybe it is
best to see if you could patch HWPF to expose the colour table as Nick
suggested.
Zsolt Koppany wrote:
>
> Hi,
>
> I would like display a word document in html. Actually the code works
> more or less, I can even use font-names (using
> characterRun.getFontName()).
>
> What does "characterRun.getColor()" return? How can I convert it to RGB?
>
> Zsolt
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/How-to-convert-characterRun.getColor%28%29-to-RGB-tp22502565p22558471.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: How to convert characterRun.getColor() to RGB
Posted by Amit Kumar <am...@cdac.in>.
MSB <markbrdsly <at> tiscali.co.uk> writes:
>
>
> Oh my, old age is really catching up with me now, I forgot about AbiWord
> until I was using a small notebook PC yesterday evening.
>
> If you have not yet committed to a specific direction for this project,
have
> a look at Abiword - http://www.abisource.com/. It is a small, free open
> source word processing package that can run under Windows, Linux, etc.
Able
> to read and write Word documents (.doc only, not .docx yet) it can be used
> for document conversions. The most interesting aspect from your point of
> view may be that AbiWord can perform these conversion when run from the
> command line. This article explains it quite well -
> http://opensource.weblogsinc.com/2005/06/29/use-abiword-to-convert-
filetypes-on-the-command-line/
>
> I do not now whether you need to download the AbiCommand plugin to support
> this sort of functionality but it would be easy ehough to test.
>
> Zsolt Koppany wrote:
> >
> > Hi,
> >
> > I would like display a word document in html. Actually the code works
> > more or less, I can even use font-names (using
> > characterRun.getFontName()).
> >
> > What does "characterRun.getColor()" return? How can I convert it to RGB?
> >
> > Zsolt
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: user-unsubscribe <at> poi.apache.org
> > For additional commands, e-mail: user-help <at> poi.apache.org
> >
> >
> >
>
Hii
The "characterRun.getColor()" returns an integer between 0 to 16.I also
messed with this.I found one color table in the
org.apache.poi.hwpf.usermodel.BorderCode. Am posting that color table here
as i have tested this also.
0 Auto
1 Black
2 Blue
3 Cyan
4 Green
5 Magenta
6 Red
7 Yellow
8 White
9 DkBlue
10 DkCyan
11 DkGreen
12 DkMagenta
13 DkRed
14 DkYellow
15 DkGray
16 LtGray
if you find further enhancement please post. Happy Coding :-)
------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: How to convert characterRun.getColor() to RGB
Posted by MSB <ma...@tiscali.co.uk>.
Oh my, old age is really catching up with me now, I forgot about AbiWord
until I was using a small notebook PC yesterday evening.
If you have not yet committed to a specific direction for this project, have
a look at Abiword - http://www.abisource.com/. It is a small, free open
source word processing package that can run under Windows, Linux, etc. Able
to read and write Word documents (.doc only, not .docx yet) it can be used
for document conversions. The most interesting aspect from your point of
view may be that AbiWord can perform these conversion when run from the
command line. This article explains it quite well -
http://opensource.weblogsinc.com/2005/06/29/use-abiword-to-convert-filetypes-on-the-command-line/
I do not now whether you need to download the AbiCommand plugin to support
this sort of functionality but it would be easy ehough to test.
Zsolt Koppany wrote:
>
> Hi,
>
> I would like display a word document in html. Actually the code works
> more or less, I can even use font-names (using
> characterRun.getFontName()).
>
> What does "characterRun.getColor()" return? How can I convert it to RGB?
>
> Zsolt
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/How-to-convert-characterRun.getColor%28%29-to-RGB-tp22502565p22573748.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: How to convert characterRun.getColor() to RGB
Posted by Nick Burch <ni...@torchbox.com>.
On Tue, 17 Mar 2009, Zsolt Koppany wrote:
> thank you for the info. We need a solution running also on Linux thus I
> think OLE/COM is not an option for us.
Your best bet then is probably to get the microsoft binary file format
documentation from the microsoft website, and discover where the data you
need is stored in the file. If you do and code it up, do please contribute
back a patch :)
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: How to convert characterRun.getColor() to RGB
Posted by Zsolt Koppany <zk...@intland.com>.
Hi MSB,
thank you for the info. We need a solution running also on Linux thus I
think OLE/COM is not an option for us.
Zsolt
MSB schrieb:
> Sorry it has been some time since you asked this question but, hopefully,
> this reply will still be of some use.
>
> I could be wrong but I believe that HWPF, unlike HSSF, does not yet expose
> the colour table associated with the application, Word in this case. So, you
> are able to get at the index of the colour but not to compare this to a
> table of colours and to - possibly - convert it into an RGB value. The
> option would be that indicated by the previous respondent; to map all of the
> colours in Word, convert them into RGB values and then encode this data
> within the application such that when HWPF returns an index number you are
> able to map from that to the RGB.
>
> Now, my next question may sound silly, but I do have a reason for asking it.
> Are you aware that you can use Word itself to convert a .doc file into html?
> Another question now, the application you are building with HWPF, is it to
> run on a stand alone PC or will it be deployed across a network? If the
> former, does that PC also run under Windows and does it have Word installed
> on it? If you are running stand alone on a Windows PC with Word installed
> then you could use the OLE/COM technique to grab a reference to an
> 'instance' of Word and use it to convert the files for you. There are
> libraries such as SWT and JACOB that will allow you to write Java code that
> will execute VBA commands and actually control Word itself. It really would
> be as simple as opening a file and then saving it as a version of itself
> converted into html.
>
>
>
> Zsolt Koppany wrote:
>> Hi,
>>
>> I would like display a word document in html. Actually the code works
>> more or less, I can even use font-names (using
>> characterRun.getFontName()).
>>
>> What does "characterRun.getColor()" return? How can I convert it to RGB?
>>
>> Zsolt
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>>
>>
>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: How to convert characterRun.getColor() to RGB
Posted by MSB <ma...@tiscali.co.uk>.
Sorry it has been some time since you asked this question but, hopefully,
this reply will still be of some use.
I could be wrong but I believe that HWPF, unlike HSSF, does not yet expose
the colour table associated with the application, Word in this case. So, you
are able to get at the index of the colour but not to compare this to a
table of colours and to - possibly - convert it into an RGB value. The
option would be that indicated by the previous respondent; to map all of the
colours in Word, convert them into RGB values and then encode this data
within the application such that when HWPF returns an index number you are
able to map from that to the RGB.
Now, my next question may sound silly, but I do have a reason for asking it.
Are you aware that you can use Word itself to convert a .doc file into html?
Another question now, the application you are building with HWPF, is it to
run on a stand alone PC or will it be deployed across a network? If the
former, does that PC also run under Windows and does it have Word installed
on it? If you are running stand alone on a Windows PC with Word installed
then you could use the OLE/COM technique to grab a reference to an
'instance' of Word and use it to convert the files for you. There are
libraries such as SWT and JACOB that will allow you to write Java code that
will execute VBA commands and actually control Word itself. It really would
be as simple as opening a file and then saving it as a version of itself
converted into html.
Zsolt Koppany wrote:
>
> Hi,
>
> I would like display a word document in html. Actually the code works
> more or less, I can even use font-names (using
> characterRun.getFontName()).
>
> What does "characterRun.getColor()" return? How can I convert it to RGB?
>
> Zsolt
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
--
View this message in context: http://www.nabble.com/How-to-convert-characterRun.getColor%28%29-to-RGB-tp22502565p22540061.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: How to convert characterRun.getColor() to RGB
Posted by Biju <bi...@gmail.com>.
My previous mail contain some VBA code and a HTML content.
First part of my mail explained how to generate that VBA code and HTML.
Now I will explain how you can use them to find equivalent html color
for a Excel colorIndex.
Method 1
1. Save the HTML content I send you to excel_color.html file.
2. open firefox
3. Install "Computed style" on your firefox toolbar from
https://www.squarefree.com/bookmarklets/webdevel.html
4. open excel_color.html in firefox
5. run "Computed style" bookmarklet by clicking it.
6. now you get a "cross" cursor.
7. click a cell you want know the RBG color code.
- say top left column
- which in excel is equvalent to A1
8. you see a new window opens and list CSS property
9. one of the CSS propery says "background-color: rgb(0, 0, 0)"
- now you got the RBG values
10. goto VBA code
11. then search for "A1"
12. you will reach following line
Range("A1").Select
With Selection.Interior
.ColorIndex = 1
.Pattern = xlSolid
End With
13. from that you can Identyfy the .ColorIndex = 1
Method 2.
1. Save the HTML content I send you to excel_color.html file.
2. open it in a note pad
3. Identify the HTML code which for a cell (say A1)
- In this case it is
<td height=17 class=xl223297 width=64
style='height:12.75pt;width:48pt'> </td>
4. Identify its class
in this case "xl223297"
5. search html file again for style definition of "xl223297"
- you see
.xl223297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:black;
mso-pattern:auto none;
white-space:nowrap;}
6. Identify CSS attribute for "background"
- here it is "background:black;"
7. Now find RBG from table at
http://www.w3.org/TR/css3-color/#svg-color
8. Now goto VBA code
9. Search for "A1"
- you reach
Range("A1").Select
With Selection.Interior
.ColorIndex = 1
.Pattern = xlSolid
End With
10. below that you see ".ColorIndex = 1"
- that is equvalent Excel color code.
On Sat, Mar 14, 2009 at 6:58 AM, Zsolt Koppany <zk...@intland.com> wrote:
> Hi Biju,
>
> sorry, I don't understand what you mean. Can you give me a hint?
>
> Zsolt
>
> Biju schrieb:
>>
>> I have generated Excel Macros while editing an excel sheet to add colors.
>> Then I save the sheet as HTML. You can compare VBA code and HTML to
>> find the conversion table.
>> For your convenience i am listing them done.
>>
>> To easily find color in html you can use "computed styles" bookmarklet
>> from
>> https://www.squarefree.com/bookmarklets/webdevel.html
>>
>>
>> PS: If I had some time I should done it in a better way.
>> ie use a VBA macro/POI code to produce excel sheet with color, for
>> colorIndex from 0 to max.
>> Then save the sheet as html. Then put a javascript code to find its RBG
>> value
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: How to convert characterRun.getColor() to RGB
Posted by Zsolt Koppany <zk...@intland.com>.
Hi Biju,
sorry, I don't understand what you mean. Can you give me a hint?
Zsolt
Biju schrieb:
> I have generated Excel Macros while editing an excel sheet to add colors.
> Then I save the sheet as HTML. You can compare VBA code and HTML to
> find the conversion table.
> For your convenience i am listing them done.
>
> To easily find color in html you can use "computed styles" bookmarklet from
> https://www.squarefree.com/bookmarklets/webdevel.html
>
>
> PS: If I had some time I should done it in a better way.
> ie use a VBA macro/POI code to produce excel sheet with color, for
> colorIndex from 0 to max.
> Then save the sheet as html. Then put a javascript code to find its RBG value
>
>
> ====== macro =====
>
> Option Explicit
>
> Sub Macro1()
> '
> ' Macro1 Macro
> ' Macro recorded 2009-03-13 by b
> '
>
> '
> Range("A1").Select
> With Selection.Interior
> .ColorIndex = 1
> .Pattern = xlSolid
> End With
> Range("A2").Select
> With Selection.Interior
> .ColorIndex = 9
> .Pattern = xlSolid
> End With
> Range("A3").Select
> With Selection.Interior
> .ColorIndex = 3
> .Pattern = xlSolid
> End With
> Range("A4").Select
> With Selection.Interior
> .ColorIndex = 7
> .Pattern = xlSolid
> End With
> Range("A5").Select
> With Selection.Interior
> .ColorIndex = 38
> .Pattern = xlSolid
> End With
> Range("B1").Select
> With Selection.Interior
> .ColorIndex = 53
> .Pattern = xlSolid
> End With
> Range("B2").Select
> With Selection.Interior
> .ColorIndex = 46
> .Pattern = xlSolid
> End With
> Range("B3").Select
> With Selection.Interior
> .ColorIndex = 45
> .Pattern = xlSolid
> End With
> Range("B4").Select
> With Selection.Interior
> .ColorIndex = 44
> .Pattern = xlSolid
> End With
> Range("B5").Select
> With Selection.Interior
> .ColorIndex = 40
> .Pattern = xlSolid
> End With
> Range("C1").Select
> With Selection.Interior
> .ColorIndex = 52
> .Pattern = xlSolid
> End With
> Range("C2").Select
> With Selection.Interior
> .ColorIndex = 12
> .Pattern = xlSolid
> End With
> Range("C3").Select
> With Selection.Interior
> .ColorIndex = 43
> .Pattern = xlSolid
> End With
> Range("C4").Select
> With Selection.Interior
> .ColorIndex = 6
> .Pattern = xlSolid
> End With
> Range("C5").Select
> With Selection.Interior
> .ColorIndex = 36
> .Pattern = xlSolid
> End With
>
> End Sub
> Sub Macro2()
> '
> ' Macro2 Macro
> ' Macro recorded 2009-03-13 by b
> '
>
> '
> Range("D1").Select
> Selection.Interior.ColorIndex = 51
> Range("D2").Select
> With Selection.Interior
> .ColorIndex = 10
> .Pattern = xlSolid
> End With
> Range("D3").Select
> With Selection.Interior
> .ColorIndex = 50
> .Pattern = xlSolid
> End With
> Range("D4").Select
> With Selection.Interior
> .ColorIndex = 4
> .Pattern = xlSolid
> End With
> Range("D5").Select
> With Selection.Interior
> .ColorIndex = 35
> .Pattern = xlSolid
> End With
> Range("E1").Select
> With Selection.Interior
> .ColorIndex = 49
> .Pattern = xlSolid
> End With
> Range("E2").Select
> With Selection.Interior
> .ColorIndex = 14
> .Pattern = xlSolid
> End With
> Range("E3").Select
> With Selection.Interior
> .ColorIndex = 42
> .Pattern = xlSolid
> End With
> Range("E4").Select
> With Selection.Interior
> .ColorIndex = 8
> .Pattern = xlSolid
> End With
> Range("E5").Select
> With Selection.Interior
> .ColorIndex = 34
> .Pattern = xlSolid
> End With
> Range("F1").Select
> With Selection.Interior
> .ColorIndex = 11
> .Pattern = xlSolid
> End With
> Range("F2").Select
> With Selection.Interior
> .ColorIndex = 5
> .Pattern = xlSolid
> End With
> Range("F3").Select
> With Selection.Interior
> .ColorIndex = 41
> .Pattern = xlSolid
> End With
> Range("F4").Select
> With Selection.Interior
> .ColorIndex = 33
> .Pattern = xlSolid
> End With
> Range("F5").Select
> With Selection.Interior
> .ColorIndex = 37
> .Pattern = xlSolid
> End With
> Range("G1").Select
> With Selection.Interior
> .ColorIndex = 55
> .Pattern = xlSolid
> End With
> Range("G2").Select
> With Selection.Interior
> .ColorIndex = 47
> .Pattern = xlSolid
> End With
> Range("G3").Select
> With Selection.Interior
> .ColorIndex = 13
> .Pattern = xlSolid
> End With
> Range("G4").Select
> With Selection.Interior
> .ColorIndex = 54
> .Pattern = xlSolid
> End With
> Range("G5").Select
> With Selection.Interior
> .ColorIndex = 39
> .Pattern = xlSolid
> End With
> Range("H1").Select
> With Selection.Interior
> .ColorIndex = 56
> .Pattern = xlSolid
> End With
> Range("H2").Select
> With Selection.Interior
> .ColorIndex = 16
> .Pattern = xlSolid
> End With
> Range("H3").Select
> With Selection.Interior
> .ColorIndex = 48
> .Pattern = xlSolid
> End With
> Range("H4").Select
> With Selection.Interior
> .ColorIndex = 15
> .Pattern = xlSolid
> End With
> Range("H5").Select
> With Selection.Interior
> .ColorIndex = 2
> .Pattern = xlSolid
> End With
> End Sub
>
> ====== html =====
>
> <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 9">
> <link rel=File-List href="./ColorPage_files/filelist.xml">
> <style id="Book1_3297_Styles">
> <!--table
> {mso-displayed-decimal-separator:"\.";
> mso-displayed-thousand-separator:"\,";}
> .xl153297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> mso-background-source:auto;
> mso-pattern:auto;
> white-space:nowrap;}
> .xl223297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:black;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl233297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:maroon;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl243297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:red;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl253297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:fuchsia;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl263297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#FF99CC;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl273297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#993300;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl283297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#FF6600;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl293297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#FF9900;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl303297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#FFCC00;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl313297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#FFCC99;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl323297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#333300;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl333297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:olive;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl343297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#99CC00;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl353297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:yellow;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl363297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#FFFF99;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl373297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#003300;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl383297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:green;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl393297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#339966;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl403297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:lime;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl413297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#CCFFCC;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl423297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#003366;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl433297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:teal;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl443297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#33CCCC;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl453297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:aqua;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl463297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#CCFFFF;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl473297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:navy;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl483297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:blue;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl493297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#3366FF;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl503297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#00CCFF;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl513297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#99CCFF;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl523297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#333399;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl533297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#666699;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl543297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:purple;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl553297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#993366;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl563297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#CC99FF;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl573297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#333333;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl583297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:gray;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl593297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:#969696;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl603297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:silver;
> mso-pattern:auto none;
> white-space:nowrap;}
> .xl613297
> {padding-top:1px;
> padding-right:1px;
> padding-left:1px;
> mso-ignore:padding;
> color:windowtext;
> font-size:10.0pt;
> font-weight:400;
> font-style:normal;
> text-decoration:none;
> font-family:Arial;
> mso-generic-font-family:auto;
> mso-font-charset:0;
> mso-number-format:General;
> text-align:general;
> vertical-align:bottom;
> background:white;
> mso-pattern:auto none;
> white-space:nowrap;}
> -->
> </style>
> </head>
>
> <body>
> <!--[if !excel]> <![endif]-->
> <!--The following information was generated by Microsoft Excel's Publish as Web
> Page wizard.-->
> <!--If the same item is republished from Excel, all information between the DIV
> tags will be replaced.-->
> <!----------------------------->
> <!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
>
> <!----------------------------->
>
> <div id="Book1_3297" align=center x:publishsource="Excel">
>
> <table x:str border=0 cellpadding=0 cellspacing=0 width=512
> style='border-collapse:
> collapse;table-layout:fixed;width:384pt'>
> <col width=64 span=8 style='width:48pt'>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl223297 width=64
> style='height:12.75pt;width:48pt'> </td>
> <td class=xl273297 width=64 style='width:48pt'> </td>
> <td class=xl323297 width=64 style='width:48pt'> </td>
> <td class=xl373297 width=64 style='width:48pt'> </td>
>
> <td class=xl423297 width=64 style='width:48pt'> </td>
> <td class=xl473297 width=64 style='width:48pt'> </td>
> <td class=xl523297 width=64 style='width:48pt'> </td>
> <td class=xl573297 width=64 style='width:48pt'> </td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl233297 style='height:12.75pt'> </td>
> <td class=xl283297> </td>
> <td class=xl333297> </td>
>
> <td class=xl383297> </td>
> <td class=xl433297> </td>
> <td class=xl483297> </td>
> <td class=xl533297> </td>
> <td class=xl583297> </td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl243297 style='height:12.75pt'> </td>
> <td class=xl293297> </td>
>
> <td class=xl343297> </td>
> <td class=xl393297> </td>
> <td class=xl443297> </td>
> <td class=xl493297> </td>
> <td class=xl543297> </td>
> <td class=xl593297> </td>
> </tr>
> <tr height=17 style='height:12.75pt'>
> <td height=17 class=xl253297 style='height:12.75pt'> </td>
>
> <td class=xl303297> </td>
> <td class=xl353297> </td>
> <td class=xl403297> </td>
> <td class=xl453297> </td>
> <td class=xl503297> </td>
> <td class=xl553297> </td>
> <td class=xl603297> </td>
> </tr>
> <tr height=17 style='height:12.75pt'>
>
> <td height=17 class=xl263297 style='height:12.75pt'> </td>
> <td class=xl313297> </td>
> <td class=xl363297> </td>
> <td class=xl413297> </td>
> <td class=xl463297> </td>
> <td class=xl513297> </td>
> <td class=xl563297> </td>
> <td class=xl613297> </td>
> </tr>
>
> <![if supportMisalignedColumns]>
> <tr height=0 style='display:none'>
> <td width=64 style='width:48pt'></td>
> <td width=64 style='width:48pt'></td>
> <td width=64 style='width:48pt'></td>
> <td width=64 style='width:48pt'></td>
> <td width=64 style='width:48pt'></td>
> <td width=64 style='width:48pt'></td>
> <td width=64 style='width:48pt'></td>
>
> <td width=64 style='width:48pt'></td>
> </tr>
> <![endif]>
> </table>
>
> </div>
>
>
> <!----------------------------->
> <!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
> <!----------------------------->
> </body>
>
> </html>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: How to convert characterRun.getColor() to RGB
Posted by Biju <bi...@gmail.com>.
I have generated Excel Macros while editing an excel sheet to add colors.
Then I save the sheet as HTML. You can compare VBA code and HTML to
find the conversion table.
For your convenience i am listing them done.
To easily find color in html you can use "computed styles" bookmarklet from
https://www.squarefree.com/bookmarklets/webdevel.html
PS: If I had some time I should done it in a better way.
ie use a VBA macro/POI code to produce excel sheet with color, for
colorIndex from 0 to max.
Then save the sheet as html. Then put a javascript code to find its RBG value
====== macro =====
Option Explicit
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 2009-03-13 by b
'
'
Range("A1").Select
With Selection.Interior
.ColorIndex = 1
.Pattern = xlSolid
End With
Range("A2").Select
With Selection.Interior
.ColorIndex = 9
.Pattern = xlSolid
End With
Range("A3").Select
With Selection.Interior
.ColorIndex = 3
.Pattern = xlSolid
End With
Range("A4").Select
With Selection.Interior
.ColorIndex = 7
.Pattern = xlSolid
End With
Range("A5").Select
With Selection.Interior
.ColorIndex = 38
.Pattern = xlSolid
End With
Range("B1").Select
With Selection.Interior
.ColorIndex = 53
.Pattern = xlSolid
End With
Range("B2").Select
With Selection.Interior
.ColorIndex = 46
.Pattern = xlSolid
End With
Range("B3").Select
With Selection.Interior
.ColorIndex = 45
.Pattern = xlSolid
End With
Range("B4").Select
With Selection.Interior
.ColorIndex = 44
.Pattern = xlSolid
End With
Range("B5").Select
With Selection.Interior
.ColorIndex = 40
.Pattern = xlSolid
End With
Range("C1").Select
With Selection.Interior
.ColorIndex = 52
.Pattern = xlSolid
End With
Range("C2").Select
With Selection.Interior
.ColorIndex = 12
.Pattern = xlSolid
End With
Range("C3").Select
With Selection.Interior
.ColorIndex = 43
.Pattern = xlSolid
End With
Range("C4").Select
With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
Range("C5").Select
With Selection.Interior
.ColorIndex = 36
.Pattern = xlSolid
End With
End Sub
Sub Macro2()
'
' Macro2 Macro
' Macro recorded 2009-03-13 by b
'
'
Range("D1").Select
Selection.Interior.ColorIndex = 51
Range("D2").Select
With Selection.Interior
.ColorIndex = 10
.Pattern = xlSolid
End With
Range("D3").Select
With Selection.Interior
.ColorIndex = 50
.Pattern = xlSolid
End With
Range("D4").Select
With Selection.Interior
.ColorIndex = 4
.Pattern = xlSolid
End With
Range("D5").Select
With Selection.Interior
.ColorIndex = 35
.Pattern = xlSolid
End With
Range("E1").Select
With Selection.Interior
.ColorIndex = 49
.Pattern = xlSolid
End With
Range("E2").Select
With Selection.Interior
.ColorIndex = 14
.Pattern = xlSolid
End With
Range("E3").Select
With Selection.Interior
.ColorIndex = 42
.Pattern = xlSolid
End With
Range("E4").Select
With Selection.Interior
.ColorIndex = 8
.Pattern = xlSolid
End With
Range("E5").Select
With Selection.Interior
.ColorIndex = 34
.Pattern = xlSolid
End With
Range("F1").Select
With Selection.Interior
.ColorIndex = 11
.Pattern = xlSolid
End With
Range("F2").Select
With Selection.Interior
.ColorIndex = 5
.Pattern = xlSolid
End With
Range("F3").Select
With Selection.Interior
.ColorIndex = 41
.Pattern = xlSolid
End With
Range("F4").Select
With Selection.Interior
.ColorIndex = 33
.Pattern = xlSolid
End With
Range("F5").Select
With Selection.Interior
.ColorIndex = 37
.Pattern = xlSolid
End With
Range("G1").Select
With Selection.Interior
.ColorIndex = 55
.Pattern = xlSolid
End With
Range("G2").Select
With Selection.Interior
.ColorIndex = 47
.Pattern = xlSolid
End With
Range("G3").Select
With Selection.Interior
.ColorIndex = 13
.Pattern = xlSolid
End With
Range("G4").Select
With Selection.Interior
.ColorIndex = 54
.Pattern = xlSolid
End With
Range("G5").Select
With Selection.Interior
.ColorIndex = 39
.Pattern = xlSolid
End With
Range("H1").Select
With Selection.Interior
.ColorIndex = 56
.Pattern = xlSolid
End With
Range("H2").Select
With Selection.Interior
.ColorIndex = 16
.Pattern = xlSolid
End With
Range("H3").Select
With Selection.Interior
.ColorIndex = 48
.Pattern = xlSolid
End With
Range("H4").Select
With Selection.Interior
.ColorIndex = 15
.Pattern = xlSolid
End With
Range("H5").Select
With Selection.Interior
.ColorIndex = 2
.Pattern = xlSolid
End With
End Sub
====== html =====
<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 9">
<link rel=File-List href="./ColorPage_files/filelist.xml">
<style id="Book1_3297_Styles">
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
.xl153297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
mso-background-source:auto;
mso-pattern:auto;
white-space:nowrap;}
.xl223297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:black;
mso-pattern:auto none;
white-space:nowrap;}
.xl233297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:maroon;
mso-pattern:auto none;
white-space:nowrap;}
.xl243297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:red;
mso-pattern:auto none;
white-space:nowrap;}
.xl253297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:fuchsia;
mso-pattern:auto none;
white-space:nowrap;}
.xl263297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#FF99CC;
mso-pattern:auto none;
white-space:nowrap;}
.xl273297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#993300;
mso-pattern:auto none;
white-space:nowrap;}
.xl283297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#FF6600;
mso-pattern:auto none;
white-space:nowrap;}
.xl293297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#FF9900;
mso-pattern:auto none;
white-space:nowrap;}
.xl303297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#FFCC00;
mso-pattern:auto none;
white-space:nowrap;}
.xl313297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#FFCC99;
mso-pattern:auto none;
white-space:nowrap;}
.xl323297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#333300;
mso-pattern:auto none;
white-space:nowrap;}
.xl333297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:olive;
mso-pattern:auto none;
white-space:nowrap;}
.xl343297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#99CC00;
mso-pattern:auto none;
white-space:nowrap;}
.xl353297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:yellow;
mso-pattern:auto none;
white-space:nowrap;}
.xl363297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#FFFF99;
mso-pattern:auto none;
white-space:nowrap;}
.xl373297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#003300;
mso-pattern:auto none;
white-space:nowrap;}
.xl383297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:green;
mso-pattern:auto none;
white-space:nowrap;}
.xl393297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#339966;
mso-pattern:auto none;
white-space:nowrap;}
.xl403297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:lime;
mso-pattern:auto none;
white-space:nowrap;}
.xl413297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#CCFFCC;
mso-pattern:auto none;
white-space:nowrap;}
.xl423297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#003366;
mso-pattern:auto none;
white-space:nowrap;}
.xl433297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:teal;
mso-pattern:auto none;
white-space:nowrap;}
.xl443297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#33CCCC;
mso-pattern:auto none;
white-space:nowrap;}
.xl453297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:aqua;
mso-pattern:auto none;
white-space:nowrap;}
.xl463297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#CCFFFF;
mso-pattern:auto none;
white-space:nowrap;}
.xl473297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:navy;
mso-pattern:auto none;
white-space:nowrap;}
.xl483297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:blue;
mso-pattern:auto none;
white-space:nowrap;}
.xl493297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#3366FF;
mso-pattern:auto none;
white-space:nowrap;}
.xl503297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#00CCFF;
mso-pattern:auto none;
white-space:nowrap;}
.xl513297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#99CCFF;
mso-pattern:auto none;
white-space:nowrap;}
.xl523297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#333399;
mso-pattern:auto none;
white-space:nowrap;}
.xl533297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#666699;
mso-pattern:auto none;
white-space:nowrap;}
.xl543297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:purple;
mso-pattern:auto none;
white-space:nowrap;}
.xl553297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#993366;
mso-pattern:auto none;
white-space:nowrap;}
.xl563297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#CC99FF;
mso-pattern:auto none;
white-space:nowrap;}
.xl573297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#333333;
mso-pattern:auto none;
white-space:nowrap;}
.xl583297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:gray;
mso-pattern:auto none;
white-space:nowrap;}
.xl593297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:#969696;
mso-pattern:auto none;
white-space:nowrap;}
.xl603297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:silver;
mso-pattern:auto none;
white-space:nowrap;}
.xl613297
{padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
color:windowtext;
font-size:10.0pt;
font-weight:400;
font-style:normal;
text-decoration:none;
font-family:Arial;
mso-generic-font-family:auto;
mso-font-charset:0;
mso-number-format:General;
text-align:general;
vertical-align:bottom;
background:white;
mso-pattern:auto none;
white-space:nowrap;}
-->
</style>
</head>
<body>
<!--[if !excel]> <![endif]-->
<!--The following information was generated by Microsoft Excel's Publish as Web
Page wizard.-->
<!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.-->
<!----------------------------->
<!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
<!----------------------------->
<div id="Book1_3297" align=center x:publishsource="Excel">
<table x:str border=0 cellpadding=0 cellspacing=0 width=512
style='border-collapse:
collapse;table-layout:fixed;width:384pt'>
<col width=64 span=8 style='width:48pt'>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl223297 width=64
style='height:12.75pt;width:48pt'> </td>
<td class=xl273297 width=64 style='width:48pt'> </td>
<td class=xl323297 width=64 style='width:48pt'> </td>
<td class=xl373297 width=64 style='width:48pt'> </td>
<td class=xl423297 width=64 style='width:48pt'> </td>
<td class=xl473297 width=64 style='width:48pt'> </td>
<td class=xl523297 width=64 style='width:48pt'> </td>
<td class=xl573297 width=64 style='width:48pt'> </td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl233297 style='height:12.75pt'> </td>
<td class=xl283297> </td>
<td class=xl333297> </td>
<td class=xl383297> </td>
<td class=xl433297> </td>
<td class=xl483297> </td>
<td class=xl533297> </td>
<td class=xl583297> </td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl243297 style='height:12.75pt'> </td>
<td class=xl293297> </td>
<td class=xl343297> </td>
<td class=xl393297> </td>
<td class=xl443297> </td>
<td class=xl493297> </td>
<td class=xl543297> </td>
<td class=xl593297> </td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl253297 style='height:12.75pt'> </td>
<td class=xl303297> </td>
<td class=xl353297> </td>
<td class=xl403297> </td>
<td class=xl453297> </td>
<td class=xl503297> </td>
<td class=xl553297> </td>
<td class=xl603297> </td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl263297 style='height:12.75pt'> </td>
<td class=xl313297> </td>
<td class=xl363297> </td>
<td class=xl413297> </td>
<td class=xl463297> </td>
<td class=xl513297> </td>
<td class=xl563297> </td>
<td class=xl613297> </td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
</tr>
<![endif]>
</table>
</div>
<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>
</html>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org