필터 지우기
필터 지우기

Using spreadsheetDatastore to import from spreadsheets with varying size

조회 수: 1 (최근 30일)
Hi,
So I would like to import a set of excelfiles data, structured in the same way but some with more amounts of data than the previous.
Basically what I would like is:
data = spreadsheetDatastore('folderDir',...
'Range','C11: *EndOfData*');
Where the data always starts at C11 but could end at G560, Y760 and so on, depending on the file.
Example data:
AnläggningsID 1408 9541
Adress DH48 DH50
Ort Uppsala Uppsala
Nätområde UPP UPP
Enhet kWh kWh
2015-10-01 01 5,52 0,00
2015-10-01 02 7,02 0,00
2015-10-01 03 6,39 0,00
2015-10-01 04 6,42 0,00
2015-10-01 05 8,28 0,00
2015-10-01 06 6,45 0,00
2015-10-01 07 7,95 0,00
2015-10-01 08 8,58 0,00
2015-10-01 09 9,33 0,00
2015-10-01 10 8,04 0,00
2015-10-01 11 7,65 0,00
2015-10-01 12 6,87 0,00
Sometimes the data would consist of more rows and one or more columns.
Is there an easy way to solve this with spreadsheetDatastore?

답변 (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