Items tagged with excel


I have spent all morning trying to create a surface plot from a set of survey data that I have. The data I have is in the format xi, yi, zi. It is in Excel in columns. I read some previous questions on this topic, but my plot just comes out all jumbled.  Here is what I coded.

As soon as I figure out how to post images, i will post the plot...

I just started using Maple few weeks ago, so i am very new to Maple. I tried to write a program to:

1. read data from excel

2. process the data obtained from different excel sheets to find different possible combinations and calculate costs

3. then to find the minimum cost option

program i wrote is

> with(ExcelTools);
> SHEET1 := Import("analysis.xls", "su1", "A4");
`output redirected...`> print(); # input placeholder

@epostma Thank you , that really worked. My next question is, if the raw data is in a text file, other than data pasted into excel, how can i import the the two columns of data and do the similar calculation?

The text file is attached.

[0, 0, 0]
Voltage_1 (1) Current_1 (1)
+2.084844E-03 -1.539501E-11
+1.008272E+00 +7.418045E-11

1 2 3 4 5 Page 5 of 5