Community Profile

photo

Calabrese


Active since 2015

Followers: 0   Following: 0

Statistics

  • First Review
  • Thankful Level 4

View badges

Feeds

View by

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

6 years ago | 1 answer | 0

1

answer

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

7 years ago | 2 answers | 0

2

answers

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

7 years ago | 1 answer | 0

1

answer

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

7 years ago | 1 answer | 0

1

answer

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

7 years ago | 1 answer | 0

1

answer

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

7 years ago | 1 answer | 0

1

answer

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

7 years ago | 1 answer | 0

1

answer

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

7 years ago | 0

| accepted

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

7 years ago | 2 answers | 0

2

answers

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

7 years ago | 1 answer | 0

1

answer

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

7 years ago | 1 answer | 0

1

answer

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

7 years ago | 2 answers | 0

2

answers

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

7 years ago | 2 answers | 0

2

answers

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

7 years ago | 1 answer | 0

1

answer

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

8 years ago | 1 answer | 0

1

answer

Question


Error using copyfile from a changing directory
I am pulling a file to read in from an always changing directory. I would like to copy this file into a directory I have it for ...

8 years ago | 1 answer | 0

1

answer

Question


Can I pull a file from any folder to process?
I am wondering if I can pull a file from any folder on my computer? I am using uigetfile currently but the file has to be in a s...

8 years ago | 1 answer | 0

1

answer

Question


How to reformat GUI for different devices
I have a GUI I created on my laptop but when I load it on others the sizing is all off. Is there a way I can load it to any comp...

8 years ago | 1 answer | 0

1

answer

Question


How to position a GUI centered on the desktop
I am trying to center my GUI on the desktop but I am not sure where in the code I put the command I am using movegui('c...

8 years ago | 1 answer | 0

1

answer

Question


How to freeze specific function with a view mode in a GUI?
I have created a GUI that I use plot data, select sections and process selections. Later I look at the processed data and notice...

8 years ago | 1 answer | 0

1

answer

Question


How to add data into the first row of an existing excel sheet and shift the existing data down
I am adding data to excel daily. Originally I would add a new row to the end to many excel files and sheets using xlswrite. ...

8 years ago | 1 answer | 0

1

answer

Question


How to boxplot already determined statistics with whiskers
I have the mean, min, max, and std. values for many processed excel files. Each file has a date associated with it and I am try ...

8 years ago | 1 answer | 0

1

answer

Question


Append a file, Error using save, File may be corrupt
I am attempting to append either a cell or structure to a file, I have tried both, to either an .xlsx or .mat file, I have tried...

8 years ago | 1 answer | 0

1

answer

Question


Import multiple data files and assign to variables
I would like to import multiple data files and assign their contents to a variable. BurnIn_2ndary_20150527_1940.mat Burn...

9 years ago | 1 answer | 0

1

answer

Question


Saving a variable to a continuously changing file name
I would like to save a variable to a file/filename that relates to a previously loaded filename and repeat the code with a new f...

9 years ago | 1 answer | 0

1

answer

Question


Is it possible to brush data on a plot and have it assigned to a variable immediatly after brushing instead of having to save it manually?
I would like to plot data, once plotted I would be directed to brush the data I want to use. Following the brush I would like to...

9 years ago | 1 answer | 1

1

answer

Question


Create a plot with a table on it where I can select 1 to multiple sets of data to be plotted
I am trying to use uicontrol but I haven't been able to get my data to plot with my selection. I have tried multiple different m...

9 years ago | 1 answer | 0

1

answer