emblem
Excel: copy-paste to input data
Reads from Excel through copy & paste to an input file.
2024.May.17 09:25:04
kol Data column for a confirmative plot. •
Comma to point ? Replace ",." (and any ";,"). •
Data
(No final 'CR LF' !)
Show matrix ?   Shows the matrix values. •
Show values ? Shows the coordinates of the graph. •

Reads data, possibly from Excel, through simple copy and paste, converting the data into a simple input file, which is then given to a (Fortran 90) program.

Essentially, the tab characters are converted to blanks. (If from Excel, any formulas in the cells become their visible, numerical equivalents.)

Column 'kol' is given just for a supplementary confirmative plot.

Data are accepted either in ", ;" ("European") or ". ," ("American") style, the user having to select comma-to-point in this latter case.

This plate is essentially a tool for other applications where data may be supplied by copy-paste.

References: Plate: ExcelCopyPaste

• Google "microsoft excel file formats"

• Amazon: V. N. Faddeeva, Computational methods of Linear Algebra, 1959, Dover Books on Mathematics.

• 1906-09-20: Faddeeva, Vera Nikolaevna (1983-04-15.

 
 
Valid HTML 4.01! IST http://web.ist.utl.pt/~mcasquilho/compute/com/Fx-Excel_copypaste.php
Created: 2015-09-20 — Last modified: 2015-09-30