Excel Connectivity - Maple Features - Maplesoft

Maple

Single User Licenses
Multi-User Licenses
Upgrade
What's New  |  Features  |  Online Demos  |  Compare  |  Training  |  Community  |  Evaluate  |  Buy Maple
Excel®Connectivity

Maple provides several different methods for working with Microsoft® Excel®, including flexible data import/export that means you can take full advantage of the Maple computation, visualization, and documentation environment when working with Excel-based data. Maple also offers the ability to store Excel files in Maple Workbooks so you can keep your analysis and your data together in a single file, and the ability to call on Maple to perform complex computations from within Excel.

Featured Examples and Applications

While Excel is a great tool for some tasks, it isn't suited to all types of computations and projects.

Read the whitepaper: Is Excel Hindering Your Engineering Projects?

Import/Export

Maple provides a flexible import and export of from a wide variety of data file formats, including those specific to Excel. Once your data is in Maple, you have full access to all of Maple’s data analysis, computation, and visualizations tools to help you understand your data and transform it into whatever other forms you need.

  • Import and export Excel .xls and .xlsx files, as well as .csv,. tsv, and other data file formats
  • Import data into a data frame or a matrix
  • Easily treat the first row in your data file as data or as column headings
  • Specify the Excel sheet and range of cells to import or export, when needed
  • Customize how Maple deals with empty cells on import

 

Example

Import data from an Excel spreadsheet into a dataframe:

dataframe := Import(“C:/Project/ExperimentalData.xls”);

Maple can display summary statistics on the data from Excel:

Statistics:-DataSummary(dataframe, summarize = embed):

Maple has numerous routines for statistics and data analysis. For example, you can scale the data:

ScaledData := Statistics:-Scale(dataframe):

Statistics:-BoxPlot(Scale(dataframe[.., 2 ..]), title = “Scaled Data”);

You can export the transformed data back to an Excel file:

Export(“NewData.xlsx”, ScaledData);



Storing Excel Files in Maple Workbooks

The Maple Workbook lets you keep your data, analyses, Maple code, and other information related to your project in a single file. In particular, you can store your Excel-based data files in your project’s workbook.

When you organize a Maple project with multiple files into a single Workbook, you only have to keep track of one file, rather than several. This eliminates the risk of losing file dependencies when moving Maple projects between locations or between people. You can easily access and manipulate the data stored in your Excel files when you open your Workbook in Maple.



Calling Maple from Excel

Maple offers a rich environment for performing calculations, analyzing data, and producing technical documents and applications, making it an ideal environment for working with Excel data. But if you wish to do some of your work in Excel directly, you can still take advantage of Maple's computation engine. Maple comes with an Excel add-in, which allows you to call out to Maple from within Excel to perform calculations and return the results back to Excel. In this way, you can take advantage of the Maple computation engine from within the Excel environment.