Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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)
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
where A = 'Reg';