how to read multiple sheets of excel file using readtablle command. The way we do using xlsread(fi​leName,'sh​eet1')

4 visualizzazioni (ultimi 30 giorni)
Aakriti Srivastava
Aakriti Srivastava il 9 Giu 2022
Modificato: Voss il 9 Giu 2022
This is what I am trying to do using readtable instead of xlsread
[data,text] = xlsread(file,'Definitions'); a = readtable(file, 'Definitions')
Catchup this error
All parameters must have an associated value.

Accedi per rispondere a questa domanda.

Risposta accettata

Voss
Voss il 9 Giu 2022
% a = readtable(file, 'Definitions') % not this
a = readtable(file, 'Sheet', 'Definitions') % this
  4 Commenti
Mostra 2 commenti meno recenti
Aakriti Srivastava
Aakriti Srivastava il 9 Giu 2022
Hey Voss,
One more doubt the sheet named Definitions have numerical and text file and If I want to retrive element at 2nd row and 3rd coloumn. Would you tell me how to do that?

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Creating, Deleting, and Querying Graphics Objects in Help Center e File Exchange

Tag

Prodotti


Release

R2020a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by