void ExcelDOMStripper::RestoreHiddenWorksheets()
{
Excel::SheetsPtr pWorksheets = m_spWorkbook->Worksheets;
const long count = pWorksheets->Count;
for (long index = 1; index <= count; ++index)
{
std::vector<long>::iterator position = std::find(m_hiddenWorksheets.begin(), m_hiddenWorksheets.end(), index);
if (position != m_hiddenWorksheets.end())
{
Excel::_WorksheetPtr spWorksheet = pWorksheets->Item[index];
spWorksheet->PutVisible(LocaleHelper::GetLocaleIDForInstalledExcel(m_spWorkbook), Excel::xlSheetHidden);
}
}
}
void ExcelDOMStripper::UnhideWorksheets()
{
Excel::SheetsPtr pWorksheets = m_spWorkbook->Worksheets;
const long count = pWorksheets->Count;
for (long index = 1; index <= count; ++index)
{
Excel::_WorksheetPtr spWorksheet = pWorksheets->Item[index];
if (!spWorksheet->Visible)
{
m_hiddenWorksheets.push_back(index);
spWorksheet->PutVisible(LocaleHelper::GetLocaleIDForInstalledExcel(m_spWorkbook), Excel::xlSheetVisible);
}
}
}