How to set a cell's color to an RGB value in apache poi 4.0
0
The example here does not compile. setFillForegroundColor now seems to want an index, I can trick it to show specific colors, but trying any method at specifying an rgb value just creates a black cell.
Below is apache's own example which seems to be out of date with 4.0.
https://poi.apache.org/components/spreadsheet/quick-guide.html#CustomColors
XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet sheet = wb.createSheet();
XSSFRow row = sheet.createRow(0);
XSSFCell cell = row.createCell( 0);
cell.setCellValue("custom XSSF colors");
XSSFCellStyle style1 = wb.createCellStyle();
style1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128)));
style1.setFillPattern(FillPatternType.SOLID_FOREGROUND);
apache-poi
asked Nov 15 '18 at 20:28
Tom SwiftyTom Swifty
2,11511024
add a comment |
0
The example here does not compile. setFillForegroundColor now seems to want an index, I can trick it to show specific colors, but trying any method at specifying an rgb value just creates a black cell.
Below is apache's own example which seems to be out of date with 4.0.
https://poi.apache.org/components/spreadsheet/quick-guide.html#CustomColors
XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet sheet = wb.createSheet();
XSSFRow row = sheet.createRow(0);
XSSFCell cell = row.createCell( 0);
cell.setCellValue("custom XSSF colors");
XSSFCellStyle style1 = wb.createCellStyle();
style1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128)));
style1.setFillPattern(FillPatternType.SOLID_FOREGROUND);
apache-poi
asked Nov 15 '18 at 20:28
Tom SwiftyTom Swifty
2,11511024
3
trystyle1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128), new DefaultIndexedColorMap()));
– PJ Fanning
Nov 15 '18 at 21:17
1
duplicate of stackoverflow.com/questions/52357448/…
– PJ Fanning
Nov 15 '18 at 21:18
@PJ Fanning: What is thatnew DefaultIndexedColorMap()for? It is useless until now. So why not simplystyle1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128), null));? IfDefaultIndexedColorMapbecomes sense in further releases ofapache poicode must be changed anyway because of other changes. This was always the case after release changes until now.
– Axel Richter
Nov 16 '18 at 3:26
Thank you @PJFanning that did the trick perfectly. You are correct that this is an apparent duplicate, for some reason when I ran into that solution previously I could not get it to work, but I must have made a mistake because your specific example as well as theirs is working for me with the defaultindexedcolormap now.
– Tom Swifty
Nov 19 '18 at 15:19
Possible duplicate of Creating custom color styles for an XSSFWorkbook in Apache POI 4.0
– Tom Swifty
Nov 19 '18 at 15:19
add a comment |
0
0
0
The example here does not compile. setFillForegroundColor now seems to want an index, I can trick it to show specific colors, but trying any method at specifying an rgb value just creates a black cell.
Below is apache's own example which seems to be out of date with 4.0.
https://poi.apache.org/components/spreadsheet/quick-guide.html#CustomColors
XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet sheet = wb.createSheet();
XSSFRow row = sheet.createRow(0);
XSSFCell cell = row.createCell( 0);
cell.setCellValue("custom XSSF colors");
XSSFCellStyle style1 = wb.createCellStyle();
style1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128)));
style1.setFillPattern(FillPatternType.SOLID_FOREGROUND);
apache-poi
asked Nov 15 '18 at 20:28
Tom SwiftyTom Swifty
2,11511024
The example here does not compile. setFillForegroundColor now seems to want an index, I can trick it to show specific colors, but trying any method at specifying an rgb value just creates a black cell.
Below is apache's own example which seems to be out of date with 4.0.
https://poi.apache.org/components/spreadsheet/quick-guide.html#CustomColors
XSSFWorkbook wb = new XSSFWorkbook();
XSSFSheet sheet = wb.createSheet();
XSSFRow row = sheet.createRow(0);
XSSFCell cell = row.createCell( 0);
cell.setCellValue("custom XSSF colors");
XSSFCellStyle style1 = wb.createCellStyle();
style1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128)));
style1.setFillPattern(FillPatternType.SOLID_FOREGROUND);
apache-poi
apache-poi
asked Nov 15 '18 at 20:28
Tom SwiftyTom Swifty
2,11511024
asked Nov 15 '18 at 20:28
Tom SwiftyTom Swifty
2,11511024
asked Nov 15 '18 at 20:28
Tom SwiftyTom Swifty
2,11511024
asked Nov 15 '18 at 20:28
Tom SwiftyTom Swifty
2,11511024
asked Nov 15 '18 at 20:28
Tom SwiftyTom Swifty
2,11511024
2,11511024
3
trystyle1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128), new DefaultIndexedColorMap()));
– PJ Fanning
Nov 15 '18 at 21:17
1
duplicate of stackoverflow.com/questions/52357448/…
– PJ Fanning
Nov 15 '18 at 21:18
@PJ Fanning: What is thatnew DefaultIndexedColorMap()for? It is useless until now. So why not simplystyle1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128), null));? IfDefaultIndexedColorMapbecomes sense in further releases ofapache poicode must be changed anyway because of other changes. This was always the case after release changes until now.
– Axel Richter
Nov 16 '18 at 3:26
Thank you @PJFanning that did the trick perfectly. You are correct that this is an apparent duplicate, for some reason when I ran into that solution previously I could not get it to work, but I must have made a mistake because your specific example as well as theirs is working for me with the defaultindexedcolormap now.
– Tom Swifty
Nov 19 '18 at 15:19
Possible duplicate of Creating custom color styles for an XSSFWorkbook in Apache POI 4.0
– Tom Swifty
Nov 19 '18 at 15:19
add a comment |
3
trystyle1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128), new DefaultIndexedColorMap()));
– PJ Fanning
Nov 15 '18 at 21:17
1
duplicate of stackoverflow.com/questions/52357448/…
– PJ Fanning
Nov 15 '18 at 21:18
@PJ Fanning: What is thatnew DefaultIndexedColorMap()for? It is useless until now. So why not simplystyle1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128), null));? IfDefaultIndexedColorMapbecomes sense in further releases ofapache poicode must be changed anyway because of other changes. This was always the case after release changes until now.
– Axel Richter
Nov 16 '18 at 3:26
Thank you @PJFanning that did the trick perfectly. You are correct that this is an apparent duplicate, for some reason when I ran into that solution previously I could not get it to work, but I must have made a mistake because your specific example as well as theirs is working for me with the defaultindexedcolormap now.
– Tom Swifty
Nov 19 '18 at 15:19
Possible duplicate of Creating custom color styles for an XSSFWorkbook in Apache POI 4.0
– Tom Swifty
Nov 19 '18 at 15:19
3
3
try
style1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128), new DefaultIndexedColorMap()));– PJ Fanning
Nov 15 '18 at 21:17
try
style1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128), new DefaultIndexedColorMap()));– PJ Fanning
Nov 15 '18 at 21:17
1
1
duplicate of stackoverflow.com/questions/52357448/…
– PJ Fanning
Nov 15 '18 at 21:18
duplicate of stackoverflow.com/questions/52357448/…
– PJ Fanning
Nov 15 '18 at 21:18
@PJ Fanning: What is that
new DefaultIndexedColorMap() for? It is useless until now. So why not simply style1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128), null));? If DefaultIndexedColorMap becomes sense in further releases of apache poi code must be changed anyway because of other changes. This was always the case after release changes until now.– Axel Richter
Nov 16 '18 at 3:26
@PJ Fanning: What is that
new DefaultIndexedColorMap() for? It is useless until now. So why not simply style1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128), null));? If DefaultIndexedColorMap becomes sense in further releases of apache poi code must be changed anyway because of other changes. This was always the case after release changes until now.– Axel Richter
Nov 16 '18 at 3:26
Thank you @PJFanning that did the trick perfectly. You are correct that this is an apparent duplicate, for some reason when I ran into that solution previously I could not get it to work, but I must have made a mistake because your specific example as well as theirs is working for me with the defaultindexedcolormap now.
– Tom Swifty
Nov 19 '18 at 15:19
Thank you @PJFanning that did the trick perfectly. You are correct that this is an apparent duplicate, for some reason when I ran into that solution previously I could not get it to work, but I must have made a mistake because your specific example as well as theirs is working for me with the defaultindexedcolormap now.
– Tom Swifty
Nov 19 '18 at 15:19
Possible duplicate of Creating custom color styles for an XSSFWorkbook in Apache POI 4.0
– Tom Swifty
Nov 19 '18 at 15:19
Possible duplicate of Creating custom color styles for an XSSFWorkbook in Apache POI 4.0
– Tom Swifty
Nov 19 '18 at 15:19
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53327427%2fhow-to-set-a-cells-color-to-an-rgb-value-in-apache-poi-4-0%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53327427%2fhow-to-set-a-cells-color-to-an-rgb-value-in-apache-poi-4-0%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
3
try
style1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128), new DefaultIndexedColorMap()));– PJ Fanning
Nov 15 '18 at 21:17
1
duplicate of stackoverflow.com/questions/52357448/…
– PJ Fanning
Nov 15 '18 at 21:18
@PJ Fanning: What is that
new DefaultIndexedColorMap()for? It is useless until now. So why not simplystyle1.setFillForegroundColor(new XSSFColor(new java.awt.Color(128, 0, 128), null));? IfDefaultIndexedColorMapbecomes sense in further releases ofapache poicode must be changed anyway because of other changes. This was always the case after release changes until now.– Axel Richter
Nov 16 '18 at 3:26
Thank you @PJFanning that did the trick perfectly. You are correct that this is an apparent duplicate, for some reason when I ran into that solution previously I could not get it to work, but I must have made a mistake because your specific example as well as theirs is working for me with the defaultindexedcolormap now.
– Tom Swifty
Nov 19 '18 at 15:19
Possible duplicate of Creating custom color styles for an XSSFWorkbook in Apache POI 4.0
– Tom Swifty
Nov 19 '18 at 15:19