Extract cells from Microsoft Office Excel spreadsheets Leave feedback
GroupDocs.Parser provides the functionality to extract cells from spreadsheets. The following methods are used for this purpose:
- GetWorksheetInfo() - returns the information about the worksheet
- GetWorksheetInfo(int) - returns the information about all worksheets in the spreadsheet
- GetWorksheetCells(int) - returns the collection of cells
- GetWorksheetCells(int, WorksheetOptions) - returns a collection of cells contained in set ranges.
Here are the steps to extract cells from Microsoft Office Excel spreadsheet:
- Instantiate Parser object for the initial spreadsheet;
- Call GetWorksheetCells(int) method and obtain the collection of objects;
- Iterate through the collection of WorksheetCell and get a cell text value.
The following example shows how to extract cells from Microsoft Office Excel spreadsheet.
// Create an instance of Parser class
using (Parser parser = new Parser(Constants.SampleXlsx))
{
// Check if worksheet cells extraction is supported
if (!parser.Features.Worksheet)
{
throw new NotSupportedException("Worksheet cells extraction isn't supported");
}
// Get the information about worksheets
IEnumerable<WorksheetInfo> info = parser.GetWorksheetInfo();
// Iterate over worksheet information
foreach(WorksheetInfo i in info)
{
// Print the worksheet name
Console.WriteLine(i.Name);
Console.WriteLine();
// Get the worksheet cells
IEnumerable<WorksheetCell> cells = parser.GetWorksheetCells(i.Index);
// Iterate over cells
foreach (WorksheetCell c in cells)
{
// Print the cell information and text value
Console.WriteLine($"Row: {c.RowIndex} Column: {c.ColumnIndex} RowSpan: {c.RowSpan} ColumnSpan: {c.ColumnSpan}");
Console.WriteLine(c.Text);
Console.WriteLine();
}
}
}
The following example shows how to extract cells from Microsoft Office Excel spreadsheet with customization:
// Create an instance of Parser class
using (Parser parser = new Parser(Constants.SampleXlsx))
{
// Check if worksheet cells extraction is supported
if (!parser.Features.Worksheet)
{
throw new NotSupportedException("Worksheet cells extraction isn't supported");
}
// Get the information about the first worksheet
WorksheetInfo info = parser.GetWorksheetInfo(0);
// Print the worksheet name
Console.WriteLine(info.Name);
Console.WriteLine();
// Create the range that represents the first two rows
WorksheetRange range = new WorksheetRange(
info.MinRowIndex,
Math.Min(info.MinRowIndex + 1, info.MaxRowIndex),
info.MinColumnIndex,
info.MaxColumnIndex);
// Get the worksheet cells from the first two rows
IEnumerable<WorksheetCell> cells = parser.GetWorksheetCells(0, new WorksheetOptions(range));
// Iterate over cells
foreach (WorksheetCell c in cells)
{
// Print the cell information and text value
Console.WriteLine($"Row: {c.RowIndex} Column: {c.ColumnIndex} RowSpan: {c.RowSpan} ColumnSpan: {c.ColumnSpan}");
Console.WriteLine(c.Text);
Console.WriteLine();
}
}
You may easily run the code above and see the feature in action in our GitHub examples:
Along with full featured .NET library we provide simple, but powerful free Apps.
You are welcome to parse documents and extract data from PDF, DOC, DOCX, PPT, PPTX, XLS, XLSX, Emails and more with our free online Free Online Document Parser App.
Was this page helpful?
Any additional feedback you'd like to share with us?
Please tell us how we can improve this page.
Thank you for your feedback!
We value your opinion. Your feedback will help us improve our documentation.
