Just to help you guys out, here is a more detilaed code to see what is going wrong.
This is the full code:
private void btnRemoveBadRefs_Click(object sender, EventArgs e)
{
if (File.Exists(tbExcelPath.Text))
{
Workbook book = new Workbook();
book.Open(tbExcelPath.Text);
foreach (Name namedRange in book.Worksheets.Names)
{
if (string.Compare(namedRange.RefersTo, “=#REF!”, false) == 0)
{
// Remove this range.
if (namedRange.GetRanges() == null) <<<<< This line causes the exception
continue;
Range[] ranges = namedRange.GetRanges();
foreach (Range curRange in ranges)
{
book.Worksheets.Names.Remove(curRange.Name);
}
}
else
Console.WriteLine(namedRange.RefersTo);
}
book.Save(tbExcelPath.Text + “1”, FileFormatType.Excel2003);
}
else
MessageBox.Show(“File not found”);
}
This the exception message:
Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
This is the exception:
at System.Collections.ArrayList.get_Item(Int32 index)
at Aspose.Cells.Worksheets.get_Item(Int32 index)
at ନ.Ⴖ.(Byte[] ଠ, Int32 ಪ, Int32 Ⴘ, Worksheets ೃ, Cells ື)
at Aspose.Cells.Name.GetRanges()
at Excel1.Form1.btnRemoveBadRefs_Click(Object sender, EventArgs e) in
The point in code where the exception originates has also been marked.
I am kind lost here, because my requirement is to remove invalid references and that is not happening because of this exception. Getting Clear() to work will not be of help to me because I need the valid references to remain.
thanks,
Sunil