C# Class Smrf.NodeXL.ExcelTemplate.TableImagePopulator

Object that populates an image column in an Excel table (ListObject) with images that have been stored in a temporary folder.
Call PopulateColumnWithImages to populate an image column. Call ShowOrHideImagesInColumn to hide or show the images. Call DeleteImagesInColumn to delete the images.

All methods are static.

Inheritance: Object
ファイルを表示 Open project: 2014-sed-team3/term-project

Public Methods

Method Description
DeleteImagesInColumn ( Workbook workbook, String worksheetName, String imageColumnName ) : void
PopulateColumnWithImages ( Workbook workbook, String worksheetName, String tableName, String imageColumnName, String keyColumnName, TemporaryImages temporaryImages ) : void
ShowOrHideImagesInColumn ( Workbook workbook, String worksheetName, String imageColumnName, System.Boolean show ) : void

Private Methods

Method Description
GetImageSizePt ( Size oImageSizePx, Workbook oWorkbook ) : SizeF
GetImagesInColumn ( Worksheet oWorksheet, String sImageColumnName ) : Microsoft.Office.Interop.Excel.Shape>.Dictionary
PopulateAreaWithImages ( Range oKeyColumnArea, Range oImageColumnArea, String sImageColumnName, SizeF oImageSizePt, Microsoft.Office.Interop.Excel.Shape>.Dictionary oOldImagesInColumn, TemporaryImages oTemporaryImages ) : void
TryGetImageColumnData ( ListObject oTable, String sImageColumnName, Range &oImageColumnData ) : System.Boolean

Method Details

DeleteImagesInColumn() public static method

public static DeleteImagesInColumn ( Workbook workbook, String worksheetName, String imageColumnName ) : void
workbook Workbook
worksheetName String
imageColumnName String
return void

PopulateColumnWithImages() public static method

public static PopulateColumnWithImages ( Workbook workbook, String worksheetName, String tableName, String imageColumnName, String keyColumnName, TemporaryImages temporaryImages ) : void
workbook Workbook
worksheetName String
tableName String
imageColumnName String
keyColumnName String
temporaryImages TemporaryImages
return void

ShowOrHideImagesInColumn() public static method

public static ShowOrHideImagesInColumn ( Workbook workbook, String worksheetName, String imageColumnName, System.Boolean show ) : void
workbook Workbook
worksheetName String
imageColumnName String
show System.Boolean
return void