Read data from Excel Sheet Along With Colour ( Font Colour & Background Colour )

[jyothish8807]

Hi Friends,

               I are working on an assignment in which i collect data on an excel sheet and categories them on the basis of particular color.

Now I want to consolidate all workbooks along with the color given in excel sheet.

So please let me know is it possible to get data from excel sheet in to Qlikview along with the color given to it in Excel Sheet. ( Both Font color & Background Color ).

Regards

Jyothish KC

[azimabadi]

Ok,

please notice that i have two Functions in my Excel File defined:

Function CellBGColor(Optional myCell As Range)

    CellBGColor = myCell.Interior.ColorIndex

End Function
Function CellFontColor(Optional myCell As Range)

    CellFontColor = myCell.Font.ColorIndex

End Function

Regards

Peyman

[jyothish8807]

Thanx for the reply, but this not going to help me... , I want data along with the color in QV.

[azimabadi]

first you need to read color information from excel. as mentioned you cen produce color info with two functions in excel.

then you need to read this color data alonwith your main data.

in QlikView you need to map the color data from excel to QV colors and atlast you usr this translated color info in background expression or everywhere you need it.

Regards

Peyman