How I can import correctly a xls sheet?

May 15, 2017 BI News and Info

I have one excel file with a sheet “OK”.

I need to import the file, i tried:

s = Import["sales.xls", {"Sheets", "OK"}]

header1 = s[[1]];

data = s[[3 ;;]];

sDataset = Thread[header -> #] & /@ data // Map[Association]

But didn’t work because the column headers are in the row 1 and 2 after the column 1. I need:

1.) SALES, GM, %GM and EBITDA pear YEAR per MONTH.

Ideas? Thanks!

Let’s block ads! (Why?)