필터 지우기
필터 지우기

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

조회 수: 1 (최근 30일)
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?

채택된 답변

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

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by