EPPlus number format

by

Here are some number format options for EPPlus:

//integer (not really needed unless you need to round numbers, Excel will use default cell properties)
ws.Cells["A1:A25"].Style.Numberformat.Format = "0";

//integer without displaying the number 0 in the cell
ws.Cells["A1:A25"].Style.Numberformat.Format = "#";

//number with 1 decimal place
ws.Cells["A1:A25"].Style.Numberformat.Format = "0.0";

//number with 2 decimal places
ws.Cells["A1:A25"].Style.Numberformat.Format = "0.00";

//number with 2 decimal places and thousand separator
ws.Cells["A1:A25"].Style.Numberformat.Format = "#,##0.00";

//number with 2 decimal places and thousand separator and money symbol
ws.Cells["A1:A25"].Style.Numberformat.Format = "€#,##0.00";

//percentage (1 = 100%, 0.01 = 1%)
ws.Cells["A1:A25"].Style.Numberformat.Format = "0%";

//accounting number format
ws.Cells["A1:A25"].Style.Numberformat.Format = "_-$* #,##0.00_-;-$* #,##0.00_-;_-$* \"-\"??_-;_-@_-";

Don’t change the decimal and thousand separators to your own
localization. Excel will do that for you.

By request some DateTime formatting options.

//default DateTime pattern
worksheet.Cells["A1:A25"].Style.Numberformat.Format = DateTimeFormatInfo.CurrentInfo.ShortDatePattern;

//custom DateTime pattern
worksheet.Cells["A1:A25"].Style.Numberformat.Format = "dd-MM-yyyy HH:mm";

More Related Contents:

  1. Format excel column to decimal doing export from c#
  2. EPPlus – LoadFromCollection – Text converted to number
  3. Determine if a number can be made with prepicked numbers and times
  4. Reading Excel files from C#
  5. How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
  6. Could not find a part of the path … bin\roslyn\csc.exe
  7. export to Excel from a list with EPPLUS
  8. Import and Export Excel – What is the best library? [closed]
  9. How to write some data to excel file(.xlsx)
  10. How to call a VBScript file in a C# application?
  11. When using Trusted_Connection=true and SQL Server authentication, will this affect performance?
  12. How to export a JQgrid data to Excel using c#?
  13. Absolute path back to web-relative path
  14. ASP.NET MVC Global Variables
  15. how to convert NameValueCollection to JSON string?
  16. How to set attributes values using reflection
  17. How can I remove item from querystring in asp.net using c#?
  18. How do you bind an Enum to a DropDownList control in ASP.NET?
  19. No authenticationScheme was specified, and there was no DefaultChallengeScheme found with default authentification and custom authorization
  20. How to save workbook without showing save dialog with Excel interop?
  21. How can I handle forms authentication timeout exceptions in ASP.NET?
  22. MEF with MVC 4 or 5 – Pluggable Architecture (2014)
  23. How do I force full post-back from a button within an UpdatePanel?
  24. Multiples Table in DataReader
  25. ThreadStaticAttribute in ASP.NET
  26. Unable to find the requested .Net Framework Data Provider. It may not be installed
  27. Built-in helper to parse User.Identity.Name into Domain\Username
  28. Are static variables thread-safe? C#
  29. Can I reuse HttpWebRequest without disconnecting from the server?
  30. Get a list of weeks for a year – with dates

Leave a Comment