photo

Calabrese


2015년부터 활동

Followers: 0   Following: 0

통계학

  • First Review
  • Thankful Level 4

배지 보기

Feeds

보기 기준

질문


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

대략 7년 전 | 답변 수: 1 | 0

1

답변

질문


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년 전 | 답변 수: 2 | 0

2

답변

질문


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년 전 | 답변 수: 1 | 0

1

답변

질문


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년 전 | 답변 수: 1 | 0

1

답변

질문


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년 전 | 답변 수: 1 | 0

1

답변

질문


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년 전 | 답변 수: 1 | 0

1

답변

질문


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년 전 | 답변 수: 1 | 0

1

답변

답변 있음
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년 전 | 0

| 수락됨

질문


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년 전 | 답변 수: 2 | 0

2

답변

질문


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년 전 | 답변 수: 1 | 0

1

답변

질문


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년 전 | 답변 수: 1 | 0

1

답변

질문


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년 전 | 답변 수: 2 | 0

2

답변

질문


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년 전 | 답변 수: 2 | 0

2

답변

질문


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년 전 | 답변 수: 1 | 0

1

답변

질문


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

거의 9년 전 | 답변 수: 1 | 0

1

답변

질문


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

거의 9년 전 | 답변 수: 1 | 0

1

답변

질문


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

거의 9년 전 | 답변 수: 1 | 0

1

답변

질문


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

거의 9년 전 | 답변 수: 1 | 0

1

답변

질문


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

거의 9년 전 | 답변 수: 1 | 0

1

답변

질문


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

대략 9년 전 | 답변 수: 1 | 0

1

답변

질문


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

대략 9년 전 | 답변 수: 1 | 0

1

답변

질문


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

대략 9년 전 | 답변 수: 1 | 0

1

답변

질문


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

대략 9년 전 | 답변 수: 1 | 0

1

답변

질문


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년 전 | 답변 수: 1 | 0

1

답변

질문


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년 전 | 답변 수: 1 | 0

1

답변

질문


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년 전 | 답변 수: 1 | 1

1

답변

질문


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년 전 | 답변 수: 1 | 0

1

답변