©
Excel to matrix
  Converts (reads, handles) a 'csv' Excel file into a matrix.
2024.May.17 13:17:05
kol Data column for a confirmative analysis. •
klass No. of histo. classes. •
Comma to point ? Replace ",." (and ";,"). •

Data (csv)

No final 'CR LF' !
Show matrix ?   Shows the matrix values. •
Show values ? Shows the coordinates of the graph. •

Converts an Excel file, given in 'csv' (comma-separated values) format, into a numerical matrix.

Column 'kol' is given just for a supplementary confirmative analysis. The column data are handled to produce a histogram.

Data are accepted in (coherent) ", ;" ("European") style or ". ," ("American") style.

References: Plate: ExcelToMatrix

• Google "microsoft excel file formats"

• Wikipedia "Comma-separated values".

• 1841-01-06: Sturm, Friderich Otto Rudolph (1919-04-12).

 
 
Valid HTML 4.01! IST http://web.ist.utl.pt/~mcasquilho/compute/com/Fx-Excel_to_matrix.php
Created: 2012-01-05 — Last modified: 2012-01-15