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
답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!