Problems using different types of Excel Formats

2012 6 22
1 个回答
回答已采纳
3 次查看（30 天）

0 个投票

Hi,
I am trying to build a dataset in Matlab that reads different worksheets in an Excel file.
The first worksheet is Labview output with the first column of custom time format hh:mm:ss AM/PM
What I would like to do is use that column of time for each of the following columns of voltage data.
How do I get that time to read into a matrix that can be manipulated?
I want the eventual output to be a cell array in which the first column is a bunch of (nx2) data sets with (time,voltage). For some reason, I am currently getting the time as characters and cannot add or subtract different values.
New to matlab, sorry if that is confusing.
Thanks in advance.

2 个评论
显示 无 隐藏 无

Leah
Leah 2012-6-22
Do you have the statics toolbox? Datasets are really nice for doing this kind of work. You need your columns to be doubles not strings to perform mathematical operations on them. Do you have the specific error message.
Rachel
Rachel 2012-6-22
I do but have never used it. I can look in to that.
There is no error message, I just don't know how to read in the time values so that I can build an nx2 matrix of numerical data to plot and analyze.

请先登录，再进行评论。

请先登录，再回答此问题。

 采纳的回答

Adam Filion
Adam Filion 2012-6-22

0 个投票

How are you reading the data in? The XLSREAD function will automatically convert anything it sees as a date into a number. Using the following I think you can read in your data and get the desired cell structure.
[~,~,rawdata] = xlsread('testsheet');
dates = repmat(rawdata(:,1),1,length(rawdata(1,2:end)));
readings = rawdata(:,2:end);
cell1 = cellfun(@(x,y) [x,y],dates,readings,'UniformOutput',0);
Note that you can convert these date numbers back into date format using DATEVEC function.

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

产品

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by