public static void Run()
{
//Source directory
string sourceDir = RunExamples.Get_SourceDirectory();
// Create an instance of Workbook and load an existing spreadsheet
var book = new Workbook(sourceDir + "sampleDetectEmptyWorksheets.xlsx");
// Loop over all worksheets in the workbook
for (int i = 0; i < book.Worksheets.Count; i++)
{
Worksheet sheet = book.Worksheets[i];
// Check if worksheet has populated cells
if (sheet.Cells.MaxDataRow != -1)
{
Console.WriteLine(sheet.Name + " is not Empty because one or more Cells are Populated");
}
// Check if worksheet has shapes
else if (sheet.Shapes.Count > 0)
{
Console.WriteLine(sheet.Name + " is not Empty because there are one or more Shapes");
}
// Check if worksheet has empty initialized cells
else
{
Aspose.Cells.Range range = sheet.Cells.MaxDisplayRange;
var rangeIterator = range.GetEnumerator();
if (rangeIterator.MoveNext())
{
Console.WriteLine(sheet.Name + " is not Empty because one or more cells are Initialized");
}
}
}
Console.WriteLine("DetectEmptyWorksheets executed successfully.");
}
public static void Run()
{
// ExStart:DetectEmptyWorksheets
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Create an instance of Workbook and load an existing spreadsheet
var book = new Workbook(dataDir + "sample.xlsx");
// Loop over all worksheets in the workbook
for (int i = 0; i < book.Worksheets.Count; i++)
{
Worksheet sheet = book.Worksheets[i];
// Check if worksheet has populated cells
if (sheet.Cells.MaxDataRow != -1)
{
Console.WriteLine(sheet.Name + " is not empty because one or more cells are populated");
}
// Check if worksheet has shapes
else if (sheet.Shapes.Count > 0)
{
Console.WriteLine(sheet.Name + " is not empty because there are one or more shapes");
}
// Check if worksheet has empty initialized cells
else
{
Aspose.Cells.Range range = sheet.Cells.MaxDisplayRange;
var rangeIterator = range.GetEnumerator();
if (rangeIterator.MoveNext())
{
Console.WriteLine(sheet.Name + " is not empty because one or more cells are initialized");
}
}
}
// ExEnd:DetectEmptyWorksheets
}