Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Load color cell from Excel

Does anybody have any experience with loading the color from a range of Excel cells? I have found this example which uses VBscript (http://www.meadinkent.co.uk/excel-color-calcs.htm) and works but it can only be applied to a single cell in the same worksheet. I have serveral worksheets with different ranges (both in columns and rows) of coloured cells, so I'm looking for a more scaleable solution.

1 Reply
prieper
Honored Contributor II

Load color cell from Excel

Have no experience, but within VB it is possible to open an instance of Excel, reawrd each cell individually, apply a formula - like the quoted ones - and to pick the cells one-by-one. Alternatively the entire manipulated Excel might be saved under temporary name and then read as entire file into QV.

Wouldn't it be easier to write a macro in Exel-VBA, which does the required manipulation?

Peter