XLSX import for custom range with unknown end and providing name of columns from not first row
12 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
I am importing .xlsx file into MatLab (file is provided) by using following command.
Input1 = readtable('OutputFile.xlsx','sheet',2);
There I am interested only in second sheet and custom range 17:end,[7,23:end]. The problem is that this file is generated automatically and I never know which will be the end range values. Is it possible to add the custom range for import? The 'Range' command provides only known end imports.
Do I have to import it normaly, then create new table with additional command?
If yes, then I have another problem. As soon as I import the custom range, I want first row to be considered as name of columns. There is no such command as 'ReadRowName', true as in readtable.
I tried something like that but it is not working
WorkData = Input1(17:end,[7,23:end], 'ReadRowNames', 'true');
0 Commenti
Risposte (1)
Mohith Kulkarni
il 25 Ago 2020
Hi, I can see that you are unable to determine the range of the data as it is varying. You would like to read the rows and columns of your choice. You can use detectImportOptions to modify the import options. Here, 'detectImportOptions' returns an spreadsheetImportOptions object which contains all the import options, including the 'VariableNames' input option. Refer to the readtable function for more information. Refer to the following code.
opts = detectImportOptions('OutputFile.xlsx','sheet',2);
opts.DataRange = [7 Inf]; %rows;
cols = length(opts.VariableNames); %finding number of columns;
opts.SelectedVariableNames = [7, 23:cols];
Input1 = readtable('OutputFile.xlsx',opts);
0 Commenti
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!