rgba(255 is not a valid value for Int32

[danvic712]

I want to put an html string to a workbook cell (with some html element contains rgba in css style) ,and then I use HtmlString, but this operate throw a error about rgba(255 is not a valid value for Int32
The version I have using is Aspose.Cells 19.4.0

//Datatable data

for (int i = 0; i < rows; i++)
{
    for (int k = 0; k < columns; k++)
    {
        cells[1 + i, k].HtmlString = data.Rows[i][k].ToString();
        cells[1 + i, k].SetStyle(style);
    }
}       

[amjad-sahi]

I think you should debug your code closely for the datatable field value(s) if it is ok, the issue may lie there. I have tested using the following code with static HTML string, it works fine and I do not find any issue. See the sample code that I am using:
e.g
Sample code:

Workbook wb = new Workbook();

            Worksheet ws = wb.Worksheets[0];

            Cell cell = ws.Cells["B5"];
            cell.HtmlString = "<p>This is what a bio <span style=\"color:rgb(255, 0, 0)\">teacher </span>does....lots of <span style=\"background-color:rgb(255, 215, 0)\">stuff</span>.</p> <ol> <li>You must be smart</li> <li><a href=\"http://www.google.com\">Patient</a></li> <li>Can type&nbsp;</li> <li>other stuffs.</li> </ol>";

            wb.Save("e:\\test2\\out1.xlsx");

If you still could not evaluate or find the issue, kindly do provide sample code (runnable) same as above, you may use static string or create dynamic Dataset/datatable in code to remove any inter-dependencies for external data sources to show the issue, so we could execute your code precisely to consequently figure it out soon.

[danvic712]

@amjad-sahi
Hi, Here is my sample code, I tried html string which has rgb color model and that is fine , but when the html string has rgba color, and is still throw error

static void Main(string[] args)
{
    Workbook wb = new Workbook();
    Worksheet ws = wb.Worksheets[0];

    Cell cell = ws.Cells["B5"];
    cell.HtmlString = "<span style='background-color: rgba(255, 255, 255, 0.8);'>lalalalalala</span>";

    wb.Save(@"C:\Users\danvic.wang\Desktop\demo.xlsx");
}

[amjad-sahi]

@Lanesra712

Thanks for the code segment and screenshot with details.

After an initial test, I am able to observe the issue as you mentioned by using updated sample code. I found an exception "rgba(255 is not a valid value for Int32" when setting HTML string using rgba color model, it works fine if I use rgb instead:
e.g
Sample code:

Workbook wb = new Workbook();

 Worksheet ws = wb.Worksheets[0];

 Cell cell = ws.Cells["B5"];
//This works.            
//cell.HtmlString = "<p>This is what a bio <span style=\"color:rgb(255, 0, 0)\">teacher </span>does....lots of <span style=\"background-color:rgb(255, 215, 0)\">stuff</span>.</p> <ol> <li>You must be smart</li> <li><a href=\"http://www.google.com\">Patient</a></li> <li>Can type&nbsp;</li> <li>other stuffs.</li> </ol>";
//This does not work            
cell.HtmlString = "<span style='background-color: rgba(255, 255, 255, 0.8);'>lalalalalala</span>";

  wb.Save("e:\\test2\\out1.xlsx");

I have logged a ticket with an id "CELLSNET-46719" for your issue. We will look into it to figure it out soon. It is possible that we will share the fix which may fix your issue.

Once we have an update on it, we will let you know.

[danvic712]

@amjad-sahi
Thanks a lot 😄

[ahsaniqbalsidiqui]

@Lanesra712

This is to inform you that we have fixed your issue (logged earlier as “CELLSNET-46719”) now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

[danvic712]

@ahsaniqbalsidiqui
Thanks~~~

[ahsaniqbalsidiqui]

@Lanesra712
Please try our latest version/fix: Aspose.Cells for .NET v19.4.5 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells19.4.5 For .Net2_AuthenticodeSigned.Zip
Aspose.Cells19.4.5 For .Net4.0.Zip

[danvic712]

@ahsaniqbalsidiqui
Hi,thanks for hard working, I download it and add it to my demo project, unfortunately it seems still have this bug, here is my demo, thanks.
Demo address：aspose demo

[amjad-sahi]

@Lanesra712

Thanks for the demo project.

Please ignore our previous reply as the shared fix does not include your fix in it. We will share a hotfix in the next week (hopefully) which will figure out your issue.

Keep in touch.

[amjad-sahi]

@Lanesra712,

Please try our latest version/fix: Aspose.Cells for .NET v19.4.6 (attached)

Your issue should be fixed in it.

Let us know your feedback.
Aspose.Cells19.4.6 For .Net2_AuthenticodeSigned.Zip
Aspose.Cells19.4.6 For .Net4.0.Zip

[danvic712]

@amjad-sahi
Thanks for hard working, this issue has been resolved , thanks

[amjad-sahi]

@Lanesra712,

Good to know that your issue is resolved with the new fix/version. Feel free to contact us any time if you have further queries or issue, we will be happy to assist you soon.

[BinodPanditJH]

How i can do specific cell format using coding .please help

[amjad-sahi]

@BinodPanditJH,

See the following sample code on how to format (apply background color, change font with color and do alignment, etc.) a cell in the worksheet for your reference:
e.g.
Sample code:

//Create a new workbook
Workbook workbook = new Workbook();
//Get the first(default) worksheet in the workbook
Worksheet SheetReport = workbook.Worksheets[0];

//Get the A1 cell
Cell cell = SheetReport.Cells["A1"];
//Insert a value
cell.PutValue("testin..");
// Create and specify style object
Style cellStyle = new CellsFactory().CreateStyle();
cellStyle.HorizontalAlignment = TextAlignmentType.Left;
cellStyle.VerticalAlignment = TextAlignmentType.Center;
cellStyle.Pattern = BackgroundType.Solid;
cellStyle.ForegroundColor = Color.Red;
// Sets Cell style font attributes
cellStyle.Font.Name = "Arial";
cellStyle.Font.IsBold = true;
cellStyle.Font.Size = 12;
cellStyle.Font.Color = Color.Yellow;

// Apply the style to the cell
cell.SetStyle(cellStyle);

//Save the Excel file
workbook.Save("e:\\test2\\out1.xlsx");

Moreover, please see the documents with examples on Format Cells for your complete reference.

Should you have further queries or issue, feel free to contact us in dedicated forums.