Using spreadsheetDatastore to import from spreadsheets with varying size

3 views (last 30 days)
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?

Answers (0)

Community Treasure Hunt

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

Start Hunting!