NPOI is a great component to Export data to Excel!
Thanks you all
I have a small problem with set the footer text. The footer has the current page and total page number info but I dont know how to get these.
In Excel, it has some variable such as " &[Page] " but it's not work.
sheet1.Footer.Left = "This doc. has X pages. Current page is Y"
How can I replace " X" and "Y" for the example above?
Thanks for your help