Community Profile

photo

Ghenji


Active since 2017

Followers: 0   Following: 0

Statistics

  • Thankful Level 3

View badges

Feeds

View by

Question


concatenate cell array of cell arrays
I have got this cell variable with 10 cell arrays. It is possible to horizontally concatenate them if the dimension is consisten...

6 years ago | 2 answers | 0

2

answers

Question


Get single value of merged cell after active cell
<</matlabcentral/answers/uploaded_files/117445/2018-05-14_11h25_34.png>> I have got this excel data and would like to access ...

6 years ago | 0 answers | 0

0

answers

Question


export_fig generates figure even after pressing cancel
following is the code i use to save the figure in required format, but it produces figure even after pressing cancel button. How...

6 years ago | 1 answer | 0

1

answer

Question


problem with nested function in GUIDE
I have got following set of code - It is basically functioning based on the plot data obtained previously. Main function gets ...

6 years ago | 1 answer | 0

1

answer

Question


Possible solution to this problem
I have got variable A as, A = {'char1', 'char2'}; %could be char3, char4, char5....so on There would always be two eleme...

6 years ago | 1 answer | 0

1

answer

Answered
Searching particular string in an excel spreadsheet
This worked for me. Range.Find('String', [], [], 1) Since the position for LookAt is 4th and I need xlWhole. xlWhole =...

6 years ago | 1

| accepted

Question


Searching particular string in an excel spreadsheet
What are the options other than 'Range.Find' to search for a string in a spreadsheet? Am using actxserver('Excel.Application'). ...

6 years ago | 2 answers | 0

2

answers

Question


method to check for similarity using if...else loop
I have got a cell arrays as like - selected_item = 'item3'; total_items = {'item1', 'item2', 'item3', item4', 'item5', ...

6 years ago | 2 answers | 0

2

answers

Question


Reading multiple cells after merged cell from excel sheet
Cells A1 and B1 are merged. Now when I read Cells A1 and B1 with Excel COM Application, they read 'Waste Accumulation'and 'NaN' ...

6 years ago | 1 answer | 0

1

answer

Question


Search string and get its position in excel using Actxserver
Is it possible to search for a string in an excel file from particular sheet and also get its position. I need to get data only ...

6 years ago | 1 answer | 0

1

answer

Answered
Execute files from listbox one by one
well I was able to get answer to this. Problem was undefined path for the files. Needed following changes - [filename,pathn...

6 years ago | 0

| accepted

Question


Actxserver reading only first file
working with this code- get_files = cellstr(get(handles.listboxfiles,'String')); len = length(get_files); fo...

6 years ago | 1 answer | 0

1

answer

Question


Avoid overwriting value of variable
I am having following code: Source_files = [specified directory] len = length(Source_files); for j = 1 : len ...

6 years ago | 1 answer | 0

1

answer

Question


Execute files from listbox one by one
GUI load some files using _Pushbutton1_ inside _Listbox1_. Now i have got another _pushbutton2_ to select all the files populate...

6 years ago | 1 answer | 0

1

answer

Question


Is it possible to detect color of sheet tab with actxserver?
I have got excel data files and would like to read data only from the spreadsheets having Green color. So in total i would be ha...

6 years ago | 2 answers | 0

2

answers

Question


Loop through data from Listbox
I have GUI which loads name of excel files inside listbox. Now I want a loop which can go through each file in the listbox and r...

6 years ago | 1 answer | 0

1

answer

Question


Get information from Excel file based on cell color
How can i get information of the cell fill in an excel file. Like there could be more than one cell coloured.

6 years ago | 1 answer | 1

1

answer

Question


Select all the data in listbox using single click of pushbutton
I have a GUI with 3 pushbuttons(Load, Select All & Extract)and listboxDATA. I am able to import data in the listbox using load b...

6 years ago | 1 answer | 0

1

answer

Question


Need name of particular 'nth' sheets
I would like to get names of only highlighted sheets. There are about 50 excel files I will load these files together using push...

6 years ago | 1 answer | 0

1

answer

Question


Search for excel spreadsheet with name or symbol
I am working with Guide and looking for the code that can help me search particular excel spreadsheet. suppose there are 7 sheet...

6 years ago | 1 answer | 0

1

answer