public void ReadAllContent() { WorkSheet sheet = GetFirstBooksSheet(); Console.WriteLine("Rows: {0}, Cols: {1}", sheet.Rows.Count, sheet.Columns.Count); sheet.Output(1, 1); }
public void ReadContentFromBookmark() { WorkSheet sheet = GetFirstBooksSheet(); Assert.IsNotNull(sheet.Names["Content"]); DefinedName bookmark = sheet.Names["Content"]; sheet.Output(bookmark.Address.StartRow, bookmark.Address.StartColumn); }
public void ReadTableContent() { WorkSheet sheet = GetTableSheet(); Table table = sheet.Tables["BooksTable"]; Assert.IsNotNull(table); table.OutputColumnsInfo(); sheet.Output(table.Address.StartRow, table.Address.StartColumn); }