Here is sample VB net project to display data on MS FlexGrid and then export to MS Excel file.
why using FlexGrid, not DataGrid? because FlexGrid support to Merge cells. but we must be careful when merge cell in FlexGrid, sometime we need to do a little trick to do this (merge cell) in FlexGrid.
There is a Template file in debug folder. here is :
When we Export, the template file has been copied to the new file, then we fill the data to that new file. Here is the result :
so here is the link for the project: goo.gl/zvjbR4
Thanks..http://news.chivindo.com/778/learn-how-to-merge-flexgrid-and-export-to-excel.html
why using FlexGrid, not DataGrid? because FlexGrid support to Merge cells. but we must be careful when merge cell in FlexGrid, sometime we need to do a little trick to do this (merge cell) in FlexGrid.
There is a Template file in debug folder. here is :
When we Export, the template file has been copied to the new file, then we fill the data to that new file. Here is the result :
so here is the link for the project: goo.gl/zvjbR4
Thanks..http://news.chivindo.com/778/learn-how-to-merge-flexgrid-and-export-to-excel.html
Comments
Post a Comment