Question

How do I skip an error in a loop?
I have a for loop that opens and checks excel files, however it has been returning errors of such Error using Interface....

8 years ago | 1 answer | 0

Question

Find string ends with xls or xlsx
I have a char array of strings (each string is a file name) and I would like to find out the strings that ends with xls or xlsx....

8 years ago | 2 answers | 0

Question

why is "~$" appearing in front of my excel file names?
Earlier I used dir command to find all the excel files that I have, but for some of the file names (not all) it returns file nam...

8 years ago | 1 answer | 0

Question

convert string to cell array
I have a for loop that gives results that are constantly updating x= 'A' x= 'B' x= 'C' But I would like to conver...

8 years ago | 1 answer | 0

Question

Add y grid only to plot
I would like to add solid y grid lines to my plot according to the y tick in gca. so I tried: ax = gca; ax.YGrid = 'o...

8 years ago | 2 answers | 0

Question

tick rotation in old version of matlab
I am trying to rotation the x-axis tick labels in my plot, but most of the answers suggest ax.XTickLabelRotation which i...

8 years ago | 1 answer | 0

Question

Filter excel files by sheetnames
Hi, I am trying to filter out excel files by checking whether it has a sheet named "Cooking_is_fun" within the excel. This i...

8 years ago | 3 answers | 0

Question

Create plot from large data in excel
I have a very large excel spreadsheet that needs to be coded and plotted in matlab, so before I am able to attempt that, I want ...

8 years ago | 2 answers | 0

Question

Copy graphs from Excel to GUI
My task involves to copy an excel plot from say... worksheet3 named "X_Plot" of an excel file (D:\Files\Excel Plots.xlsx) direct...

8 years ago | 1 answer | 0

Question

Extract numbers from a cell array of strings
I have the following cell array: s = 'HI_B2_ *TTT4009*_D452_07052016.xlsx' 'HI_H2G_ *TTT4002*_D259_070516.xlsx' ...

8 years ago | 1 answer | 0

Question

Sort Excel files by file content?
Hi all, my new challenge with matlab involves filtering files with very inconsistent names. For example, s = ...

8 years ago | 2 answers | 0

Question

regexp to filter file names
I have files such as the following: s = 'HI_B2_TTTT9_Default452_07052016.xlsx' 'HI_H2G_TTTT7_Def...

8 years ago | 2 answers | 0

Question

Open Files by File Name Patterns
I am looking for the best Syntax to recognize patterns in file names and open the desired files/filter out unwanted files. Fo...

8 years ago | 3 answers | 0

Question

how to use dir in subfolders?
I am trying to search for all the xlsx files inside a folder that have many subfolders to search from. I realize matlab does not...

8 years ago | 2 answers | 0