Printable View
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
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!