ShowOrHideImagesInColumn
(
Workbook workbook,
String worksheetName,
String imageColumnName,
Boolean show
)
{
Debug.Assert(workbook != null);
Debug.Assert( !String.IsNullOrEmpty(worksheetName) );
Debug.Assert( !String.IsNullOrEmpty(imageColumnName) );
Worksheet oWorksheet;
if ( !ExcelUtil.TryGetWorksheet(workbook, worksheetName,
out oWorksheet) )
{
return;
}
MsoTriState eVisible = show ?
MsoTriState.msoTrue : MsoTriState.msoFalse;
foreach (Microsoft.Office.Interop.Excel.Shape oImage in
GetImagesInColumn(oWorksheet, imageColumnName).Values)
{
oImage.Visible = eVisible;
}
}