Excel Export with specific format

[Athira_K]

Hello,
Im trying to export a pivot table to excel using a macro,which is succesfully exported.
1.How can we calculate the mean and SD as shown in image while exporting in qlikview itself?
2.How can I export with the background colors like shown below fig 2?
3.The description is not a field that is available in qvw,so how can we add that row?
4.Also the index for reference(colour and its meaning)?
Now when I export I get the data as shown:

My requirement is to export it in the image shown below:

How can we implement it?
Thank you