Dear power users, I was wondering whether it is possible to import a xlsx file in such a way that the first row of the file is imported as column headers of the dataframe in Maple? Thank you in advance for any help given.

Hi 

I teach Pre-Calulus High School level, and our school recently upgraded to Maple 2024. Like in Maple 2023 we use Assistant-Tools-import DATA and chosing an Excel file from which to import to do regression on.  In the new 2024 we have experienced, that Maple cannot read in DATA, meaning it cannot read column of DATA into a Maple document. However if we copy into Excel document on the machine locally, then there is no issue and the data is imported. 

Any idear what can cause this?  

How to convert a ploting values in a graph to excel?

restart;
with(PDETools): with(DETools): with(plots):with(plottools):
eq1 := ((D@@2)(f))(eta)*f(eta)*sin(alpha)+((D@@2)(f))(eta)*eta*cos(alpha)+2*((D@@3)(f))(eta) = 0;
ics := f(0) = 0, (D(f))(0) = 0, (D(f))(10) = 1; bcs := (D(f))(10) = 0, theta(10) = 0, phi(10) = 0;
Parameters1 := alpha = (1/3)*Pi;
sol1 := dsolve(eval({eq1, ics}, {Parameters1}), numeric);
p1 := odeplot(sol1, [[eta, ((D@@2)(f))(eta)]], eta = 0 .. 10, color = [red], axes = boxed);
display({p1});

Is there an equivalent to Pivot Table in Excel?
I'm working on some investing data, and am using Maple to gather information from various sources and using DataFrame to combine all the data. I could export the dataframe and open in Excel or other spreadsheet and use the Pivot table to summarize the data, but is there an easy way to do all of it in Maple?

Thanks

How do I format the display of numbers in Microsoft Excel 365 using the Maple 2023 Add-In?

The default formatting is inconsistent: displays as but displays as . At minimum, I would like all of the numbers to display using a consistent format, preferably standard scientific notation (1.27420168E7 and not or ).

acer helped me out last week with converting strings to dates which was very helpful. However now I stumble on 2 other problems:

- I do not succeed to plot DS6 (time difference versus a numeric value) and to not understand why

- in the cvs data sheet the length of the columns is not equal. The empty cells are automatical filled with "". This prevents me to use numelems as it will also take into consideration the cells filled with "". Is there a way to prevent this

As usual I would like to thank you all, power users, for your patience and help

Test.mw

There are some excel sheets that cannot be read w/ Maple 2023 that were read w/ Maple 2022.
I attached an example.ImportFerrites.maple
Does anyone else experienced this issue or has a solution?

How to solve this equation in symbolic form so that the resulting solution can be used as a formula in Excel?

Is it possible?

C = constant

I will have excel sheet with minium 500 coulmns and 1000 rows say

For sample to explain my question I attach a demo excel

All my columns have headers

I am looking to find all 2 way multiplication and add them as columns to my excel sheet and return it as a new excel sheet say

The column names for the new 2 way column should be like the

header name of column you are multiply * the name of the other columsn

Now in sample file if i multiple column with name A with column with name B I get a new column with header A*B the header name should be inserted and

Below that all the elements of that A column multiplied  with that of B should come

I am looking to form columns for all possible2  way multiplication for the excel I will give.

As you can see the demo file

Excel_to_explain.xlsx

Kind help please

I have a fairly simple worksheet with a 56x2 matrix M1 which I am trying to export to Excel with the following 

ExcelTools:-Export( M1, "C:/Temp/M1.xlsx", 1, "B2")

This causes the following message to appear

After that the program is frozen and totally unresponsive.  The only way to proceed is end the task in Task Manager..

I am trying to upload the worksheet but am not sure if I have succeeded

Download Calculation_of_pH_from_known_values_of_Vb.mwCalculation_of_pH_from_known_values_of_Vb.mw

I have never use Maple before and have the following equation

c_a, c_b, K_a, K_b, K_w and V_a are either constants or pre-determined (V_a).  I know it should be easy to tabulate/calculate values of V_b for given values of [H⁺] (hydrogen ion concentration) but how easy would it be to determine values of [H⁺] for selected values of V_b?  Would it be easy to set up bearing in mind my lack of experience?

Hello,

I have a problem to export datas in an excel file.

I have no problem to read some datas in this file, but when i want to write a matrix 1x1 in a cell, there is no error message but nothing happen in the file.

Here is my program :

with(ExcelTools);

kernelopts(datadir);

File1 := FileTools:-JoinPath(["Excel", "test.xlsx"], base = datadir);
Mat1 := Import(File1, "Somme", "G2:G8"); # it runs very well
R := array(1 .. 1, 1 .. 1, [[564]]);
Export(R, "test.xlsx", "Somme", "G1"); # nothing happens in the file

Thank you very much for help

 suppose i have outputs of several functions retured as variables float

A , B , C , D ,E , F , G , H , I , J , K ,L,M ,N , O, P,Q

I run the functions several times that all the function are run even if one is run 

so for each run I get a row of the matrix M in that order how to create from that outputs

each output is appended as next row in the same way to the matrix in the same order

Then I want the final matrix after all run to me exported to excel

I have a student who then she uses tools/assistent/import data and then the file then Maple claims the Excel file is empty? She uses Maple 2021.2. File works on other my and other student computers. 

A few days ago my Windows 10 (32 bit) operating system did an update of my Excel 2016. Since that moment I get following message:

However the addin toolbar is still present and WMIMPLEX.xla file is also still present. Removing and reinstalling the addin did not help. So I am wondering what other solutions could be done.

Aside of this I would like to ask some help for the correct syntax in Thermodynamics package calculating water vapor pressure. For one or another reason I do not succeed to find the correct syntax to obtain the water vapor pressure at 24°C.

Thank you in advance for any help