MATLAB Answers

How to change default message box when using xlsread(filename,-1)

2 ビュー (過去 30 日間)
adi kul
adi kul 2017 年 6 月 7 日
コメント済み: adi kul 2017 年 6 月 7 日
Hello All, I am using xlsread(filename,-1) in my code where my intent is to give user ability to select specific data on a excel sheet. Now I am using this 3 times and every time I want to give message to user on which columns to select in their spread sheet. But currently the default message box have message "Data Selection Dialo...".
I want to change it to something "Select Category".
So is there any way to customize the default data selection message box?
  3 件のコメント
adi kul
adi kul 2017 年 6 月 7 日
I am trying with this:
warndlg('Select Category');
Now what I am trying to achieve is to execute = xlsread(filename,-1) once user clicks "OK" on warning dialogue box.
Is that possible?

サインインしてコメントする。

回答 (1 件)

Image Analyst
Image Analyst 2017 年 6 月 7 日
You could just read the whole thing in, and show it in a uitable grid/sheet control on your GUI, then build your own custom dialog box with GUIDE, or do something simpler with inputdlg(), to ask the user which rows, columns, or sheets they want.
  1 件のコメント
adi kul
adi kul 2017 年 6 月 7 日
I am trying with this:
warndlg('Select Category');
Now what I am trying to achieve is to execute = xlsread(filename,-1) once user clicks "OK" on warning dialogue box.
Is that possible?

サインインしてコメントする。

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by