GetCell()

ExcelDataWorkbook::GetCell(int32_t, int32_t, int32_t) method

Retrieves a cell from the specified worksheet using its index and cell coordinates.

System::SharedPtr<IExcelDataCell> Aspose::Slides::Excel::ExcelDataWorkbook::GetCell(int32_t worksheetIndex, int32_t row, int32_t column) override

Arguments

Parameter	Type	Description
worksheetIndex	int32_t	Zero-based index of the worksheet.
row	int32_t	Zero-based row index of the cell.
column	int32_t	Zero-based column index of the cell.

Return Value

The cell at the specified location.

Remarks

Example:

System::SharedPtr<ExcelDataWorkbook> wb = System::MakeObject<ExcelDataWorkbook>(testFile);
System::SharedPtr<IExcelDataCell> cell = wb->GetCell(1, 1, 1);
System::Console::WriteLine(System::ObjectExt::ToString(cell->get_Value()));

ExcelDataWorkbook::GetCell(System::String, int32_t, int32_t) method

Retrieves a cell from the specified worksheet using its name and cell coordinates.

System::SharedPtr<IExcelDataCell> Aspose::Slides::Excel::ExcelDataWorkbook::GetCell(System::String worksheetName, int32_t row, int32_t column) override

Arguments

Parameter	Type	Description
worksheetName	System::String	The name of the worksheet.
row	int32_t	Zero-based row index of the cell.
column	int32_t	Zero-based column index of the cell.

Return Value

The cell at the specified location.

Remarks

Example:

System::SharedPtr<ExcelDataWorkbook> wb = System::MakeObject<ExcelDataWorkbook>(testFile);
System::SharedPtr<IExcelDataCell> cell = wb->GetCell(u"Sheet1", 1, 1);
System::Console::WriteLine(System::ObjectExt::ToString(cell->get_Value()));

ExcelDataWorkbook::GetCell(int32_t, System::String) method

Retrieves a cell from the specified worksheet using its index and Excel-style cell name (e.g., "B2").

System::SharedPtr<IExcelDataCell> Aspose::Slides::Excel::ExcelDataWorkbook::GetCell(int32_t worksheetIndex, System::String cellName) override

Arguments

Parameter	Type	Description
worksheetIndex	int32_t	Zero-based index of the worksheet.
cellName	System::String	The Excel-style cell reference (e.g., "A1", "C5").

Return Value

The cell at the specified location.

Remarks

Example:

System::SharedPtr<ExcelDataWorkbook> wb = System::MakeObject<ExcelDataWorkbook>(testFile);
System::SharedPtr<IExcelDataCell> cell = wb->GetCell(1, u"B2");
System::Console::WriteLine(System::ObjectExt::ToString(cell->get_Value()));

ExcelDataWorkbook::GetCell(System::String, System::String) method

Retrieves a cell from the specified worksheet using Excel-style cell name (e.g., "B2").

System::SharedPtr<IExcelDataCell> Aspose::Slides::Excel::ExcelDataWorkbook::GetCell(System::String worksheetName, System::String cellName) override

Arguments

Parameter	Type	Description
worksheetName	System::String	The name of the worksheet.
cellName	System::String	The Excel-style cell reference (e.g., "A1", "C5").

Return Value

The cell at the specified location.

Remarks

Example:

System::SharedPtr<ExcelDataWorkbook> wb = System::MakeObject<ExcelDataWorkbook>(testFile);
System::SharedPtr<IExcelDataCell> cell = wb->GetCell(u"Sheet1", u"B2");
System::Console::WriteLine(System::ObjectExt::ToString(cell->get_Value()));

See Also

• Typedef SharedPtr
• Class IExcelDataCell
• Class ExcelDataWorkbook
• Class String
• Namespace Aspose::Slides::Excel
• Library Aspose.Slides