Data export to excel in requisite format

[gfaryd]

Main_id north
sr_no, detail,sr no, detail, sr_no detail

1 123 6 153 11 923
2 123 7 163 12 123
3 123 8 173 13 546
4 123 9 183 14 234
5 123 10 143 15 878

page break
Main_id south
sr_no, detail,sr no, detail, sr_no detail

1 123 6 153 11 923
2 123 7 163 12 123
3 123 8 173 13 546
4 123 9 183 14 234
5 123 10 143 15 878


in 5 rows and six column group by main id with page break when new main_id starts .

how to achive this

[BioPhysEngr]

Not sure about the page break; check the documentation to the libraries below.

This library may be helpful: http://code.google.com/p/excellibrary/

See also this post on stackoverflow (where I found the ExcelLibrary link) that may be related to your question: http://stackoverflow.com/questions/1...sx-file-from-c

If you scroll down, there are some blog posts that someone comments were quite useful.

Hope that helps a little. Good luck!