IXlsShape

COM interface ( getting help with interfaces )

interface IXlsShape : IDispatch
{

  [id(1), propget] HRESULT LeftColumn([out, retval]int* col1);
  [id(2), propget] HRESULT RightColumn([out, retval]int* col2);
  [id(3), propget] HRESULT TopCell([out, retval]int* row1);
  [id(4), propget] HRESULT BottomCell([out, retval]int* row2);
  [id(5), propget] HRESULT LeftOffset([out, retval]int* offset);
  [id(6), propget] HRESULT RightOffset([out, retval]int* offset);
  [id(7), propget] HRESULT TopOffset([out, retval]int* offset);
  [id(8), propget] HRESULT BottomOffset([out, retval]int* offset);
  [id(9), propget] HRESULT Name([out, retval]BSTR* shapename);
  [id(10)        ] HRESULT Delete();
  [id(11)        ] HRESULT BringToFront();
  [id(12),propget] HRESULT Type([out, retval]int* shapetype);
  [id(13)        ] HRESULT ExtractToFile([out, retval]BSTR* filename);
  [id(14)        ] HRESULT ExtractToMemory([in]IUnknown* lockbytes);
  [id(15),propget] HRESULT AlternativeText([out, retval]BSTR* shapetext);
  [id(16),propget] HRESULT VBAMacro([out, retval]BSTR* macro);

}

HRESULT LeftColumn([out, retval]int* col1);
returns the left worksheet column of the shape.

HRESULT RightColumn([out, retval]int* col2);
returns the right worksheet column of the shape.

HRESULT TopCell([out, retval]int* row1);
returns the top worksheet row of the shape.

HRESULT BottomCell([out, retval]int* row2);
returns the bottom worksheet row of the shape.

HRESULT LeftOffset([out, retval]int* offset);
returns the left worksheet column offset of the shape. Value is 0 if it coincides with the worksheet grid.

HRESULT RightOffset([out, retval]int* offset);
returns the right worksheet column offset of the shape. Value is 0 if it coincides with the worksheet grid.

HRESULT TopOffset([out, retval]int* offset);
returns the top worksheet row offset of the shape. Value is 0 if it coincides with the worksheet grid.

HRESULT BottomOffset([out, retval]int* offset);
returns the bottom worksheet rowoffset of the shape. Value is 0 if it coincides with the worksheet grid.

HRESULT Name([out, retval]BSTR* shapename);
returns the name of the shape.

HRESULT Delete();
deletes the shape.

HRESULT BringToFront();
brings the shape to the front, allowing it to show above others.

HRESULT Type([out, retval]int* shapetype);
returns the type of the shape. Picture = 8 for instance. Chart = 5 for instance.

Type	Description
0	Group
1	Line
2	Rectangle
3	Oval
4	Arc
5	Chart
6	Text
7	Button
8	Picture
9	Polygon
11	Checkbox
12	Option button
13	Editbox
14	Label
15	Dialogbox
16	Spinner
17	Scrollbar
18	Listbox
19	Groupbox
20	Combobox
25	Comment
30	Office drawing

HRESULT ExtractToFile([out, retval]BSTR* filename);
creates a copy of the picture in a file and returns the filename, if the shape is a picture, a chart or a text box. Client applications must be ready to accept the PNG file format.

HRESULT ExtractToMemory([in]IUnknown* lockbytes);
creates a copy of the picture in memory, if the shape is a picture, a chart or a text box. PNG buffer.

HRESULT AlternativeText([out, retval]BSTR* shapetext);
returns the alternative text associated to the shape.

HRESULT VBAMacro([out, retval]BSTR* macro);
returns the vba macro name for the shape.