Rank: 1413 based on 77 downloads (last 30 days) and 2 files submitted
photo

Arthur Hebert

E-mail
Lat/Long
44.5453987121582, -123.26097869873

Personal Profile:

Professional Interests:

 

Watch this Author's files

 

Files Posted by Arthur View all
  • 1 - 2 of
  • 2
Updated   File Tags Downloads
(last 30 days) 		Comments Rating
19 Nov 2008 Class interface to MCC USB-ERB24 This is a wrapper class to conveniently interact with MCC USB relay cards via MATLAB. Author: Arthur Hebert mcc, daq, relay, erb, data acquisition, usb 13 0
24 Jul 2008 csv2cell Parse CSV files from Excel, mixed data types, to cell array. Author: Arthur Hebert structures and cell a..., mixed data type, structures, cell arrays, utilities, parse csv 64 4
  • 5.0
5.0 | 1 rating
Comments and Ratings by Arthur
  • 1 - 1 of
  • 1
Updated File Comments Rating
02 Sep 2009 Fit a spline to noisy data Fit a spline to noisy data. Author: Jonas Lundgren

Easy to use, does what it says, saves me a ton of work. Thanks.
Comments and Ratings on Arthur's Files View all
  • 1 - 5 of
  • 5
Updated File Comment by Comments Rating
11 Jan 2009 csv2cell Parse CSV files from Excel, mixed data types, to cell array. Author: Arthur Hebert xiang, ci

06 Aug 2008 csv2cell Parse CSV files from Excel, mixed data types, to cell array. Author: Arthur Hebert Hebert, Arthur

I hadn't noticed that XLSREAD would take CSV files, which is helpful. I'm not sure if you need MS Office installed as well for the COM server to work in 'raw' mode. I don't have any Windows machines without Office to test that.

CSV2CELL remains valuable in my mind for dealing simply with a ubiquitous file format in a platform independent way.
29 Jul 2008 csv2cell Parse CSV files from Excel, mixed data types, to cell array. Author: Arthur Hebert Shvorob, Dimitri

Hmm.. XLSREAD does read CSV files, and I have not realized that the 3-output syntax of XLSREAD - [numeric,text,raw], with 'raw' a cell array containing all data - depended on the ability to start a COM server, although, as a Windows user, I might take it for granted.
28 Jul 2008 csv2cell Parse CSV files from Excel, mixed data types, to cell array. Author: Arthur Hebert Hebert, Arthur

Hi Dimitri,

Both XLSREAD and CSVREAD deal poorly with mixed data types (i.e. text and numeric) in a file. CSVREAD only returns numeric data, and XLSREAD returns text and numeric data separately, unless your machine has the ability to start a COM server. Furthermore, XLSREAD works on Excel files directly and not CSV files.

Although this code specifically parses the Microsoft CSV format (quote delimiters, etc.), it also works on CSV files from most other sources. CSV2CELL is a more general solution than XLSREAD.
26 Jul 2008 csv2cell Parse CSV files from Excel, mixed data types, to cell array. Author: Arthur Hebert Shvorob, Dimitri

Why not just use XLSREAD? (And there's a CSVREAD, right?)
Top Tags Applied by Arthur
  • 1 - 5 of
  • 6
cell arrays, mixed data type, parse csv, structures, structures and cell arrays
Files Tagged by Arthur
  • 1 - 1 of
  • 1
Updated   File Tags Downloads
(last 30 days) 		Comments Rating
24 Jul 2008 csv2cell Parse CSV files from Excel, mixed data types, to cell array. Author: Arthur Hebert structures and cell a..., mixed data type, structures, cell arrays, utilities, parse csv 64 4
  • 5.0
5.0 | 1 rating
 

MATLAB Central Terms of Use

NOTICE: Any content you submit to MATLAB Central, including personal information, is not subject to the protections which may be afforded information collected under other sections of The MathWorks, Inc. Web site. You are entirely responsible for all content that you upload, post, e-mail, transmit or otherwise make available via MATLAB Central. The MathWorks does not control the content posted by visitors to MATLAB Central and, does not guarantee the accuracy, integrity, or quality of such content. Under no circumstances will The MathWorks be liable in any way for any content not authored by The MathWorks, or any loss or damage of any kind incurred as a result of the use of any content posted, e-mailed, transmitted or otherwise made available via MATLAB Central. Read the complete Terms prior to use.

Contact us at files@mathworks.com