Question: Problems with Excel import

Hey guys,

 

I do have a problem with Excel Import.

What I wanna do is import 2 collumns from a Excel-File.

The first Column are the X-coordinates and in the second column are the y-coordinates.

After the import of the two columns (each with around 1000 rows) I would like to run a formula for each of this x/y pairs. Means for example a formula i1:=2*x+y or something like this.

And I would like to get the results also in a table or something I can export to Excel.

 

I tried to import the data like this:

 

with(ExcelTools):

import("C: \ \Users \ \xxx \ \umwandlung.xls", "Tabelle1", "C1:D1018")

 

But I don't get how to go on with this?

 

Can you help me with this pls?

 

Greets

Steffen

Please Wait...