GroupDocsGists
10/24/2017 - 1:16 PM

Examples-CSharp-GroupDocs.Text.Examples.CSharp-ContentExtractor-ExtractSelectedColumnsAndRows.cs

// For complete examples and data files, please go to https://github.com/groupdocs-text/GroupDocs.Text-for-.NET
//get file actual path
String filePath = Common.getFilePath(fileName);
CellsTextExtractor extractor = new CellsTextExtractor(filePath);
int sheetIndex = 0;
CellsSheetInfo sheetInfo = extractor.GetSheetInfo(sheetIndex);
Console.WriteLine(sheetInfo.ExtractSheetHeader());
for (int rowIndex =2; rowIndex < sheetInfo.RowCount; rowIndex++)
{
    Console.WriteLine(sheetInfo.ExtractRow(rowIndex, "B1", "C1"));
}