topic Reading in specific cells from an Excel sheet - position-independent? in QlikView

Reading in specific cells from an Excel sheet - position-independent?

datanibbler — Thu, 23 May 2013 07:04:46 GMT

Hi,

I have to read data from an Excel Workbook. From one sheet, I need only two cells. Both are identified by a text in the cell before: If e.g. in column O, there is the text "Goal_2013", I need the cell in the same row, column P.

Can I somehow make that independent of the exact position of those cells in the sheet?

Thanks a lot!

Best regards,

DataNibbler

Re: Reading in specific cells from an Excel sheet - position-independent?

sushil353 — Thu, 23 May 2013 07:17:43 GMT

might be possible.. Please post the sample data file for experiment.

Re: Reading in specific cells from an Excel sheet - position-independent?

datanibbler — Thu, 23 May 2013 07:55:25 GMT

Hi sushil,

well, I attach a sample file, but it's not worth much - the scenario only encompasses two cells, so I have populated just two cells, in this instance A1 and B1 - but I want the logic to also work when I have those values in, say, D35 and E35 - two cells side by side in the same row, regardless of column.

Thanks a lot!

Best regards,

DataNibbler

Re: Reading in specific cells from an Excel sheet - position-independent?

sushil353 — Thu, 23 May 2013 10:18:20 GMT

Using the inbuilt transformation steps it is possible..

but please provide the proper data table and scenario..

Regards,

Sushil

Re: Reading in specific cells from an Excel sheet - position-independent?

datanibbler — Thu, 23 May 2013 10:23:56 GMT

Hi sushil,

thanks a lot for helping!

I cannot provide the actual Excel workbook, there is a lot of sensitive data in there - but my question regards only those two cells. I really don't see what is the point of having the actual sheet?

Best regards,

DataNibbler