1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
TForm1 = class(TForm)
...
Button1: TButton;
Edit1: TEdit;
XlsApp: TExcelApplication;
...
end;
...
procedure TForm1.Button1Click(Sender: TObject);
var
XlsWk: _workbook;
XlsPage: _Worksheet;
vValue: variant;
begin
XlsApp.Connect;
XlsWk := XlsApp.Workbooks.Open('F:\Classeur1.XLS', False,False, EmptyParam,EmptyParam,EmptyParam,EmptyParam,EmptyParam, EmptyParam, EmptyParam, EmptyParam,EmptyParam,EmptyParam,0);
XlsPage := XlsWk.Worksheets['Feuil1'] as _worksheet;
XlsPage.Range['A2', 'A2'].Select;
vValue := XlsPage.Cells.Hyperlinks.Item[1].Address;
Edit1.Text := vValue;
XlsApp.Disconnect;
end; |
Partager