How to Set Cell Data Formats

using IronXL;
using IronXL.Formatting;
using System;

// Create a new workbook and obtain the default worksheet
WorkBook workBook = WorkBook.Create();
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Set and format a percentage value
// The value 123 is set in cell A1 and formatted as "12300.00%"
workSheet["A1"].Value = 123;
// Format the value as a percentage with two decimal places
workSheet["A1"].FormatString = BuiltinFormats.Percent2;

// Set and format a numeric value with four decimal places
// The value 123 is set in cell A2 and formatted as "123.0000"
workSheet["A2"].Value = 123;
// Using a custom format string to display four decimal places
workSheet["A2"].FormatString = "0.0000";

// Set and format a range of date-time values
// Assign date-time values to multiple cells
DateTime dateValue = new DateTime(2020, 1, 1, 12, 12, 12);
workSheet["A3"].Value = dateValue; // Set date-time value at cell A3
workSheet["A4"].Value = new DateTime(2022, 3, 3, 10, 10, 10); // Set date-time value at cell A4
workSheet["A5"].Value = new DateTime(2021, 2, 2, 11, 11, 11); // Set date-time value at cell A5

// Define a range of cells containing date-time values
IronXL.Range range = workSheet["A3:A5"];

// Format the entire range to display date-time in "MM/dd/yyyy h:mm:ss" format
range.FormatString = "MM/dd/yyyy h:mm:ss";

// Save the workbook as an Excel file
workBook.SaveAs("dataFormats.xlsx");

// Note: Ensure that you have the IronXL library referenced in your project.

Imports IronXL

Imports IronXL.Formatting

Imports System



' Create a new workbook and obtain the default worksheet

Private workBook As WorkBook = WorkBook.Create()

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Set and format a percentage value

' The value 123 is set in cell A1 and formatted as "12300.00%"

Private workSheet("A1").Value = 123

' Format the value as a percentage with two decimal places

Private workSheet("A1").FormatString = BuiltinFormats.Percent2



' Set and format a numeric value with four decimal places

' The value 123 is set in cell A2 and formatted as "123.0000"

Private workSheet("A2").Value = 123

' Using a custom format string to display four decimal places

Private workSheet("A2").FormatString = "0.0000"



' Set and format a range of date-time values

' Assign date-time values to multiple cells

Private dateValue As New DateTime(2020, 1, 1, 12, 12, 12)

Private workSheet("A3").Value = dateValue ' Set date-time value at cell A3

Private workSheet("A4").Value = New DateTime(2022, 3, 3, 10, 10, 10) ' Set date-time value at cell A4

Private workSheet("A5").Value = New DateTime(2021, 2, 2, 11, 11, 11) ' Set date-time value at cell A5



' Define a range of cells containing date-time values

Private range As IronXL.Range = workSheet("A3:A5")



' Format the entire range to display date-time in "MM/dd/yyyy h:mm:ss" format

range.FormatString = "MM/dd/yyyy h:mm:ss"



' Save the workbook as an Excel file

workBook.SaveAs("dataFormats.xlsx")



' Note: Ensure that you have the IronXL library referenced in your project.

// The code assigns a string value to a cell in a worksheet.
// Assuming workSheet is an object of a type that supports cell operations
// with StringValue, such as a library class for handling spreadsheet files.
// This may typically be part of a library like EPPlus, ClosedXML, or similar.

try
{
    // Assign the value "4402-12" as a string to cell A1 in the worksheet.
    workSheet["A1"].Value = "4402-12"; // Assuming 'Value' is the correct property to set in the library being used.
}
catch (Exception e)
{
    // Log or handle exception if the operation fails
    Console.WriteLine($"An error occurred while assigning the cell value: {e.Message}");
}

// Note: We assumed the presence of a try-catch block for error handling. 
// The specific method/property to set a cell's value may vary depending on 
// the library in use. Please refer to the library documentation for specifics.

' The code assigns a string value to a cell in a worksheet.

' Assuming workSheet is an object of a type that supports cell operations

' with StringValue, such as a library class for handling spreadsheet files.

' This may typically be part of a library like EPPlus, ClosedXML, or similar.



Try

	' Assign the value "4402-12" as a string to cell A1 in the worksheet.

	workSheet("A1").Value = "4402-12" ' Assuming 'Value' is the correct property to set in the library being used.

Catch e As Exception

	' Log or handle exception if the operation fails

	Console.WriteLine($"An error occurred while assigning the cell value: {e.Message}")

End Try



' Note: We assumed the presence of a try-catch block for error handling. 

' The specific method/property to set a cell's value may vary depending on 

' the library in use. Please refer to the library documentation for specifics.

using IronXL; // Library for handling Excel files
using IronXL.Formatting; // Library for formatting Excel files

// Create a new workbook
WorkBook workBook = WorkBook.Create(ExcelFileFormat.XLSX);

// Access the default worksheet of the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Set the value of cell A1 to 123
workSheet["A1"].Value = 123;

// Apply the built-in Accounting format with zero decimal places to cell A1
workSheet["A1"].Style.NumberFormat = BuiltinFormats.Accounting0;

// Save the workbook to a file named "builtinDataFormats.xlsx"
workBook.SaveAs("builtinDataFormats.xlsx");

Imports IronXL ' Library for handling Excel files

Imports IronXL.Formatting ' Library for formatting Excel files



' Create a new workbook

Private workBook As WorkBook = WorkBook.Create(ExcelFileFormat.XLSX)



' Access the default worksheet of the workbook

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Set the value of cell A1 to 123

Private workSheet("A1").Value = 123



' Apply the built-in Accounting format with zero decimal places to cell A1

Private workSheet("A1").Style.NumberFormat = BuiltinFormats.Accounting0



' Save the workbook to a file named "builtinDataFormats.xlsx"

workBook.SaveAs("builtinDataFormats.xlsx")