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.
jayakumarvin...
Member
548 Points
230 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,
fayaz_3e
Contributor
6597 Points
1823 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