Is it possible to load Colored cells of an excel sheet.?

[Pulkit_Thukral]

Input- An excel file with status field  shown in color codes and not figures.(Ex- >80%-Green color cell,<80% -red color cell).

Question- how to load  this color coded value of cells in qlik view scripting ??

[Gysbert_Wassenaar]

That's not possible. The formatting of an excel cell is not imported, only the value. You'll have to recreate the color calculation in Qlikview. You could for example add a field in the script in the load statement:

LOAD

     Value,

     If(Value < 0.8, rgb(255,0,0), rgb(0,255,0)) as Color

FROM

     ...MyExcelFile...;

You can use the Color field in an expression for the Background Color option of a chart expression. Click on the + in front of the expression on the Expressions tab of the charts properties window. Select the Background Color option and add as color expression =only(Color)

[Pulkit_Thukral]

Thanks for the reply.

In the excel file only informatory field is shown in colors.

Hence,we cannot use iif value <x ,red or green.

My aim is ti find a mapping for all colors at qlikview level..but how to load those colors to qv is npt possible as per you.