采用OleVariant方式操作Excel的Range,提示"找不到成员"
代码很简单:
var
Excel: OleVariant;
Sheet: OleVariant;
Range : OleVariant;
begin
Excel := CreateOleObject('Excel.Application');
Excel.Visible := True;
Excel.Workbooks.Add;
Sheet := Excel.Sheets[1];
Sheet.Range('A1') := '1111111'; //这里OK
Range := Sheet.Range('A1'); //运行到这里提示"找不到成员",不知什么原因??
Range := '222222';
end;