CustomFormat for a specific cell

[lsouzaoliveira]

Hello guys, is it possible to format a cell inside the AddMapping method?

Thanks!

[mganss]

You can set the CustomFormat and BuiltinFormat properties on the ColumnInfo object returned by AddMapping(). Does that work for your use case?

[lsouzaoliveira]

It sets for the entire column, I have one column on the first 4 rows with years like (2021, 2022, 2023, 2024) and the next rows with numbers like ($123.213.123), when I use ColumnInfo approach it formats the year like ($2.001, $2.002...)

[mganss]

Try the SetCellUsing() method, see https://github.com/mganss/ExcelMapper?tab=readme-ov-file#custom-mapping. This allows you to style each individual cell.

[lsouzaoliveira]

I tried with CellStyle = new XSSFCellStyle() but I have no clue how to use it. That cell content is a formula.

_excelMapper.AddMapping<MyModel>("Bla", p => Bla) .SetCellUsing((c, o) => { switch (c.Row.RowNum) { case 6: c.SetCellValue("Total..."); break; case 7: c.CellFormula = GetTotal...Formula(); break; default: { if(o != null) { c.CellFormula = o.ToString(); } break; } } });

[mganss]

Here's the code that sets the default column format:

ExcelMapper/ExcelMapper/ColumnInfo.cs

Lines 283 to 298 in 681546d

	/// <summary>Sets the column style.</summary>
	/// <param name="sheet">The sheet.</param>
	/// <param name="columnIndex">Index of the column.</param>
	public void SetColumnStyle(ISheet sheet, int columnIndex)
	{
	if (BuiltinFormat != 0 || CustomFormat != null)
	{
	var wb = sheet.Workbook;
	var cs = wb.CreateCellStyle();
	if (CustomFormat != null)
	cs.DataFormat = wb.CreateDataFormat().GetFormat(CustomFormat);
	else
	cs.DataFormat = BuiltinFormat;
	sheet.SetDefaultColumnStyle(columnIndex, cs);
	}
	}

And here's an example on how to set cell color: #144 (comment)

Perhaps you can work from there.