Android Question jexcel BackgroundColor RGB

[sigster]

Hi

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

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

 

[teddybear]

Hi

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

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

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.

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

 

[sigster]

Thanks

 

[sigster]

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

            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)

 

[sigster]

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