I have got some reports and i export the datas of those to excel sheets from my servlets. This is done.
Also i have to format those excel sheets like setting a header,footer etc., anybody got solution for this..
U can do one thing..As u have the exel sheet u can format it as u want manually & record a macro while formating it..This macro u can save and give a option to download this macro to the user & the user only has to download & run this macro on the generated exel document & he will get the formated document..
i dont know whether this will solve ur purpose or not..
the same thing i too tried..
here also i got one hurdle. is there any way to pass parameters dynamically to the macros.