i have excel sheet 31 coulmn,, the first coulmn is time and in the other coulmns the signals names , what i need from the code is that at spefic time to tell me for examplk
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Hagar Hendy
am 7 Dez. 2022
Kommentiert: Peter Perkins
am 12 Dez. 2022
i have excel sheet 31 coulmn,, the first coulmn is time and in the other coulmns the signals names , what i need from the code is that at spefic time to tell me for example how many ones are there and which samples of the 31 are the one at that time , how to that ?
4 Kommentare
Walter Roberson
am 7 Dez. 2022
Are the entries in the first column integers that represent nanoseconds ? You write 5.00ns but that implies potential problems if the file has 4.9995 ns or the user asks for 6 ns when you only have times in 5 ns increments (for example)
Akzeptierte Antwort
Walter Roberson
am 7 Dez. 2022
Bearbeitet: Walter Roberson
am 7 Dez. 2022
Given a particular scalar row index (calculated from the time, perhaps):
VarNames = YourTable.Properties.VariableNames;
ValuesAtIndex = YourTable{RowIndex, 2:end};
match_columns = 1 + find(ValuesAtIndex == 1);
matched_signal_names = VarNames(match_columns);
matched_signal_names will be a cell array of character vectors. It will be empty if there are no matches, and might have multiple entries if there are multiple matches.
3 Kommentare
Walter Roberson
am 7 Dez. 2022
"i have excel sheet 31 coulmn"
You cannot use load() to load a .xls or .xlsx -- it will complain about the file being in an unknown format.
You can use load() to load a .csv file only if the .csv file is pure numeric, or pure numeric with comma delimiter, or if all lines that have text begin with % in the very first column.
If you have a .csv file that has a text header that does not happen to have % as the very first character, you cannot use load() to read the file.
Peter Perkins
am 12 Dez. 2022
In recent versions, if time is involved, use readtimetable. Then use time subscripting on the timetable, and beyond that, I can't tell what the question is.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!