ws is ActiveSheet
Shape picture = ws.Shapes.Item("Picture 1");
picture.Select(Type.Missing);
picture.OLEFormat.Object.PrintObject = false;
Showing posts with label VSTO. Show all posts
Showing posts with label VSTO. Show all posts
Wednesday, September 11, 2013
Friday, September 6, 2013
Excel VBA - VSTO Speed Up Speed Down Functions
Sub SpeedUp()
Application.EnableCancelKey = xlDisabled
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
End Sub
Sub SpeedDown()
Application.Calculation = xlCalculationAutomatic
Application.Calculate
Application.ScreenUpdating = True
Application.EnableCancelKey = xlInterrupt
End Sub
Application.EnableCancelKey = xlDisabled
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
End Sub
Sub SpeedDown()
Application.Calculation = xlCalculationAutomatic
Application.Calculate
Application.ScreenUpdating = True
Application.EnableCancelKey = xlInterrupt
End Sub
VSTO Ambiguity using Worksheet Activate
//Set Directive
using Excel = Microsoft.Office.Interop.Excel;
//Use as is in methods
((Excel._Worksheet)worksheet).Activate();
using Excel = Microsoft.Office.Interop.Excel;
//Use as is in methods
((Excel._Worksheet)worksheet).Activate();
Tuesday, June 11, 2013
VSTO - Microsoft Office Excel Ribbon Control Id / Name List
Control Name
FileNewDefault
FileOpen
FileSave
FileSendAsAttachment
FilePrintQuick
FilePrintPreview
Spelling
Undo
Redo
SortAscendingExcel
SortDescendingExcel
FileNew
FileOpen
UpgradeWorkbook
FileSave
FileSaveAsMenu
FileSaveAs
FileSaveAsExcelXlsx
FileSaveAsExcelXlsxMacro
FileSaveAsExcelXlsb
FileSaveAsExcel97_2003
AdvertisePublishAs
FileSaveAsPdfOrXps
FileSaveAsOtherFormats
FilePrintMenu
FilePrint
FilePrint
FilePrintQuick
FilePrintPreview
FilePrepareMenu
FileProperties
FileDocumentInspect
FileDocumentEncrypt
FilePermissionView
FilePermissionRestrictMenu
FilePermissionUnrestricted
FilePermissionDoNotDistribute
FilePermissionRestrictAs
FileAddDigitalSignature
FileViewDigitalSignatures
FileMarkAsFinal
FileCompatibilityChecker
FileLinksToFiles
FileSendMenu
FileSendAsAttachment
FileEmailAsPdfEmailAttachment
FileEmailAsXpsEmailAttachment
FileInternetFax
MenuPublish
FilePublishExcelServices
FileSaveToDocumentManagementServer
FileCreateDocumentWorkspace
FileServerTasksMenu
FileCheckIn
FileCheckOut
FileCheckOutDiscard
FileVersionHistory
FileWorkflowTasks
FileDocumentManagementInformation
FileExcelServicesOptions
FileStartWorkflow
FileClose
TabHome
GroupClipboard
PasteMenu
Paste
Paste
PasteFormulas
PasteValues
PasteNoBorders
PasteTranspose
PasteLink
PasteSpecialDialog
PasteAsHyperlink
PasteAsPictureMenu
CopyAsPicture
PasteAsPicture
PastePictureLink
Cut
Copy
FormatPainter
ShowClipboard
GroupFont
Font
FontSize
FontSizeIncrease
FontSizeDecrease
Bold
Italic
UnderlineGallery
Underline
UnderlineDouble
BordersGallery
BorderBottomNoToggle
BorderTopNoToggle
BorderLeftNoToggle
BorderRightNoToggle
BorderNone
BordersAll
BorderOutside
BorderThickOutside
BorderDoubleBottom
BorderThickBottom
BorderTopAndBottom
BorderTopAndThickBottom
BorderTopAndDoubleBottom
BorderDrawLine
BorderDrawGrid
BorderErase
BorderColorPickerExcel
BorderMoreColorsDialog
BorderStyle
BordersMoreDialog
CellFillColorPicker
FontShadingColorMoreColorsDialog
FontColorPicker
FontColorMoreColorsDialogExcel
PhoneticGuideMenu
PhoneticGuideFieldShow
PhoneticGuideFieldShow
PhoneticGuideEdit
PhoneticGuideSettings
FormatCellsFontDialog
GroupAlignmentExcel
AlignLeft
AlignCenter
AlignRight
IndentDecreaseExcel
IndentIncreaseExcel
AlignTopExcel
AlignMiddleExcel
AlignBottomExcel
OrientationMenu
TextOrientationAngleCounterclockwise
TextOrientationAngleClockwise
TextOrientationVertical
TextOrientationRotateUp
TextOrientationRotateDown
CellAlignmentOptions
AlignLeftToRightMenu
TextDirectionLeftToRight
TextDirectionRightToLeft
TextDirectionContext
WrapText
MergeCenterMenu
MergeCenter
MergeCenter
MergeCellsAcross
MergeCells
UnmergeCells
CellAlignmentOptions
GroupNumber
NumberFormatGallery
NumberFormatsDialog
AccountingFormatMenu
AccountingFormat
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatExcel
AccountingFormatMoreExcel
PercentStyle
CommaStyle
DecimalsIncrease
DecimalsDecrease
FormatCellsNumberDialog
GroupStyles
ConditionalFormattingMenu
ConditionalFormattingHighlightCellsMenu
ConditionalFormattingHighlightGreaterThan
ConditionalFormattingHighlightLessThan
ConditionalFormattingHighlightBetween
ConditionalFormattingHighlightEqualTo
ConditionalFormattingHighlightTextContaining
ConditionalFormattingHighlightDateOccuring
ConditionalFormattingHighlightDuplicateValues
ConditionalFormattingHighlightRulesMore
ConditionalFormattingTopBottomMenu
ConditionalFormattingTopNItems
ConditionalFormattingTopNPercent
ConditionalFormattingBottomNItems
ConditionalFormattingBottomNPercent
ConditionalFormattingAboveAverage
ConditionalFormattingBelowAverage
ConditionalFormattingTopBottomMore
ConditionalFormattingDataBarsGallery
ConditionalFormattingDataBarsMoreOptions
ConditionalFormattingColorScalesGallery
ConditionalFormattingColorScalesMore
ConditionalFormattingIconSetsGallery
ConditionalFormattingIconSetsMore
ConditionalFormattingNewRule
ConditionalFormattingClearMenu
ConditionalFormattingClearSelectedCells
ConditionalFormattingClearSheet
ConditionalFormattingClearTable
ConditionalFormattingClearPivotTable
ConditionalFormattingsManage
FormatAsTableGallery
TableStyleNew
PivotTableNewStyle
CellStylesGallery
CellStyleNew
CellStylesMerge
GroupCells
InsertCellstMenu
CellsInsertSmart
CellsInsertDialog
SheetRowsInsert
SheetColumnsInsert
TableRowsInsertAboveExcel
TableRowsInsertBelowExcel
TableColumnsInsertLeftExcel
TableColumnsInsertRightExcel
SheetInsert
TableDeleteRowsAndColumnsMenu
CellsDeleteSmart
CellsDelete
SheetRowsDelete
SheetColumnsDelete
TableRowsDeleteExcel
TableColumnsDeleteExcel
SheetDelete
FormatCellsMenu
RowHeight
RowHeightAutoFit
ColumnWidth
ColumnWidthAutoFit
ColumnWidthDefault
HideAndUnhideMenu
RowsHide
ColumnsHide
SheetHide
RowsUnhide
ColumnsUnhide
SheetUnhide
SheetRename
SheetMoveOrCopy
SheetTabColorGallery
SheetTabColorMoreColorsDialog
SheetProtect
Lock
FormatCellsDialog
GroupEditingExcel
AutoSumMenu
AutoSum
AutoSum
AutoSumAverage
AutoSumCount
AutoSumMax
AutoSumMin
AutoSumMoreFunctions
FillMenu
FillDown
FillRight
FillUp
FillLeft
FillAcrossWorksheets
FillSeries
FillJustify
ClearMenu
ClearAll
ClearFormats
ClearContents
ClearComments
SortFilterMenu
SortAscendingExcel
SortDescendingExcel
SortCustomExcel
Filter
SortClear
FilterReapply
SelectMenuExcel
FindDialogExcel
ReplaceDialog
GoTo
GoToSpecial
GoToFormulas
GoToComments
GoToConditionalFormatting
GoToConstants
GoToDataValidation
ObjectsSelect
SelectionPane
TabInsert
GroupInsertTablesExcel
PivotTableInsertMenu
PivotTableInsert
PivotTableInsert
PivotChartInsert
TableInsertExcel
GroupInsertIllustrations
PictureInsertFromFile
ClipArtInsert
ShapesInsertGallery
SmartArtInsert
GroupInsertChartsExcel
ChartTypeColumnInsertGallery
ChartTypeAllInsertDialog
ChartTypeLineInsertGallery
ChartTypeAllInsertDialog
ChartTypePieInsertGallery
ChartTypeAllInsertDialog
ChartTypeBarInsertGallery
ChartTypeAllInsertDialog
ChartTypeAreaInsertGallery
ChartTypeAllInsertDialog
ChartTypeXYScatterInsertGallery
ChartTypeAllInsertDialog
ChartTypeOtherInsertGallery
ChartTypeAllInsertDialog
ChartTypeAllInsertDialog
GroupInsertLinks
HyperlinkInsert
GroupInsertText
TextBoxInsertExcel
TextBoxInsertMenu
TextBoxInsertHorizontal
TextBoxInsertVertical
HeaderFooterInsert
WordArtInsertGallery
SignatureLineInsertMenu
SignatureLineInsert
SignatureLineMenuItemInsert
SignatureLineMenuItemInsert
SignatureLineMenuItemInsert
SignatureLineMenuItemInsert
SignatureLineMenuItemInsert
SignatureLineMenuItemInsert
SignatureLineMenuItemInsert
SignatureServicesAdd
OleObjectctInsert
SymbolInsert
GroupInsertBarcode
BarcodeInsert
LabelInsert
TabPageLayoutExcel
GroupThemesExcel
ThemesGallery
ThemeSearchOfficeOnline
ThemeBrowseForThemes
ThemeSaveCurrent
ThemeColorsGallery
ThemeColorsCreateNew
ThemeFontsGallery
ThemeFontsCreateNew
ThemeEffectsGallery
GroupPageSetup
PageMarginsGallery
MarginsCustomMargins
PageOrientationGallery
PageSizeGallery
PageSizeMorePaperSizesDialogExcel
PrintAreaMenu
PrintAreaSetPrintArea
PrintAreaClearPrintArea
PrintAreaAddToPrintArea
PageBreakMenu
PageBreakInsertExcel
PageBreakRemove
PageBreaksResetAll
SheetBackground
PrintTitles
PageSetupPageDialog
GroupPageLayoutScaleToFit
PageScaleToFitWidth
PageScaleToFitOptionsDialog
PageScaleToFitHeight
PageScaleToFitOptionsDialog
PageScaleToFitScale
PageSetupPageDialog
GroupPageLayoutSheetOptions
RightToLeftDocument
PageSetupSheetDialog
GroupArrange
ObjectBringToFrontMenu
ObjectBringToFront
ObjectBringToFront
ObjectBringForward
ObjectSendToBackMenu
ObjectSendToBack
ObjectSendToBack
ObjectSendBackward
SelectionPane
ObjectAlignMenu
ObjectsAlignLeft
ObjectsAlignCenterHorizontal
ObjectsAlignRight
ObjectsAlignTop
ObjectsAlignMiddleVertical
ObjectsAlignBottom
AlignDistributeHorizontallyClassic
AlignDistributeVerticallyClassic
SnapToGrid
SnapToShapes
ViewGridlinesToggleExcel
ObjectsGroupMenu
ObjectsGroup
ObjectsRegroup
ObjectsUngroup
ObjectRotateGallery
ObjectRotationOptionsDialog
TabFormulas
GroupFunctionLibrary
FunctionWizard
AutoSumMenu
AutoSum
AutoSum
AutoSumAverage
AutoSumCount
AutoSumMax
AutoSumMin
AutoSumMoreFunctions
FunctionsRecentlyUsedtInsertGallery
FunctionWizard
FunctionsFinancialInsertGallery
FunctionWizard
FunctionsLogicalInsertGallery
FunctionWizard
FunctionsTextInsertGallery
FunctionWizard
FunctionsDateTimeInsertGallery
FunctionWizard
FunctionsLookupReferenceInsertGallery
FunctionWizard
FunctionsMathTrigInsertGallery
FunctionWizard
FormulaMoreFunctionsMenu
FunctionsStatisticalInsertGallery
FunctionWizard
FunctionsEngineeringInsertGallery
FunctionWizard
FunctionsCubeInsertGallery
FunctionWizard
FunctionsInformationInsertGallery
FunctionWizard
GroupNamedCells
NameManager
NameDefineMenu
NameDefine
NameDefine
NamesApply
NameUseInFormula
NamePasteName
NameCreateFromSelection
GroupFormulaAuditing
TracePrecedents
TraceDependents
TraceRemoveArrowsMenu
TraceRemoveAllArrows
TraceRemoveAllArrows
TracePrecedentsRemoveArrows
TraceDependentRemoveArrows
ShowFormulas
ErrorCheckingMenu
ErrorChecking
ErrorChecking
TraceError
CircularReferences
FormulaEvaluate
WatchWindow
GroupCalculation
CalculationOptionsMenu
CalculationOptionsAutomatically
CalculationOptionsAutomaticallyExceptDataTables
CalculationOptionsManuallly
CalculateNow
CalculateSheet
TabData
GroupGetExternalData
GetExternalDataFromAccess
GetExternalDataFromWeb
GetExternalDataFromText
GetExternalDataFromOtherSources
GetExternalDataExistingConnections
GroupConnections
RefreshAllMenu
RefreshAll
RefreshAll
Refresh
RefreshStatus
RefreshCancel
ConnectionProperties
Connections
DataRangeProperties
EditLinks
GroupSortFilter
SortAscendingExcel
SortDescendingExcel
SortDialog
Filter
SortClear
FilterReapply
AdvancedFilterDialog
GroupDataTools
ConvertTextToTable
RemoveDuplicates
DataValidationMenu
DataValidation
DataValidation
DataValidationCircleInvalid
DataValidationClearValidationCircles
Consolidate
WhatIfAnalysisMenu
ScenarioManager
GoalSeek
DataTable
GroupOutline
OutlineGroupMenu
OutlineGroup
OutlineGroup
OutlineAuto
OutlineUngroupMenu
OutlineUngroup
OutlineUngroup
OutlineClear
OutlineSubtotals
OutlineShowDetail
OutlineHideDetail
OutlineSettings
TabReview
GroupProofing
Spelling
ResearchPane
Thesaurus
TranslationPane
HangulHanjaConversion
GroupComments
ReviewNewComment
ReviewDeleteComment
ReviewPreviousComment
ReviewNextComment
ReviewShowOrHideComment
ReviewShowAllComments
ReviewShowInk
GroupChangesExcel
SheetProtect
ReviewProtectWorkbook
ReviewProtectWorkbookMenu
ReviewRestrictEditing
FilePermissionUnrestricted
FilePermissionDoNotDistribute
FilePermissionRestrictAs
ReviewShareWorkbook
ReviewProtectAndShareWorkbook
ReviewAllowUsersToEditRanges
ReviewTrackChangesMenu
ReviewHighlightChanges
ReviewAcceptOrRejectChangeDialog
GroupInk
InkingStart
TabView
GroupWorkbookViews
ViewNormalViewExcel
ViewPageLayoutView
ViewPageBreakPreviewView
ViewCustomViews
ViewFullScreenView
GroupViewShowHide
ViewRulerExcel
GridlinesExcel
ViewMessageBar
ViewFormulaBar
ViewHeadings
ViewDocumentActionsPane
GroupZoom
ZoomDialog
ZoomCurrent100
ZoomToSelection
GroupWindow
WindowNew
WindowsArrangeAll
ViewFreezePanesGallery
WindowSplitToggle
WindowHide
WindowUnhide
ViewSideBySide
WindowSideBySideSynchronousScrolling
WindowResetPosition
WindowSaveWorkspace
WindowSwitchWindowsMenuExcel
WindowNameGoesHere
WindowNameGoesHere
WindowNameGoesHere
WindowNameGoesHere
WindowNameGoesHere
WindowNameGoesHere
WindowNameGoesHere
WindowNameGoesHere
WindowNameGoesHere
WindowNameGoesHere
GroupMacros
MenuMacros
PlayMacro
PlayMacro
MacroRecord
MacroRelativeReferences
TabDeveloper
GroupCode
VisualBasic
MacroPlay
MacroRecord
MacroRelativeReferences
MacroSecurity
GroupControls
ControlsGallery
DesignMode
ControlProperties
ViewCode
RunDialog
GroupXml
XmlSource
XmlMapProperties
XmlExpansionPacksExcel
XmlDataRefresh
XmlImport
XmlExport
GroupModify
DocumentPanelTemplate
TabAddIns
GroupAddInsMenuCommands
GroupAddInsToolbarCommands
GroupAddInsCustomToolbars
TabPrintPreview
GroupPrintPreviewPrint
FilePrint
PageSetupPageDialog
GroupPrintPreviewZoom
ZoomPrintPreviewExcel
GroupPrintPreviewPreview
PageNext
PagePrevious
MarginsShowHide
PrintPreviewClose
MdiChildSystemMenu
Help
WindowMinimize
WindowRestore
WindowClose
SplitCells
SortDialogClassic
ZoomClassic
FreezePanes
PivotTableReport
ShapeRectangle
PageBreakInsertOrRemove
EqualSign
SendCopySendToMailRecipient
Repeat
AutoFilterClassic
AutoFormatDialog
GetExternalDataImportClassic
ShapeOval
BrightnessMore
ContrastMore
LightShading
AddInManager
StylesDialogClassic
EditQuery
PasteFormatting
FilePermission
PropertySheet
ContrastLess
Strikethrough
BrightnessLess
FileSaveAsWebPage
AlignJustify
DataFormExcel
TableSelectVisibleCells
BorderBottom
ObjectRotateLeft90
Camera
ShapeElbowConnectorArrow
ShapeStraightConnectorArrow
ObjectSetShapeDefaults
ShapeFreeform
ShapeCurve
ParagraphDistributed
PlusSign
DatabaseQueryNew
BorderTop
BorderLeft
BorderRight
ShapeStraightConnector
ShapeRoundedRectangularCallout
Calculator
MinusSign
ActiveXButton
FormControlButton
ShapeRightBrace
WebPagePreview
BorderInsideHorizontal
ZoomOut
SpeakCells
ZoomIn
BorderInside
ShapeRoundedRectangle
DarkShading
SelectCurrentRegion
DivisionSign
ShapeArc
ObjectFlipHorizontal
MultiplicationSign
BorderInsideVertical
CheckForUpdates
SpeakStop
ShapeRightArrow
ShapeScribble
ReviewSendForReview
WebGoBack
ObjectRotateFree
ShapeLeftBrace
WordArtVerticalText
ObjectNudgeLeft
ShapeDownArrow
FormControlListBox
ParenthesisRight
ParenthesisLeft
FormControlComboBox
OutlookTaskCreate
ObjectRotateRight90
ListSynchronize
ReviewReplyWithChanges
_3DSurfaceMaterialClassic
_3DSurfaceWireFrameClassic
_3DSurfaceMatteClassic
_3DSurfacePlasticClassic
_3DSurfaceMetalClassic
ShapeElbowConnector
FormControlRadioButton
FormControlCheckBox
ActiveXCheckBox
BorderDiagonalUp
ShapeIsoscelesTriangle
FileUpdate
PrivacyOptionsDialog
ObjectNudgeDown
ObjectNudgeRight
ObjectFlipVertical
FormControlSpinner
ActiveXComboBox
VerticallyDistributed
StyleGalleryClassic
SpeakOnEnter
ActiveXTextBox
FormControlLabel
ActiveXListBox
MoreControlsDialog
FormControlGroupBox
ChangesDiscardAndRefresh
FormControlScrollBar
ObjectNudgeUp
ActiveXImage
ActiveXLabel
DocumentLocation
ActiveXSpinButton
ActiveXRadioButton
FileCloseAll
ContactUs
WebGoForward
BorderDiagonalDown
QueryParameters
DollarSign
ShapeStar
ActiveXScrollBar
ObjectsMultiSelect
ReviewEndReview
ExchangeFolder
OutlineSymbolsShowHide
SpeakByRows
SpeakByColumns
SelectAll
ReadOnly
TabOrder
ActiveXToggleButton
FormControlCombinationDropDownEdit
CodeEdit
CompareAndMergeWorkbooks
ExponentiationSign
PrintListRange
FormControlEditBox
PercentSign
FormControlCombinationListEdit
CommaSign
DrawingCanvasExpand
SendCopySendNow
DrawingCanvasFit
ScenarioGallery
FilePublishAsWebPage
InkCopyAsText
ColonSign
ConstrainNumeric
ComAddInsDialog
WebOptionsDialog
CalculateFull
SendCopySelectNames
DrawingCanvasResize
FontColorCycle
ChartInsert
CombineCharacters
BulletsAndNumberingBulletsDialog
QuickAccessToolbarCustomization
AlternativeText
AdvancedFileProperties
Group3DEffects
_3DEffectsGalleryClassic
_3DEffectColorPickerClassic
_3DEffectColorPickerMoreClassic
_3DExtrusionDepthGalleryClassic
_3DDirectionGalleryClassic
_3DExtrusionPerspectiveClassic
_3DExtrusionParallelClassic
_3DLightingGalleryClassic
_3DLightingFlatClassic
_3DLightingNormalClassic
_3DLightingDimClassic
_3DSurfaceMaterialGalleryClassic
_3DTiltLeftClassic
_3DTiltUpClassic
_3DEffectsOnOffClassic
_3DTiltDownClassic
_3DTiltRightClassic
GroupShadowEffects
ShadowStyleGalleryClassic
ShadowColorPickerClassic
ShadowSemitransparentClassic
ObjectShadowColorMoreColorsDialog
ShadowNudgeLeftClassic
ShadowNudgeUpClassic
ShadowOnOrOffClassic
ShadowNudgeDownClassic
ShadowNudgeRightClassic
GroupDrawBorders
BorderStyle
BorderColorPickerExcel
BorderMoreColorsDialog
BorderDrawMenu
BorderDrawLine
BorderDrawGrid
BorderErase
TabSetSmartArtTools
TabSmartArtToolsDesign
GroupSmartArtCreateGraphic
SmartArtAddShapeSplitMenu
SmartArtAddShape
SmartArtAddShapeAfter
SmartArtAddShapeBefore
SmartArtAddShapeAbove
SmartArtAddShapeBelow
SmartArtAddAssistant
SmartArtAddBullet
SmartArtRightToLeft
SmartArtOrganizationChartMenu
SmartArtOrganizationChartStandard
SmartArtOrganizationChartBoth
SmartArtOrganizationChartLeftHanging
SmartArtOrganizationChartRightHanging
SmartArtPromote
SmartArtDemote
SmartArtTextPane
GroupSmartArtLayouts
SmartArtLayoutGallery
SmartArtMoreLayoutsDialog
GroupSmartArtQuickStyles
SmartArtChangeColorsGallery
SmartArtStylesGallery
GroupSmartArtReset
SmartArtResetGraphic
TabSmartArtToolsFormat
GroupSmartArtShapes
SmartArtEditIn2D
ShapeChangeShapeGallery
SmartArtLargerShape
SmartArtSmallerShape
GroupShapeStyles
ShapeStylesGallery
ShapeStylesOtherThemeFillsGallery
ShapeFillColorPicker
ObjectFillMoreColorsDialog
ObjectPictureFill
GradientGallery
ShapeFillMoreGradientsDialog
ShapeFillTextureGallery
MoreTextureOptions
ShapeOutlineColorPicker
ObjectBorderOutlineColorMoreColorsDialog
OutlineWeightGallery
LineStylesDialog
OutlineDashesGallery
LineStylesDialog
ArrowStyleGallery
ArrowsMore
ShapeEffectsMenu
ObjectEffectPresetGallery
_3DBevelOptionsDialog
ObjectEffectShadowGallery
ShadowOptionsDialog
ReflectionGallery
ObjectEffectGlowGallery
GlowColorPicker
GlowColorMoreColorsDialog
ObjectEffectSoftEdgesGallery
BevelShapeGallery
_3DBevelOptionsDialog
_3DRotationGallery
_3DRotationOptionsDialog
ObjectFormatDialog
GroupWordArtStyles
TextStylesGallery
WordArtClear
TextFillColorPicker
TextFillColorMoreColorsDialog
TextPictureFill
TextFillGradientGallery
TextFillMoreGradientsDialog
TextFillTextureGallery
TextFillMoreTextures
TextOutlineColorPicker
TextOutlineColorMoreColorsDialog
TextOutlineWeightGallery
TextOutlineMoreLinesDialog
TextOutlineDashesGallery
TextOutlineMoreLinesDialog
TextEffectsMenu
TextEffectShadowGallery
TextEffectsMoreShadowsDialog
TextReflectionGallery
TextEffectGlowGallery
TextGlowColorPicker
TextGlowColorMoreColorsDialog
BevelTextGallery
TextEffectsBevelMore3DOptionsDialog
TextEffects3DRotationGallery
TextEffects3DRotationOptionsDialog
TextEffectTransformGallery
WordArtFormatDialog
GroupArrange
ObjectBringToFrontMenu
ObjectBringToFront
ObjectBringToFront
ObjectBringForward
ObjectSendToBackMenu
ObjectSendToBack
ObjectSendToBack
ObjectSendBackward
SelectionPane
ObjectAlignMenu
ObjectsAlignLeft
ObjectsAlignCenterHorizontal
ObjectsAlignRight
ObjectsAlignTop
ObjectsAlignMiddleVertical
ObjectsAlignBottom
AlignDistributeHorizontallyClassic
AlignDistributeVerticallyClassic
SnapToGrid
SnapToShapes
ViewGridlinesToggleExcel
ObjectsGroupMenu
ObjectsGroup
ObjectsRegroup
ObjectsUngroup
ObjectRotateGallery
ObjectRotationOptionsDialog
GroupSmartArtSize
ShapeHeight
ShapeWidth
TabSetChartTools
TabChartToolsDesign
GroupChartType
ChartChangeType
ChartSaveTemplates
GroupChartData
ChartSwitchRowColumn
ChartEditDataSource
GroupChartLayouts
ChartLayoutGallery
GroupChartStyles
ChartStylesGallery
GroupChartLocation
ChartPlacement
TabChartToolsLayout
GroupChartCurrentSelection
ChartElementSelector
ChartFormatSelection
ChartResetToMatchStyle
GroupChartShapes
PictureInsertFromFile
ShapesInsertGallery
TextBoxInsertExcel
TextBoxInsertMenu
TextBoxInsertHorizontal
TextBoxInsertVertical
GroupChartLabels
ChartTitle
ChartTitleOptionsDialog
ChartAxisTitles
ChartPrimaryHorizontalAxisTitle
ChartPrimaryHorizontalAxisTitleOptionsDialog
ChartPrimaryVerticalAxisTitle
ChartPrimaryVerticalAxisTitleOptionsDialog
ChartSecondaryHorizontalAxisTitle
ChartSecondaryHorizontalAxisTitleOptionsDialog
ChartSecondaryVerticalAxisTitle
ChartSecondaryVerticalAxisTitleOptionsDialog
ChartDepthAxisTitle
ChartDepthAxisTitleOptionsDialog
ChartLegend
ChartLegendOptionsDialogDialog
ChartDataLabel
ChartDataLabelDialog
ChartDataTable
ChartDataTableOptionsDialog
GroupChartAxes
ChartAxes
ChartPrimaryHorizontalAxis
ChartPrimaryHorizontalAxisOptionsDialog
ChartPrimaryVerticalAxis
ChartPrimaryVerticalAxisOptionsDialog
ChartSecondaryHorizontalAxis
ChartSecondaryHorizontalAxisOption
ChartSecondaryVerticalAxis
ChartSecondaryVerticalAxisOptionsDialog
ChartDepthAxis
ChartDepthAxisOptionsDialog
ChartGridlines
ChartPrimaryHorizontalGridlines
ChartPrimaryHorizontalGridlinesOptionsDialog
ChartPrimaryVerticalGridlines
ChartPrimaryVerticalGridlinesOptionsDialog
ChartSecondaryHorizontalGridlines
ChartSecondaryHorizontalGridlinesOptionsDialog
ChartSecondaryVerticalGridlines
ChartSecondaryVerticalGridlinesOptionsDialog
ChartDepthGridlines
ChartDepthGridlinesOptionsDialog
GroupChartBackground
ChartPlotArea
ChartPlotAreaOptionsDialog
ChartWall
ChartWallOptionsDialog
ChartFloor
ChartFloorOptionsDialog
Chart3DView
GroupChartAnalysis
ChartTrendline
ChartTrendlineOptionsDialog
ChartLines
ChartUpDownBars
ChartUpDownBarsOptionsDialog
ChartErrorBars
ChartErrorBarsOptionsDialog
GroupChartProperties
ChartNameLabel
ChartName
TabChartToolsFormat
GroupChartCurrentSelection
ChartElementSelector
ChartFormatSelection
ChartResetToMatchStyle
GroupShapeStyles
ShapeStylesGallery
ShapeStylesOtherThemeFillsGallery
ShapeFillColorPicker
ObjectFillMoreColorsDialog
ObjectPictureFill
GradientGallery
ShapeFillMoreGradientsDialog
ShapeFillTextureGallery
MoreTextureOptions
ShapeOutlineColorPicker
ObjectBorderOutlineColorMoreColorsDialog
OutlineWeightGallery
LineStylesDialog
OutlineDashesGallery
LineStylesDialog
ArrowStyleGallery
ArrowsMore
ShapeEffectsMenu
ObjectEffectPresetGallery
_3DBevelOptionsDialog
ObjectEffectShadowGallery
ShadowOptionsDialog
ReflectionGallery
ObjectEffectGlowGallery
GlowColorPicker
GlowColorMoreColorsDialog
ObjectEffectSoftEdgesGallery
BevelShapeGallery
_3DBevelOptionsDialog
_3DRotationGallery
_3DRotationOptionsDialog
ObjectFormatDialog
GroupWordArtStyles
TextStylesGallery
WordArtClear
TextFillColorPicker
TextFillColorMoreColorsDialog
TextPictureFill
TextFillGradientGallery
TextFillMoreGradientsDialog
TextFillTextureGallery
TextFillMoreTextures
TextOutlineColorPicker
TextOutlineColorMoreColorsDialog
TextOutlineWeightGallery
TextOutlineMoreLinesDialog
TextOutlineDashesGallery
TextOutlineMoreLinesDialog
TextEffectsMenu
TextEffectShadowGallery
TextEffectsMoreShadowsDialog
TextReflectionGallery
TextEffectGlowGallery
TextGlowColorPicker
TextGlowColorMoreColorsDialog
BevelTextGallery
TextEffectsBevelMore3DOptionsDialog
TextEffects3DRotationGallery
TextEffects3DRotationOptionsDialog
TextEffectTransformGallery
WordArtFormatDialog
GroupArrange
ObjectBringToFrontMenu
ObjectBringToFront
ObjectBringToFront
ObjectBringForward
ObjectSendToBackMenu
ObjectSendToBack
ObjectSendToBack
ObjectSendBackward
SelectionPane
ObjectAlignMenu
ObjectsAlignLeft
ObjectsAlignCenterHorizontal
ObjectsAlignRight
ObjectsAlignTop
ObjectsAlignMiddleVertical
ObjectsAlignBottom
AlignDistributeHorizontallyClassic
AlignDistributeVerticallyClassic
SnapToGrid
SnapToShapes
ViewGridlinesToggleExcel
ObjectsGroupMenu
ObjectsGroup
ObjectsRegroup
ObjectsUngroup
ObjectRotateGallery
ObjectRotationOptionsDialog
GroupSize
ShapeHeight
ShapeWidth
ObjectSizeAndPropertiesDialog
TabSetDrawingTools
TabDrawingToolsFormat
GroupShapes
ShapesInsertGallery
ObjectEditShapeMenu
ShapeChangeShapeGallery
ShapeConvertToFreeform
ObjectEditPoints
ShapeRerouteConnectors
TextBoxInsertExcel
TextBoxInsertMenu
TextBoxInsertHorizontal
TextBoxInsertVertical
GroupShapeStyles
ShapeStylesGallery
ShapeStylesOtherThemeFillsGallery
ShapeFillColorPicker
ObjectFillMoreColorsDialog
ObjectPictureFill
GradientGallery
ShapeFillMoreGradientsDialog
ShapeFillTextureGallery
MoreTextureOptions
ShapeOutlineColorPicker
ObjectBorderOutlineColorMoreColorsDialog
OutlineWeightGallery
LineStylesDialog
OutlineDashesGallery
LineStylesDialog
ArrowStyleGallery
ArrowsMore
ShapeEffectsMenu
ObjectEffectPresetGallery
_3DBevelOptionsDialog
ObjectEffectShadowGallery
ShadowOptionsDialog
ReflectionGallery
ObjectEffectGlowGallery
GlowColorPicker
GlowColorMoreColorsDialog
ObjectEffectSoftEdgesGallery
BevelShapeGallery
_3DBevelOptionsDialog
_3DRotationGallery
_3DRotationOptionsDialog
ObjectFormatDialog
GroupWordArtStyles
TextStylesGallery
WordArtClear
TextFillColorPicker
TextFillColorMoreColorsDialog
TextPictureFill
TextFillGradientGallery
TextFillMoreGradientsDialog
TextFillTextureGallery
TextFillMoreTextures
TextOutlineColorPicker
TextOutlineColorMoreColorsDialog
TextOutlineWeightGallery
TextOutlineMoreLinesDialog
TextOutlineDashesGallery
TextOutlineMoreLinesDialog
TextEffectsMenu
TextEffectShadowGallery
TextEffectsMoreShadowsDialog
TextReflectionGallery
TextEffectGlowGallery
TextGlowColorPicker
TextGlowColorMoreColorsDialog
BevelTextGallery
TextEffectsBevelMore3DOptionsDialog
TextEffects3DRotationGallery
TextEffects3DRotationOptionsDialog
TextEffectTransformGallery
WordArtFormatDialog
GroupArrange
ObjectBringToFrontMenu
ObjectBringToFront
ObjectBringToFront
ObjectBringForward
ObjectSendToBackMenu
ObjectSendToBack
ObjectSendToBack
ObjectSendBackward
SelectionPane
ObjectAlignMenu
ObjectsAlignLeft
ObjectsAlignCenterHorizontal
ObjectsAlignRight
ObjectsAlignTop
ObjectsAlignMiddleVertical
ObjectsAlignBottom
AlignDistributeHorizontallyClassic
AlignDistributeVerticallyClassic
SnapToGrid
SnapToShapes
ViewGridlinesToggleExcel
ObjectsGroupMenu
ObjectsGroup
ObjectsRegroup
ObjectsUngroup
ObjectRotateGallery
ObjectRotationOptionsDialog
GroupSize
ShapeHeight
ShapeWidth
ObjectSizeAndPropertiesDialog
TabSetPictureTools
TabPictureToolsFormat
GroupPictureTools
PictureBrightnessGallery
PictureCorrectionsDialog
PictureContrastGallery
PictureCorrectionsDialog
PictureRecolorGallery
RecolorColorPicker
PictureRecolorMoreColorsDialog
PictureSetTransparentColor
PicturesCompress
PictureChange
PictureReset
GroupPictureStyles
PictureStylesGallery
PictureShapeGallery
OutlineColorPicker
ObjectBorderOutlineColorMoreColorsDialog
OutlineWeightGallery
LineStylesDialog
OutlineDashesGallery
LineStylesDialog
PictureEffectsMenu
PictureEffectsPresetGallery
_3DBevelOptionsDialog
PictureEffectsShadowGallery
ShadowOptionsDialog
PictureReflectionGallery
PictureEffectsGlowGallery
GlowColorPicker
GlowColorMoreColorsDialog
PictureEffectsSoftEdgesGallery
_3DBevelPictureTopGallery
_3DBevelOptionsDialog
PictureRotationGallery
_3DRotationOptionsDialog
ObjectFormatDialog
GroupArrange
ObjectBringToFrontMenu
ObjectBringToFront
ObjectBringToFront
ObjectBringForward
ObjectSendToBackMenu
ObjectSendToBack
ObjectSendToBack
ObjectSendBackward
SelectionPane
ObjectAlignMenu
ObjectsAlignLeft
ObjectsAlignCenterHorizontal
ObjectsAlignRight
ObjectsAlignTop
ObjectsAlignMiddleVertical
ObjectsAlignBottom
AlignDistributeHorizontallyClassic
AlignDistributeVerticallyClassic
SnapToGrid
SnapToShapes
ViewGridlinesToggleExcel
ObjectsGroupMenu
ObjectsGroup
ObjectsRegroup
ObjectsUngroup
ObjectRotateGallery
ObjectRotationOptionsDialog
GroupPictureSize
PictureCrop
ShapeHeight
ShapeWidth
ObjectSizeAndPropertiesDialog
TabSetPivotTableTools
TabPivotTableToolsOptions
GroupPivotTableOptions
PivotTableNameLabel
PivotTableName
PivotTableOptionsMenu
PivotTableOptions
PivotTableOptions
PivotTableShowPages
PivotTableGenerateGetPivotData
GroupPivotTableActiveField
LabelActiveField
PivotFieldName
PivotTableFieldSettings
PivotTableExpandField
PivotCollapseField
GroupPivotTableGroup
PivotTableGroupSelection
OutlineUngroup
PivotTableGroupField
GroupPivotTableSort
SortAscendingExcel
SortDescendingExcel
SortDialog
GroupPivotTableData
RefreshMenu
Refresh
Refresh
RefreshAll
RefreshStatus
RefreshCancel
ConnectionProperties
PivotTableEditDataSource
PivotTableChangeDataSource
PivotTableChangeDataSource
ConnectionProperties
GroupPivotActions
PivotTableClearMenu
PivotClearAll
PivotClearFilters
PivotTableSelectFlyout
PivotTableSelectLabelAndData
PivotTableSelectData
PivotTableSelectLabel
PivotTableSelectEntireTable
PivotTableEnableSelection
PivotTableMove
GroupPivotTableTools
PivotChartInsertClassic
PivotTableFormulasMenu
PivotTableFieldInsert
PivotTableCalculatedItem
PivotTableSolveOrder
PivotTableListFormulas
PivotTableOlapTools
PivotTableOlapPropertyFields
PivotTableOlapOffline
PivotTableOlapConvertToFormulas
GroupPivotTableShowHide
PivotFieldListShowHide
PivotPlusMinusButtonsShowHide
PivotPlusMinusFieldHeadersShowHide
TabPivotTableToolsDesign
GroupPivotTableLayout
PivotTableLayoutSubtotals
PivotTableSubtotalsDoNotShow
PivotTableSubtotalsOnBottom
PivotTableSubtotalsOnTop
PivotTableLayoutGrandTotals
PivotTableGrandTotalsOffForRowsAndColumns
PivotTableGrandTotalsOnForRowsAndColumns
PivotTableGrandTotalsOnForRowsOnly
PivotTableGrandTotalsOnForColumnsOnly
PivotTableLayoutReportLayout
PivotTableLayoutShowInCompactForm
PivotTableLayoutShowInOutlineForm
PivotTableLayoutShowInTabularForm
PivotTableLayoutBlankRows
PivotTableBlankRowsInsert
PivotTableBlankRowsRemove
GroupPivotTableStyleOptions
TableStyleRowHeaders
TableStyleColumnHeaders
TableStyleBandedRows
TableStyleBandedColumns
GroupPivotTableStyles
PivotTableStylesGallery
PivotTableNewStyle
TableStyleClear
TabSetHeaderAndFooterTools
TabHeaderAndFooterToolsDesign
GroupHeaderFooter
HeaderFooterHeaderGallery
HeaderFooterFooterGallery
GroupHeaderFooterElements
HeaderFooterPageNumberInsertExcel
HeaderFooterNumberOfPagesInsert
HeaderFooterCurrentDate
HeaderFooterCurrentTimeInsert
HeaderFooterFilePathInsert
HeaderFooterFileNameInsert
HeaderFooterSheetNameInsert
HeaderFooterPictureInsert
HeaderFooterFormatPicture
GroupHeaderFooterNavigation
GoToHeader
GoToFooter
GroupHeaderFooterOptions
HeaderFooterDifferentFirstPageExcel
HeaderFooterDifferentOddEvenPageExcel
HeaderFooterScaleWithDocument
HeaderFooterAlignMargins
TabSetTableToolsExcel
TabTableToolsDesignExcel
GroupTableProperties
TableNameLabel
TableName
TableResize
GroupTableTools
TableSummarizeWithPivot
RemoveDuplicates
TableConvertToRange
GroupTableExternalData
TableExportMenu
TableExportTableToSharePointList
TableExportTableToVisioPivotDiagram
RefreshMenu
Refresh
Refresh
RefreshAll
RefreshStatus
RefreshCancel
ConnectionProperties
DataRangeProperties
TableOpenInBrowser
TableUnlinkExternalData
GroupTableStyleOptions
TableStyleHeaderRow
TableStyleTotalsRow
TableStyleBandedRows
TableStyleFirstColumn
TableStyleLastColumn
TableStyleBandedColumns
GroupTableStylesExcel
TableStylesGalleryExcel
TableStyleNew
TableStyleClear
TabSetPivotChartTools
TabPivotChartToolsDesign
GroupChartType
ChartChangeType
ChartSaveTemplates
GroupChartData
ChartSwitchRowColumn
ChartEditDataSource
GroupChartLayouts
ChartLayoutGallery
GroupChartStyles
ChartStylesGallery
GroupChartLocation
ChartPlacement
TabPivotChartToolsLayout
GroupChartCurrentSelection
ChartElementSelector
ChartFormatSelection
ChartResetToMatchStyle
GroupChartShapes
PictureInsertFromFile
ShapesInsertGallery
TextBoxInsertExcel
TextBoxInsertMenu
TextBoxInsertHorizontal
TextBoxInsertVertical
GroupChartLabels
ChartTitle
ChartTitleOptionsDialog
ChartAxisTitles
ChartPrimaryHorizontalAxisTitle
ChartPrimaryHorizontalAxisTitleOptionsDialog
ChartPrimaryVerticalAxisTitle
ChartPrimaryVerticalAxisTitleOptionsDialog
ChartSecondaryHorizontalAxisTitle
ChartSecondaryHorizontalAxisTitleOptionsDialog
ChartSecondaryVerticalAxisTitle
ChartSecondaryVerticalAxisTitleOptionsDialog
ChartDepthAxisTitle
ChartDepthAxisTitleOptionsDialog
ChartLegend
ChartLegendOptionsDialogDialog
ChartDataLabel
ChartDataLabelDialog
ChartDataTable
ChartDataTableOptionsDialog
GroupChartAxes
ChartAxes
ChartPrimaryHorizontalAxis
ChartPrimaryHorizontalAxisOptionsDialog
ChartPrimaryVerticalAxis
ChartPrimaryVerticalAxisOptionsDialog
ChartSecondaryHorizontalAxis
ChartSecondaryHorizontalAxisOption
ChartSecondaryVerticalAxis
ChartSecondaryVerticalAxisOptionsDialog
ChartDepthAxis
ChartDepthAxisOptionsDialog
ChartGridlines
ChartPrimaryHorizontalGridlines
ChartPrimaryHorizontalGridlinesOptionsDialog
ChartPrimaryVerticalGridlines
ChartPrimaryVerticalGridlinesOptionsDialog
ChartSecondaryHorizontalGridlines
ChartSecondaryHorizontalGridlinesOptionsDialog
ChartSecondaryVerticalGridlines
ChartSecondaryVerticalGridlinesOptionsDialog
ChartDepthGridlines
ChartDepthGridlinesOptionsDialog
GroupChartBackground
ChartPlotArea
ChartPlotAreaOptionsDialog
ChartWall
ChartWallOptionsDialog
ChartFloor
ChartFloorOptionsDialog
Chart3DView
GroupChartAnalysis
ChartTrendline
ChartTrendlineOptionsDialog
ChartLines
ChartUpDownBars
ChartUpDownBarsOptionsDialog
ChartErrorBars
ChartErrorBarsOptionsDialog
GroupChartProperties
ChartNameLabel
ChartName
TabPivotChartToolsFormat
GroupChartCurrentSelection
ChartElementSelector
ChartFormatSelection
ChartResetToMatchStyle
GroupShapeStyles
ShapeStylesGallery
ShapeStylesOtherThemeFillsGallery
ShapeFillColorPicker
ObjectFillMoreColorsDialog
ObjectPictureFill
GradientGallery
ShapeFillMoreGradientsDialog
ShapeFillTextureGallery
MoreTextureOptions
ShapeOutlineColorPicker
ObjectBorderOutlineColorMoreColorsDialog
OutlineWeightGallery
LineStylesDialog
OutlineDashesGallery
LineStylesDialog
ArrowStyleGallery
ArrowsMore
ShapeEffectsMenu
ObjectEffectPresetGallery
_3DBevelOptionsDialog
ObjectEffectShadowGallery
ShadowOptionsDialog
ReflectionGallery
ObjectEffectGlowGallery
GlowColorPicker
GlowColorMoreColorsDialog
ObjectEffectSoftEdgesGallery
BevelShapeGallery
_3DBevelOptionsDialog
_3DRotationGallery
_3DRotationOptionsDialog
ObjectFormatDialog
GroupWordArtStyles
TextStylesGallery
WordArtClear
TextFillColorPicker
TextFillColorMoreColorsDialog
TextPictureFill
TextFillGradientGallery
TextFillMoreGradientsDialog
TextFillTextureGallery
TextFillMoreTextures
TextOutlineColorPicker
TextOutlineColorMoreColorsDialog
TextOutlineWeightGallery
TextOutlineMoreLinesDialog
TextOutlineDashesGallery
TextOutlineMoreLinesDialog
TextEffectsMenu
TextEffectShadowGallery
TextEffectsMoreShadowsDialog
TextReflectionGallery
TextEffectGlowGallery
TextGlowColorPicker
TextGlowColorMoreColorsDialog
BevelTextGallery
TextEffectsBevelMore3DOptionsDialog
TextEffects3DRotationGallery
TextEffects3DRotationOptionsDialog
TextEffectTransformGallery
WordArtFormatDialog
GroupArrange
ObjectBringToFrontMenu
ObjectBringToFront
ObjectBringToFront
ObjectBringForward
ObjectSendToBackMenu
ObjectSendToBack
ObjectSendToBack
ObjectSendBackward
SelectionPane
ObjectAlignMenu
ObjectsAlignLeft
ObjectsAlignCenterHorizontal
ObjectsAlignRight
ObjectsAlignTop
ObjectsAlignMiddleVertical
ObjectsAlignBottom
AlignDistributeHorizontallyClassic
AlignDistributeVerticallyClassic
SnapToGrid
SnapToShapes
ViewGridlinesToggleExcel
ObjectsGroupMenu
ObjectsGroup
ObjectsRegroup
ObjectsUngroup
ObjectRotateGallery
ObjectRotationOptionsDialog
GroupSize
ShapeHeight
ShapeWidth
ObjectSizeAndPropertiesDialog
TabPivotChartToolsAnalyze
GroupPivotChartActiveField
LabelActiveField
PivotFieldName
PivotTableExpandField
PivotCollapseField
GroupPivotChartData
RefreshMenu
Refresh
Refresh
RefreshAll
RefreshStatus
RefreshCancel
ConnectionProperties
PivotChartClearMenu
PivotClearAll
PivotClearFilters
GroupPivotChartShowOrHide
PivotFieldListShowHide
PivotChartFilterShow
TabSetInkTools
TabInkToolsPens
GroupInkSelect
ObjectsSelect
InkDeleteAllInk
GroupInkPens
InkBallpointPen
InkFeltTipPen
InkHighlighter
InkEraser
GroupInkFormat
InkColorPicker
InkColorMoreColorsDialog
OutlineWeightGallery
LineStylesDialog
GroupInkClose
InkToolsClose
Monday, November 12, 2012
VSTO - Performance - Set 1000000 value within 2 seconds
public void RunTest(String columnName)
{
var start = DateTime.Now;
var sheet = Globals.ThisWorkbook.Sheets.getByName("Sheet3");
//set data area
Excel.Range dataArea = sheet.Range(String.Format("{0}1:{0}1000000", columnName));
//prepare dummy data
Object[,] data = new Object[1000000,1];
for (int i = 0; i < 1000000; i++)
{
data[i, 0] = i;
}
Debug.WriteLine("Data ready!!!");
// set data
dataArea.Value = data;
var duration = (DateTime.Now - start).TotalMilliseconds;
Debug.WriteLine(duration.ToString());
MessageBox.Show(duration.ToString());
}
Subscribe to:
Posts (Atom)