topic Load color cell from Excel in QlikView https://community.qlik.com/t5/QlikView/Load-color-cell-from-Excel/m-p/171380#M41399 <HTML><HEAD></HEAD><BODY><P>Does anybody have any experience with loading the color from a range of Excel cells? I have found this example which uses VBscript (<A href="http://www.meadinkent.co.uk/excel-color-calcs.htm">http://www.meadinkent.co.uk/excel-color-calcs.htm</A>) 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.</P></BODY></HTML> Thu, 04 Nov 2010 08:20:56 GMT 2010-11-04T08:20:56Z Load color cell from Excel https://community.qlik.com/t5/QlikView/Load-color-cell-from-Excel/m-p/171380#M41399 <HTML><HEAD></HEAD><BODY><P>Does anybody have any experience with loading the color from a range of Excel cells? I have found this example which uses VBscript (<A href="http://www.meadinkent.co.uk/excel-color-calcs.htm">http://www.meadinkent.co.uk/excel-color-calcs.htm</A>) 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.</P></BODY></HTML> Thu, 04 Nov 2010 08:20:56 GMT https://community.qlik.com/t5/QlikView/Load-color-cell-from-Excel/m-p/171380#M41399 2010-11-04T08:20:56Z Load color cell from Excel https://community.qlik.com/t5/QlikView/Load-color-cell-from-Excel/m-p/171381#M41400 <HTML><HEAD></HEAD><BODY><P>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.</P><P>Wouldn't it be easier to write a macro in Exel-VBA, which does the required manipulation?</P><P>Peter</P></BODY></HTML> Sun, 07 Nov 2010 20:04:44 GMT https://community.qlik.com/t5/QlikView/Load-color-cell-from-Excel/m-p/171381#M41400 prieper 2010-11-07T20:04:44Z