how to create headers in Excel report?

[redsanjay]

Im trying to create header for excel report which is being generated from Alteryx. I have explored few related topics but still i could not get that.

I am trying to create something like this, Kindly help me.

Alteryx flow attached.

Thank you, 

[Ladarthure · Accepted solution]

Hi, I did a sample workflow for your case, the thing is to use report text to have the headers and then create a layout, pluys reporting tools work mostly with other reporting tools.

Hope it helped!

[redsanjay]

Thank you, it worked..!!

[redsanjay]

Hi, 

when I see the results in browse tool it looks good, But when I output the data to excel file I could not see the data.

I have attached the  workflow. Please suggest.

Thank you

[Ladarthure]

@redsanjay hi, to have the proper report, you should use the render tool which gives you the result you want, the output file only output a bit of code and not the report itself (it's the tool under the browse), I made it make a temporary file, but you could save it where you wish.

[isrivastava]

Spoiler

@Ladarthur Can you tell me how to create sheets within same excel file.In this case I want sheet1,sheet 2,sheet3 for example.