Formatting excel sheets from servlets


Web tier: servlets, JSP, Web frameworks: Formatting excel sheets from servlets

  1. Formatting excel sheets from servlets (2 messages)

    Hi Buddies,

            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..

  2. Hi! Murali..
    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..

  3. thanx..
    the same thing i too tried..

    here also i got one hurdle. is there any way to pass parameters dynamically to the macros.