Calabrese

Attivo dal 2015

Followers: 0 Following: 0

Statistiche

Feeds

Domanda

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

oltre 6 anni fa | 1 risposta | 0

1

risposta

Domanda

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

quasi 7 anni fa | 2 risposte | 0

2

risposte

Domanda

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

quasi 7 anni fa | 1 risposta | 0

1

risposta

Domanda

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

quasi 7 anni fa | 1 risposta | 0

1

risposta

Domanda

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

quasi 7 anni fa | 1 risposta | 0

1

risposta

Domanda

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

quasi 7 anni fa | 1 risposta | 0

1

risposta

Domanda

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

quasi 7 anni fa | 1 risposta | 0

1

risposta

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

quasi 7 anni fa | 0

| accettato

Domanda

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

quasi 7 anni fa | 2 risposte | 0

2

risposte

Domanda

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

quasi 7 anni fa | 1 risposta | 0

1

risposta

Domanda

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

quasi 7 anni fa | 1 risposta | 0

1

risposta

Domanda

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

quasi 7 anni fa | 2 risposte | 0

2

risposte

Domanda

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

quasi 7 anni fa | 2 risposte | 0

2

risposte

Domanda

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

quasi 7 anni fa | 1 risposta | 0

1

risposta

Domanda

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