I have to create excel file with some style like header, footer, some cell gonna merge and apply some styles, I used Epplus to generate, but it's huge cell mapping code have to write.
But I my excel sheet need to bind 200 cells, there is any better way to implement.
Throughout my experience, I always used XSLT for creating excel files. You can define styles and easily maintainable. In future, if you want to change anything, you can simply change XSL file instead of any code changes. Try once. You will love it.
Member
581 Points
253 Posts
To create Excel with style
Apr 14, 2016 07:04 AM|jayakumarvinayagam|LINK
Hi All,
I have to create excel file with some style like header, footer, some cell gonna merge and apply some styles, I used Epplus to generate, but it's huge cell mapping code have to write.
But I my excel sheet need to bind 200 cells, there is any better way to implement.
Thanks,
Contributor
6607 Points
1822 Posts
Re: To create Excel with style
Apr 14, 2016 07:10 AM|fayaz_3e|LINK
Throughout my experience, I always used XSLT for creating excel files. You can define styles and easily maintainable. In future, if you want to change anything, you can simply change XSL file instead of any code changes. Try once. You will love it.
http://www.ksaelen.be/wordpresses/dynamicsaxblog/2009/08/using-c-xml-xslt-to-create-excel-spreadsheet/
http://aspalliance.com/471_Convert_XML_To_an_Excel_Spreadsheet_Using_XSL.all