Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

jyothish8807
Honored Contributor II

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

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

Best Regards,
KC
12 Replies
jyothish8807
Honored Contributor II

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

Hmm....So there is no way to get the colours...????

Best Regards,
KC
anantmaxx
Valued Contributor

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

No thats not possible .. as far as i know

Regards,

anant

jyothish8807
Honored Contributor II

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

Dammm .....

So is there any other way by which I can achieve my requirements..??

Best Regards,
KC
azimabadi
Contributor III

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

Hi,

if the data structure in excel is not complicated and you can do a pre proccess on excel file before loading in QV, you can add some columns to Excel file and use excel functions such as ColorIndex(A3) to get the colors of cells in two new columns. then you can read it and process the color info in your QV app.

Best Regards

Peyman

anantmaxx
Valued Contributor

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

you can iport put your excel data into qlikview once loaded put in pivot/staright table

then you can expand your dimension or expression and put color function red() or green()

Regards,

anant

jyothish8807
Honored Contributor II

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

Can you please explain a little more..?? Colorindex() function is giving an Error msg.

Best Regards,
KC
jyothish8807
Honored Contributor II

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

No, This is not gonna work. I have a huge amount of data which is categorized on color basis, cant do on a pivot table.

Best Regards,
KC
azimabadi
Contributor III

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

i will make a sample excel file and attach in next response asap

Regards

Peyman

jyothish8807
Honored Contributor II

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

Thanx Alot..

Best Regards,
KC