Items tagged with excel

Feed

In recent days, I have studied ExcelTools[Export]. Unfortunately, I still can not apply it.

oh, how??

Dear, can you provide an example?

Thanks!

Hello.
A simple procedure:
> restart;
> A := Array([1, 2, 3,4,5,6])
> for i from 1 to 6 do
   B[i]:=2*A[i];
    od;
This procedure is runed, the results are
B[1] := 2
B[2] := 4
B[3] := 6
B[4] := 8
B[5] := 10
B[6] := 12

However, what I want is:
If A is saved in a arbitrary folder, for example c:\myp\*.txt(or excel,dat), how can I read these data?
Then, if I want last results to be saved in a folder, for example c:\myp\*.txt...

Hi!

My problem is that MapleSim refuses to use my interpolation table, and the simulation stops, because it says the first column is not in ascending order. Seems easy to solve, but it is not! The column IS in ascending order, I even arranged it several times in Excel. I can't figure out what is the problem.

If someone has time, I attached the interpolation table.

Best regards; e6.xlsx

The Export function in ExcelTools completely overwrites Excel 2010 ".xlsx" files with no errors or messages.  The same command works properly for Excel 2003 ".xls" files.  It looks like a bug to me.

I more than 20000 data points on a an excel file and i want to plot one column against the other. So I imported 10 data points from each column seperately and tried ploting it as a normal plot but it would not work. I kept on getting error messages like 

plot([CosAa,CosBb]);

Error, (in plot) incorrect first argument [Array(1..10, 1..1, {(1, 1) = 0.83333e-2, (2, 1) = 0.166666e-1, (3, 1) = 0.249999e-1, (4, 1) = 0.333332e-1, (5, 1) = 0.416665e-1, (6, 1...

I got an MS Excel file where the matrix (7054x60) is created and the last row of the matrix is used for optimization of its (the matrix) values. In Maple you can create the matrix as follows:

M := Matrix(7054, 60):
for i to 10 do M[1, i] := 1 end do:

Mat_proc := proc(x)
  local i, j;
  global M;
  for i from 2 to 7054 do

Hi, I tried to export my answers into an excel file, but my numbers are all complex numbers.

It says "cannot export an rtable with complex values". How can I go about it?

Please advice. Many thanks.

Hello there,

Im using this code

 

> with(ExcelTools);

> L := Import("C:\parameters15.xlsx", "Sheet1", "A2:I2");
 
and I keep getting :     Error, (in ExcelTools:-Import) Could not open the file.
 
What are the possible reasons for this? I have triple checked the file name, location and extension. It's all good.
 
 

Hello

I have some numerical values (excel-format) and i would like import them in my Maple page , after that i m traying to plot them but it s impossible , in fact when i click on the right button of my mouse , i haven't this option.

Please help me , and show me how i should do it in details , i m not an expert

thanks .

Firas

Currently, the size of a table/matrix which can be exported to a spreadsheet is limited to 255 columns X 65535 rows. I believe this rule was implemented because of the maximum possible size of a spreadsheet(Am I right?) . This used to be the case in Excel 2003, but since Excel 2007, a spreasheet  can be : 1,048,576 rows by 16,384 columns.

 

Maybe it is time to update this rule?

 

Excel 2003 :http://office.microsoft.com/en-us/excel...

How do I import/export excel into Maplesim? Also how do I view mpld data files? I tried viewing mpld files using maplesim and maple 14 but it didn't work.

Hi all

I am trying to draw a 3d plot from the data that I have created in excel, how do I import from excel to maple and then draw the 3d plot using array?

 

below is the link to my dataset in excel

 

Book1.xls

 

your help is appreciated

Hello,

I am trying to import some data into Maple from an Excel sheet that contains three columns.

Column 1 is simply an index number for the measurement running from 1 to 3185.

Column 2 is the time of the measurement ( e.g 10:23:44 ) with Excel formatting as "time".

Column 3 is the measured CO2 concentration logged at the psecific time.

My problem is that when I import the data into Maple using the ExcelTools,Import or simply the Import...

Hello,

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

1 2 3 4 5 Page 4 of 5