03-06-2017, 12:23 PM
Hallo,
how can i search in a spreadsheet with a loop data search an then take the data in a new program?
Example:
Search EDLK
Spreadsheet:
A B C D E F ...
1 EDAG 122.458 94.0124 7.8756
2 EDHJ 121.354 93.4536 7.125
3 EDLK 120.050 93.1547 7.024
4 EDOP 123.012 92.0124 7.698
an so on
Find EDLK in A3 an then Print A3, B3, C3, D3 also EDLK 120.050 93.1547 7.024
EXPORT Navigation()
BEGIN
LOCAL I,A,B,C,D,E;
PRINT();
STARTAPP("Flugplatz");
I:=1;
FOR I FROM 1 To 10 Step 1 DO
PRINT (A(I));
// PRINT (B(I));
//PRINT (C(I));
//PRINT (D(I));
//PRINT (E(I));
END;
FREEZE;
END;
I hope, you can understand this!?
Best Regards Heino
how can i search in a spreadsheet with a loop data search an then take the data in a new program?
Example:
Search EDLK
Spreadsheet:
A B C D E F ...
1 EDAG 122.458 94.0124 7.8756
2 EDHJ 121.354 93.4536 7.125
3 EDLK 120.050 93.1547 7.024
4 EDOP 123.012 92.0124 7.698
an so on
Find EDLK in A3 an then Print A3, B3, C3, D3 also EDLK 120.050 93.1547 7.024
EXPORT Navigation()
BEGIN
LOCAL I,A,B,C,D,E;
PRINT();
STARTAPP("Flugplatz");
I:=1;
FOR I FROM 1 To 10 Step 1 DO
PRINT (A(I));
// PRINT (B(I));
//PRINT (C(I));
//PRINT (D(I));
//PRINT (E(I));
END;
FREEZE;
END;
I hope, you can understand this!?
Best Regards Heino