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!