How can I format a column in Excel with OpenXml and C #?

Navigation
-1

Please, does anyone know how I can format a column in Excel with OpenXml and C #? I have an Excel file that has the predefined columns. This is filled with an SSIS, but I need to then format it with OpenXML and C # (required in this way).

    
asked by Celia 16.11.2017 в 20:49
source

1 answer

0

You can follow this example to do it link

and this would be the code to be able to format a cell in decimal 

var nformat4Decimal = new NumberingFormat
 {
  NumberFormatId = UInt32Value.FromUInt32(iExcelIndex++),
  FormatCode = StringValue.FromString("#,##0.0000")
  };
    
answered by 22.12.2017 / 15:55
source
How to change the class to a font awesome icon? Insert a sub-document into a Mongoose sub-document