Insert picture in Excel

Hi,

No way to do this via existing set of operations for keyword tests. Only through the code.

That is what I was looking for, what information, present here at this site!

MIBridges

Hello,

Can somebody please help on  how to insert picture in Excelsheet , through code?.

Thanks.

In your Project properties, add the WndClass name of the ribbon to MSAA in Open Applications. I’m using Excel 365 and my WndClass is called ‘NetUIHWND’. TestComplete will then recognise each of the menu items in the ribbon.

Record your keyword test as click Insert -> Pictures -> select file -> Insert

The same can be applied when scripting

function Test8()
{
  Aliases.EXCEL.wndXLMAIN.EXCEL2.toolbar.Ribbon.NUIPane.NetUIHWND.tablistRibbonTabs.ClickTab("Insert");
  Aliases.EXCEL.wndXLMAIN.EXCEL2.toolbar.Ribbon.NUIPane.NetUIHWND.paneLowerRibbon.client.propertypageInsert.toolbarIllustrations.buttonPictures.ClickButton();
  Aliases.EXCEL.dlgInsertPicture.OpenFile("C:\\Users\\Test\\Pictures\\Smartbear.jpg", "All Pictures (*.emf;*.wmf;*.jpg;*.jpeg;*.jfif;*.jpe;*.png;*.bmp;*.dib;*.rle;*.gif;*.emz;*.wmz;*.tif;*.tiff;*.svg)");
}