Last post Oct 08, 2014 10:12 AM by AidyF
Oct 08, 2014 10:00 AM|Pegudo|LINK
Nice day for all of you.
I wanna export some data from MySql to Excel, allowing user make download it to your own pc.
I wanna that program make export by dataset or datatable, directly.
There's any way to do this?
Oct 08, 2014 10:12 AM|AidyF|LINK
Look into the Open XML SDK or Aspose, both are libraries that let you create Office files. If you're desperate you can also look at the OLEDB Excel provider which lets you treat Excel sheets like databases, and create rows using INSERT statements.
They're you only real options though with the Open XML SDK probably being your best bet.