清空筛选条件
清空筛选条件

browse for an excel file and save the data as a matrix

1 次查看（过去 30 天）
Matthew
Matthew 2012-3-15
I want to create a function to browse for an excel file and save the data as a matrix. I have only been able to find ways to import data when I already know the name of the file. I used the funtcion generator to create a funtion to do it but it doesn't include code to save the matrix. I would think you could do something like this: datafile1 = uiimport('-file'); xlsread(datafile) but that doesn't work. I'm sure this is a simple task but I can't find any forums or demos that explain hot to do this. The excel file I will use will have two columns one with date and time and the other with a number value and there are no headers in the file. I want to be able to select a different file everytime and have it save as a matrix.

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

采纳的回答

Geoff
Geoff 2012-3-15
Use the function uigetfile to browse for a filename, then pass that name to xlsread.

更多回答（2 个）

Matthew
Matthew 2012-3-15
I tried this but it only returned the data from the second column and did not do the date and time conversion
datafile1 = uigetfile; xlsread(datafile1,'Sheet1','','',@convertSpreadsheetDates);
Matthew
Matthew 2012-3-15
I got it figured out thanks

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by