Export data to Excel

cellprofiler

#1

Dear Team,

The data measured in CP could be exported to excel sheet named as ***.xls, however, it seems the exported file is not really in excel format. When try to operate this file with Matlab functions such as ‘xlsread’ error will come out saying that the file is not in excel format. Is there anyway to address this problem?

Thank you,

Paradise


#2

Hi,

The exported file is actually a comma-separated file (CSV) which can be read by Excel. Since xlsread is expecting a Microsoft-formatted Excel file, it fails on the read attempt.

At this point, you have two options:

  • Use Excel and convert the CSV file into an Excel spreadsheet

  • The MATLAB function textscan might be used in this case (there is a csvread command as well, but it requires all numeric data).

Hope this helps,
-Mark


#3

Thank you, Mark.