Info

This question is closed. Reopen it to edit or answer.

How can I import .xlsx files automatically without having many programming concepts?

1 view (last 30 days)
Personally, I have a new problem. I'm programming a new method to quantify the time when individuals are in a particular model exercises. Well, but that's not the biggest problem. The problem is that people who do not have programming concept will use this program. I'm programming in Matlab and need to find a way to import data into Excel format ('* .xlsx') and look through a dialog box the desired file, in addition, also need to let the scheduled import ALL the lines starting the third and the first two columns. But each of these columns will have to be imported separately as vectors. A vector time and a second column vector is a dependent variable. Can anyone help me. I've used xlsread () but to use this function need the directory, file name and other things, which would not be interesting for people who have no idea of programming and who will handle the function. I thank you very personal. Any help is very welcome.

Answers (1)

Cedric
Cedric on 28 Jul 2015
Edited: Cedric on 28 Jul 2015
Look at the following:
doc uiputfile
doc fullfile
doc xlswrite
The first will allow you to open a file selection window for saving, the second will allow you to merge the file name and the directory name, and the third will allow you to export. If you need to read files, look for uigetfile and xlsread.

This question is closed.

Products

Community Treasure Hunt

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

Start Hunting!