Your spreadsheet doesn't really lend itself well to creating a dataset with the way the headers are arranged. Merged cells don't exist in datasets, either.
I recommend moving / removing items that are not related to the dataset.
Production Plan-revised headers.xlsx (15.2 KB)
I was then able to import directly from the excel file. using the function provided here:
path = system.file.openFile('xlsx')
dataset = util.excelToDataSet(path, hasHeaders = True, firstRow = 2, firstCol = 1, lastCol = 9)
event.source.parent.getComponent('Power Table').data = dataset
