Transposing sheet before entering into DataFrame

[IanButterworth]

I'm working with some excel files that are organized with row-based fields, rather than the normal column-based fields. The problem is that once the data is inserted into a DataFrame, it's surprisingly difficult to transpose a DataFrame given the type allocations etc.

Is there a way to transpose the load() function?

i.e.

df = DataFrame(load("data.xlsx", "Sheet1",transpose=true))