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!