how get content of a special cell of excel?
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Hi Every one,
i have attached an excel data, which is same as main table in my program. After some calculation i become 3 strings. They exist in Column and row of attached excel data:
- 1. String ==> Part 1 or Part 2 (in the main column)
- 2. String ==> A or B (in the sub column)
- 3. String ==> Product1 or ...2 or ...3 or ...4
Now i muss used these 3 string to get "Quality" and "Performance" of a Product. For Example
- 1. String:Part 2
- 2. String:A
- 3. String:Product3
Result: Quality=21, Performance=22
Question: How can I get these two parameters (result) in accordance with three strings (input) with programming in MATLAB?
0 comentarios
Respuestas (1)
Image Analyst
el 2 de En. de 2015
Editada: Image Analyst
el 3 de En. de 2015
Did you try to make a function with those parameters, and inside call xlsread()?
function [quality, performance] = myFunction(part2, a, product3)
[numbers, strings, everything] = xlsread(filename);
% Now extract the two things you need: quality, performance....
Why don't you try something like that?
2 comentarios
Image Analyst
el 3 de En. de 2015
text() is a built-in function so don't use it for the name of one of your variables. Your column and row numbers are constantly being overwritten in the inner most part of your for loops. Put in more comments to help people follow your code. I'm not sure what the loops are for.
Somehow the program is now missing. Please reattach it so I can give further comments.
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!