Can one let Matlab to remove lines of the spreadsheet before the data?

1 visualización (últimos 30 días)
alpedhuez
alpedhuez el 6 de Dic. de 2020
Comentada: alpedhuez el 6 de Dic. de 2020
I have a spreadsheet "visitors.xlsx" like
title of the spreadsheet: daily visitors
source: state
date visitors
January 1 2020 100
January 2 2020 50
A brute force is that I open spreadsheet by Excel and remove the first two rows by myself and then let Matlab read the table. But is it possible that one let Matlab read "visitors.xlsx" and delete the first two lines?

Iniciar sesión para responder a esta pregunta.

Respuesta aceptada

Image Analyst
Image Analyst el 6 de Dic. de 2020
[~, ~, raw] = xlsread(filename);
raw = raw(3:end, :); % Extract starting at row #3.
Save it again if you want to.

Más respuestas (0)

Categorías

Más información sobre Spreadsheets en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by