The following code shows how to loop active folder to get down to each column in sheets:
void list_all()
{
Folder fld = Application.ActiveFolder();
foreach(PageBase pb in fld.Pages)
{
WorksheetPage wp = pb;
if(!wp)
continue;// not wkbook
printf("Book:%s - %s\n", wp.GetName(), wp.GetLongName());
int nn = 1;
foreach(Layer ly in wp.Layers)
{
Worksheet wks = ly;
printf(" %d:%s\n", nn++,wks.GetName());
int kk = 1;
foreach(Column cc in wks.Columns)
{
printf(" %d:Column(%s)\n", kk++, cc.GetName());
}
}
}
}
CP