How to get the value of a single cell from excel file

[#1]

Hi All,

I have a excel file which i am trying to load into QV and attached is the sample, if you can look at the file in column D row 10 (Cell D10) we have Apr Wk1, Now my requirement is i need to just get that Apr value out of the file and display it as its showing the month.

Can someone throw any suggestions on this?

Thanks.

[Anonymous]

Hello!

Please try this code:

SingleCellTable:

Load

  @1 as SingleCellValue

From Test.xlsx

(ooxml, no labels, header is 8 lines, table is Sheet1, filters(

Remove(Col, Pos(Top, 3)),

Remove(Col, Pos(Top, 2)),

Remove(Col, Pos(Top, 1)),

Rotate(left)

));

Hope it helps.

[#3]

Hi james,

Thanks for letting me know. Okay then we can bring the data in that column D out, but can you please tell me how to display the cell value

[#4]

I have attached my application which is already using this , along with the excel file, can you please tell me how to get the value of cell BR10.( again i just want the month name which is Apr)

[#5 · Accepted solution]

Hi Andre,

Sorry i unintentionally deleted your post.But that was the one i was looking for, Thanks a lot for your help.

LOAD left(BR, 3) as CellValue

FROM (ooxml, no labels, header is 8 lines, table is [Earned])

where A = 'Reg';