I have a Excel file with namedRange base on workbook and other on worksheet with same name !
My sample :
Sheet "2007" => Named "Year" : based on workbook
Sheet "2008" => Named "Year" : based on workwheet "2008"
Sheet "2009" => Named "Year" : based on workwheet "2009"
- Code: Select all
Console.WriteLine("2007");
Worksheet sheet2007 = workbook.Worksheets[0];
foreach (INamedRange namedRange in sheet2007.Names)
Console.WriteLine(namedRange.Name + " / " + namedRange.ValueR1C1);
Console.WriteLine("2008");
Worksheet sheet2008 = workbook.Worksheets[1];
foreach (INamedRange namedRange in sheet2008.Names)
Console.WriteLine(namedRange.Name + " / " + namedRange.ValueR1C1);
Console.WriteLine("2009");
Worksheet sheet2009 = workbook.Worksheets[2];
foreach (INamedRange namedRange in sheet2009.Names)
Console.WriteLine(namedRange.Name + " / " + namedRange.ValueR1C1);
Console.WriteLine("Total");
foreach (INamedRange namedRange in workbook.NameRanges)
Console.WriteLine(namedRange.Name + " / " + namedRange.ValueR1C1);
Console :
2007 // No namedRange on worksheet 2007 => Correct
2008
Year / '2008'!R2C2 // 1 namedRange on worksheet 2008 => Correct
2009
Year / '2009'!R2C2 // 1 namedRange on worksheet 2009 => Correct
Total
Year / '2008'!R2C2 // 1 namedRange on worksheet 2008 => Correct
Year / '2009'!R2C2 // 1 namedRange on worksheet 2009 => Correct
Year / '2008'!R2C2 // Incorrect => It most be '2007'!R2C2
When i browse workbook.NameRanges, i don't find namedRange "Year" on sheet "2007"
Do you have a bypass or a solution ?
I use SpireXLS 7.11.59.
Thanks