Design Dynamically Generated Data for Excel Sheet

Many times you may have created excel sheet dynamically by server side script and you may have thought that for adding color and header etc. is possible only using spreadsheet software. This can be done by person who will use this generated sheet.

You can add color and other designs to your dynamically created excel file.

  • Add color with <font color="red"> red text </font>
  • Change size of the text with <font size="4"> big font</font>, and so on.
  • Merge cells of excel using colspan of table cell. This will be required for Data header, etc.
    
    <table bgcolor="yellow">
    <tr>
    <td colspan="2"> <font size="3">Header</font> </td>
    </tr>
    <tr>
    <td> data </td> <td> data </td>
    </table>
    
  • Add background color to you sheet using bgcolor.

Use style (CSS) for designing HTML data but for excel sheet you can add old traditional method for designing.

Related:
Generate excel data and prompt for download
Save Your Web Page's Visual Space

  • # 1 - by மாஹிர்

    you have done a great job…i came here from labnol…

    Best Wishes
    Mohamed Mahir
    http://techtamil.in

  • # 2 - by மாஹிர்

    you have done a great job…i came here from labnol…Best WishesMohamed Mahirhttp://techtamil.in

Comments are open for an year period. Please, write here on Facebook page.