Excel Format

[johnsonlim026]

Hi All,

I need to export data to excel and arrange the data according to column1.

I should group the data by column1 and draw a line fo reach group.

The excel format should look like below:

------------------------------------------------ (this is the line i need to draw)
Column1 Column2 Column3
x1
x1
x1
-----------------------------------------------(this is the line i need to draw)
x2
x2
x2
------------------------------------------------(this is the line i need to draw)


I am able to group the data but not able to draw the line by group...
Does anyone has any idea on this?

Help please!!

[johnsonlim026]

Hi my code is as below:

 Response.Write("<table>")

  Response.Write("<tr>")
     Response.Write("<td>")
        Reponse.Write("Value1")
     Response.Write("</td>")

     Response.Write("<td>")
        Reponse.Write("Valuex2")
     Response.Write("</td>")

   Response.Write("</tr>")
 Response.Write("</table>")

The excel format should look like below:

------------------------------------------------ (How to draw this line?)
Column1 Column2 |
Value1 Valuex2 |
Value1 Valuey2 |
Value1 Valuez2 |
-----------------------------------------------( How to draw this line?)
Value3 Valuex3 |
Value3 Valuey3 |
Value3 Valuez3 |
--------------------------------------------------------

Does anyone has idea on this?

[QuinnJohns]

So are you just wanting a border on just the bottom or top of cells? or does it have to extend over to the sides?

I would suggest using CSS,

.... and apply the style to the table

border-bottom-style: solid;
border-bottom-color: black;
border-bottom-width: 3px;


border-top-style: solid;
border-top-color: black;
border-top-width: 3px;

etc.

If you've never done CSS, I'd suggest googling something such as border-bottom-style css -- and go to the w3schools css site for reference. It's got lots of samples.

If this post helps, please feel free to rate it up.

Thanks,
Quinn