Need to show Data in excel format using c#, Asp.net.

Jan 8 2021 1:35 PM
I have a data fetched from sql server in datatable using c# and Need to show in excel sheet in specific format.
Below is the data.
 
Hatch
Deck Orgzn Num
       
H1 A 9J 37
H1 A AY 105
H1 A KO 12
H1 A KV 68
H2 A ZL 62
H2 A UU 20
H4 A DO 281
H4 A SA 95
H1 B 1Z 69
H1 B 7V 49
H3 B K0 20
H4 B 1Z 69
H4 B 7V 49
H4 B K0 20
. . . .
. . . .
. . . .
N N N N
 
 
 
Expected Excel sheet format::
 

Answers (1)