Ghenji

Aktiv seit 2017

Followers: 0 Following: 0

Statistik

Feeds

Frage

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

mehr als 7 Jahre vor | 2 Antworten | 0

2

Antworten

Frage

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

mehr als 7 Jahre vor | 0 Antworten | 0

0

Antworten

Frage

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

mehr als 7 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 7 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 7 Jahre vor | 1 Antwort | 0

1

Antwort

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

mehr als 7 Jahre vor | 1

| akzeptiert

Frage

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

mehr als 7 Jahre vor | 2 Antworten | 0

2

Antworten

Frage

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

mehr als 7 Jahre vor | 2 Antworten | 0

2

Antworten

Frage

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

mehr als 7 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 7 Jahre vor | 1 Antwort | 0

1

Antwort

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

mehr als 7 Jahre vor | 0

| akzeptiert

Frage

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

mehr als 7 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 7 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 7 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

mehr als 7 Jahre vor | 2 Antworten | 0

2

Antworten

Frage

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

mehr als 7 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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.

mehr als 7 Jahre vor | 1 Antwort | 1

1

Antwort

Frage

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

fast 8 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

fast 8 Jahre vor | 1 Antwort | 0

1

Antwort

Frage

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

etwa 8 Jahre vor | 1 Antwort | 0

1

Antwort