Add Data in Cells

How to Add Data in Cells Using Aspose.Cells for .NET

Aspose.Cells provides a class, Workbook, that represents a Microsoft Excel file. The Workbook class contains a WorksheetCollection that allows access to each worksheet in the Excel file. A worksheet is represented by the Worksheet class. The Worksheet class provides a Cells collection. Each item in the Cells collection represents an object of the Cell class.

C#

 //Instantiating a Workbook object

Workbook workbook = new Workbook();

//Accessing the added worksheet in the Excel file

Worksheet worksheet = workbook.Worksheets[0];

int x = 1;

for (int i = 1; i <= 15; i++)
{
    for (int j = 0; j < 15; j++)
    {
        worksheet.Cells[i, j].Value = x++;
    }
}

workbook.Save("test.xlsx");

NPOI HSSF XSSF - Add Data in Cells

In NPOI, row.CreateCell(1).SetCellValue can be used to add data in cells.

C#

 IWorkbook workbook = new XSSFWorkbook();
ISheet sheet1 = workbook.CreateSheet("Sheet1");

sheet1.CreateRow(0).CreateCell(0).SetCellValue("This is a Sample");

int x = 1;

for (int i = 1; i <= 15; i++)
{
	IRow row = sheet1.CreateRow(i);
	for (int j = 0; j < 15; j++)
	{
		row.CreateCell(j).SetCellValue(x++);
	}
}

FileStream sw = File.Create("test.xlsx");
workbook.Write(sw);
sw.Close();

Download Running Code

Download Add Data in Cells from any of the below‑mentioned social coding sites:

Create New Workbook