Items tagged with excel

Feed

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