photo

Ghenji


Attivo dal 2017

Followers: 0   Following: 0

Statistica

  • Thankful Level 3

Visualizza badge

Feeds

Visto da

Domanda


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

oltre 6 anni fa | 2 risposte | 0

2

risposte

Domanda


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

oltre 6 anni fa | 0 risposte | 0

0

risposte

Domanda


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

oltre 6 anni fa | 1 risposta | 0

1

risposta

Domanda


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

oltre 6 anni fa | 1 risposta | 0

1

risposta

Domanda


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

oltre 6 anni fa | 1 risposta | 0

1

risposta

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

oltre 6 anni fa | 1

| accettato

Domanda


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

oltre 6 anni fa | 2 risposte | 0

2

risposte

Domanda


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

oltre 6 anni fa | 2 risposte | 0

2

risposte

Domanda


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

oltre 6 anni fa | 1 risposta | 0

1

risposta

Domanda


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

oltre 6 anni fa | 1 risposta | 0

1

risposta

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

oltre 6 anni fa | 0

| accettato

Domanda


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

quasi 7 anni fa | 1 risposta | 0

1

risposta

Domanda


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

quasi 7 anni fa | 1 risposta | 0

1

risposta

Domanda


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

quasi 7 anni fa | 1 risposta | 0

1

risposta

Domanda


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

quasi 7 anni fa | 2 risposte | 0

2

risposte

Domanda


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

quasi 7 anni fa | 1 risposta | 0

1

risposta

Domanda


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.

quasi 7 anni fa | 1 risposta | 1

1

risposta

Domanda


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

circa 7 anni fa | 1 risposta | 0

1

risposta

Domanda


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

circa 7 anni fa | 1 risposta | 0

1

risposta

Domanda


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

circa 7 anni fa | 1 risposta | 0

1

risposta