Home › Forums › Get Help › How do I ...? with Maple

Easiest way to extract data from an excel spreadsheet

Posted on 2008-03-18 13:18 By killercatfish (Maple Rating 1 28)
Categories:

Just wondering what the easiest way is to extract data from an excel spread sheet so that it can be used as data in a maple worksheet.  For that matter, what other database programs can I use with maple?

 

Thanks.

 

 

‹ Bad Integration of e^x Can anybody help me solve this transcendental equation by maple ? ›
Scott03's picture

Excel Import

Comment on 2008-03-18 13:31 from Scott03 (Maple Rating 4 468)

With Maple 11, there is a package for importing data from an excel spreadsheet (ExcelTools).  The Data Import Assistant from the Tools>Assistants menu can also be used for this.  If the spreadsheet was exported as a delimited file, both Maple 10 and 11 can read in this file (see ImportData and ImportMatrix help pages).  Please note that only the numerical data is brought in, no formulas that used in the cells to get the values are imported in.  If you are just wanting data from one cell, you can just copy and paste into Maple.

If you combine Maple with the Database Integration toolbox you can connect Maple to "JDBC-compliant databases, such as Microsoft® SQL Server, Microsoft® Access, Sybase™, Oracle®, IBM® DB2®, and MySQL®".  More information can be found on Maple's webpage here.

 

Scott

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
}