Discussions

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

Bookmark and Share Get thread feed

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

    Regards,
    Murali
    Reply to this

    Threaded Messages (2)

  2. Formatting excel sheets from servlets[ Go to top ]

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

    Prithvi!!
    Reply to this Reply to original

  3. Formatting excel sheets from servlets[ Go to top ]

    thanx..
    the same thing i too tried..

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