Calabrese

Actif depuis 2015

Followers: 0 Following: 0

Statistiques

Feeds

Question

Round values in cell array to n(10)?
How to round the following... cell = {15;26;37;48;50;68}; cell2 = roundn(cell,1) to cell2 = {20;30;40...

presque 7 ans il y a | 1 réponse | 0

1

réponse

Question

Continue loop on other files if current file is deleted within a loop?
I want to delete *.xlsx files if they meet a certain criteria. However when a file is deleted based on the first if statement it...

environ 7 ans il y a | 2 réponses | 0

2

réponses

Question

Access or skip excel file that is locked for editing within a loop?
While running a loop the code errors out on a file that is locked for editing. excel_xlsx=dir('*.xlsx'); % list of the...

environ 7 ans il y a | 1 réponse | 0

1

réponse

Question

How to modify number of characters for numeric values in a cell array?
Within a cell array, I would like to limit the number of characters allowed in each cell to 6. If the cell has more than 6 chara...

environ 7 ans il y a | 1 réponse | 0

1

réponse

Question

How to loop a process and end when cell array is empty?
I am running a process where I read an excel file with many rows. The rows consist of package data that vary in how many rows ea...

environ 7 ans il y a | 1 réponse | 0

1

réponse

Question

How to remove rows from cell array based on multiple conditions?
I would like to separate the following sample array into 2 arrays. If C contains any of the following strings (red, spoon, fork)...

environ 7 ans il y a | 1 réponse | 0

1

réponse

Question

How to separate a cell array based on existing strings?
I have a cell array that is 2452x5 but it has been reduced for the purpose of this question. I would like to separate the cell a...

environ 7 ans il y a | 1 réponse | 0

1

réponse

Réponse apportée
How to skip Excel files in a loop when special characters exist as sheet names?
This doesn't solve the question but provides another solution to the need. Find length of the file and instead of trying to read...

environ 7 ans il y a | 0

| A accepté

Question

How to skip Excel files in a loop when special characters exist as sheet names?
I am processing multiple excel files by getting file info, finding the last sheet, if the last sheet has 'Number' in B2, I delet...

environ 7 ans il y a | 2 réponses | 0

2

réponses

Question

Comparing two matrices to find and eliminate similarities?
This is a simplified example. I have two tables created by pulling info from multiple files, file names and size.. %Grab Fo...

environ 7 ans il y a | 1 réponse | 0

1

réponse

Question

How to only grab *.xls files, not *.xlsx or *.xlsm?
I am using the following before I run a loop and it is pulling *.xlsm files. Is there a way to cut off the call at *.xls? S...

environ 7 ans il y a | 1 réponse | 0

1

réponse

Question

Is it possible to adjust page setup options in Excel with MATLAB?
If so, I would like to access Print, Page Setup, set to Landscape, and Fit to 1 pages wide and 100 pages tall. Then print to PDF...

environ 7 ans il y a | 2 réponses | 0

2

réponses

Question

How to use activex to search Word documents for a phrase and delete the document?
I would like to search through ~100 Microsoft Word documents for a specific phrase (survey), if the document contains (survey) a...

environ 7 ans il y a | 2 réponses | 0

2

réponses

Question

How to delete all *.xlsx files in a folder that contain a specific string within the file?
I would like to read each *.xlsx file (~70) in a folder and delete each respective file containing a specific string while leavi...

environ 7 ans il y a | 1 réponse | 0

1

réponse

Question

How to pull similar data from different sized matrices?
I have matrices that are a lot of rows and 2 columns. The first column is a linspace from 1 to a lot and the second column is da...