Calabrese

Aktiv seit 2015

Followers: 0 Following: 0

Statistik

Feeds

Frage

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

mehr als 8 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 8 Jahre vor | 2 Antworten | 0

2

Antworten

Frage

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

mehr als 8 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 8 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 8 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 8 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 8 Jahre vor | 1 Antwort | 0

1

Antwort

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

mehr als 8 Jahre vor | 0

| akzeptiert

Frage

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

mehr als 8 Jahre vor | 2 Antworten | 0

2

Antworten

Frage

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

mehr als 8 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 8 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 8 Jahre vor | 2 Antworten | 0

2

Antworten

Frage

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

mehr als 8 Jahre vor | 2 Antworten | 0

2

Antworten

Frage

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

mehr als 8 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 10 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 10 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 10 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 10 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 10 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 10 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 10 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 10 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 10 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 10 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 10 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 10 Jahre vor | 1 Antwort | 1

1

Antwort

Frage

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

mehr als 10 Jahre vor | 1 Antwort | 0

1

Antwort