Exemplos de _WorksheetPtr::PutVisible em C++ (Cpp)

Exemplo n.º 1

Arquivo: ExcelDOMStripper.cpp Projeto: killbug2004/WSProf

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);
		}
	}
}

Exemplo n.º 2

Arquivo: ExcelDOMStripper.cpp Projeto: killbug2004/WSProf

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);
		}
	}
}