This project has moved and is read-only. For the latest updates, please go here.

Help to use ExcelNamedRange with Excel 2007 template with named Cells..

Mar 22, 2012 at 3:06 PM
Edited Mar 22, 2012 at 3:07 PM

Hi guys,

I'm using a Excel template, inside this template i have some named cells that create a "table". (Table1 A1:F8)

When access the WorkSheet that contains these cells the property Names is empty.

 

ExcelWorksheet ws = wb.Worksheets["sheetName"];

using (ExcelNamedRange namedRange = ws.Names["Table1"])
{

}

 

Someone knows how to access the range of cells by the name?

 

 

Thanks for the help and sorry for the bad english.

Mar 22, 2012 at 8:49 PM

I've found the problem.

I had Named tables not named range of cells.

I've made a named range cells with the named table inside and worked.

 

Thanks.