Hi John. The following function examplifies how to delete the tenth row of each worksheet in the subfolders of root. I hope you will find it useful.
void test5172()
{
Folder fldRoot("/");
foreach (Folder sf in fldRoot.Subfolders) //loop over the subfolders of root folder
{
foreach (PageBase pg in sf.Pages) //loop over the pages in the subfolder
{
if (pg.GetType() == EXIST_WKS) //check if the page is an worksheet page
{
WorksheetPage wp(pg);
Worksheet wks(wp.Layers(0));
wks.DeleteRow(10); //delete the 10th row
}
}
}
}
Deanna
OriginLab Technical Services
