IXlsCell

COM interface ( getting help with interfaces )

interface IXlsCell : IDispatch
{
  [id(1),propput] HRESULT HtmlLabel([in]BSTR label);
  [id(1),propget] HRESULT HtmlLabel([out, retval]BSTR* label);
  [id(2),propput] HRESULT HtmlNumber([in]BSTR n);
  [id(2),propget] HRESULT HtmlNumber([out, retval]BSTR* n);
  [id(3),propput] HRESULT HtmlFloat([in]BSTR f);
  [id(3),propget] HRESULT HtmlFloat([out, retval]BSTR* f);
  [id(4),propput] HRESULT HtmlDate([in]BSTR hdate);
  [id(4),propget] HRESULT HtmlDate([out, retval]BSTR* hdate);
  [id(5),propput] HRESULT HtmlFormula([in]BSTR formula);
  [id(5),propget] HRESULT HtmlFormula([out, retval]BSTR* formula);
  [id(6),propput] HRESULT InPlacePicture([in]BSTR filename);

}

HRESULT HtmlLabel([in]BSTR label);
puts a label in a cell. The string is html-based.

HRESULT HtmlLabel([out, retval]BSTR* label);
gets the label from a cell. The string is html-based.

HRESULT HtmlNumber([in]BSTR n);
puts an integer number in a cell. The string is html-based.

HRESULT HtmlNumber([out, retval]BSTR* n);
gets the integer number from a cell. The string is html-based.

HRESULT HtmlFloat([in]BSTR f);
puts a floating point number in a cell. The string is html-based.

HRESULT HtmlFloat([out, retval]BSTR* f);
gets the floating point number from a cell. The string is html-based.

HRESULT HtmlDate([in]BSTR hdate);
puts a date in a cell. Day/Month must be expressed using user desktop locale settings, i.e. January if you are using an English desktop locale. The string is html-based.

HRESULT HtmlDate([out, retval]BSTR* hdate);
gets the date from a cell. Returns an empty string if the cell is not a date/time. The string is html-based.

HRESULT HtmlFormula([in]BSTR formula);
puts a formula in a cell. The string is html-based.

HRESULT HtmlFormula([out, retval]BSTR* formula);
gets the formula from a cell. The string is html-based.

HRESULT InPlacePicture([in]BSTR filename);
puts a picture in a cell. Available to XLSX/XLSB files.