Android Question jexcel BackgroundColor RGB

S

sigster

Active Member
Licensed User
Longtime User
Hi

is it poseble to change BackgroundColor using Colors.RGB(0, 255, 0)

cellFormat.BackgroundColor = cellFormat.COLOR_GREY_25_PERCENT:

Read / Write Excel files on Android

The Excel library is a new library that wraps the open source jexcel project and allows you to read or write Excel workbooks. This library supports XLS files. The new xml based format (xslx) is not supported. Setup - Download the attached library and copy both files to the libraries folder. -...
www.b4x.com

Sigster
 
Sort by date Sort by votes

teddybear

Well-Known Member
Licensed User
Yes, you can change BackgroundColor using RGB value, but you need to override the color member of the cellFormat using javaobject or convert RGB color to jxl.format.Color with inline java.

B4X: 
Dim j as javaobject = newWorkbook
j.runmethod("setColourRGB", Array(cellFormat.COLOR_GREY_25_PERCENT, 0, 255, 0))
cellFormat.BackgroundColor = cellFormat.COLOR_GREY_25_PERCENT
 
Upvote 0
S

sigster

Active Member
Licensed User
Longtime User
it don't change the color
how can I connect this java to = cell.SetCellFormat(rowsFormat)

B4X: 
            Dim j As JavaObject = newWorkbook
            j.runmethod("setColourRGB", Array(cellFormat.COLOR_GREY_25_PERCENT, 51, 51, 255))
            cellFormat.BackgroundColor = cellFormat.COLOR_GREY_25_PERCENT           
            
            cell.InitializeText(1, RowCount, colorcode)           
            sheet1.AddCell(cell)
            cell.SetCellFormat(rowsFormat)
 
Upvote 0
S

sigster

Active Member
Licensed User
Longtime User
Sorry I can change color
but I need to change RGB color inside Do While Crsr.NextRow when I get RGB color from the database
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Solved
Android Question MsgBox2Async in color?
Replies
5
Views
380
Zeev Goldstein
  • Question
Android Question file dialog background color
Replies
0
Views
169
giggetto71
P
Color selector application using B4XSeekBars and B4XFloatTextFields (B4A and B4J versions)
Replies
1
Views
878
PaulMeuris
P
S
  • Question
Android Question B4XComboBox Textcolor
Replies
2
Views
860
sigster
S
  • Question
Android Question xCustomListView backcolor
Replies
8
Views
999
yaniv hanya
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…