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....

plus de 6 ans il y a | 1 réponse | 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....

plus de 6 ans il y a | 2 réponses | 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...

plus de 6 ans il y a | 1 réponse | 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...

plus de 6 ans il y a | 1 réponse | 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...

plus de 6 ans il y a | 2 réponses | 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...

plus de 6 ans il y a | 1 réponse | 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...

plus de 6 ans il y a | 3 réponses | 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 ...

plus de 6 ans il y a | 2 réponses | 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...

plus de 6 ans il y a | 1 réponse | 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' ...

plus de 6 ans il y a | 1 réponse | 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 = ...

plus de 6 ans il y a | 2 réponses | 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...

plus de 6 ans il y a | 2 réponses | 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...

plus de 6 ans il y a | 3 réponses | 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...

plus de 6 ans il y a | 2 réponses | 0