unit Excel97: Range in D5 aber nicht in D7

[marabu]

So geht das:

Delphi-Quellcode:

uses
  ExcelXP,
  Windows;

procedure TDemoForm.ButtonClick(Sender: TObject);
var
  wb: ExcelWorkbook;
  ws: ExcelWorkSheet;
  r: ExcelRange;
begin
  xl.Connect;
  wb := xl.WorkBooks.Add(null, GetUserDefaultLCID);
  ws := wb.Sheets.Add(null, null, 1, null, GetUserDefaultLCID) as ExcelWorkSheet;
  r := ws.Range['B1', 'B1'];
  r.Value2 := 'marabu';
  ShowMessage(r.Value2);
  xl.Disconnect;
end;

marabu