DERIVEXLA

Exporting DERIVE Vectors and Matrices into EXCEL File DERIVE21.XLA for Excel 97Have you a DERIVE fan?Need to exchange data - vector and matrices- between Excel?Try this simple free macro.The file DERIVE21.

Advertisements:

Exporting DERIVE Vectors and Matrices into EXCEL File DERIVE21.XLA for Excel 97Have you a DERIVE fan?Need to exchange data - vector and matrices- between Excel?Try this simple free macro.The file DERIVE21.XLA is an Excel-addin-macro useful for transferring vectors and matrices from DERIVE to Excel and vice versa. The macro works with DERIVE for Window ver 4 (all version) and 5 (5.0 - 5.02)UseIn DERIVE, highlight the vector or the matrix you want to copy and click the 'copy expressions' in 'Edit' menu (or by ctrl+c). Switch on Excel, select the cell that you want the first element to copy and click 'Paste Matrix from DERIVE' command in the 'Edit' menu. Matrix (n x m) are written in the same way as in DERIVE. Vectors are always written in vertical.On the contrary, if you want copy a rectangular matrix (as well row vector or column vector) from Excel, select the matrix's cells and click 'Copy matrix to DERIVE' command in 'Edit' menu.Switch to DERIVE, click 'Author Expression' and give the usually ctrl+v sequence for pasting.Notes that, if you have copied a vertical vector in Excel you get a 'vertical vector' in DERIVE and vice versa.New feature: Exporting Matrix into Excel. Now it is possible to export rectangular matrix into EXCEL.Save Formatting: The decimal, exponential, end fractional format are tranfered into EXCEL in the original format. Bug correction for exponent exported into Derive