I have Data stored in DataTables and I'm trying to write that data into a .xlsx file, with multiple sheets. I don't how to go about it. Thanks
-
2Please google, there are examples on this site and many others - what have you looked atBugFinder– BugFinder2016-04-27 14:32:06 +00:00Commented Apr 27, 2016 at 14:32
-
I think this answer will satisfy your question: stackoverflow.com/a/2603625/6241884T. Frick– T. Frick2016-04-27 14:32:42 +00:00Commented Apr 27, 2016 at 14:32
Add a comment
|
1 Answer
Among many others, one way could be to use Visual Studio Tools for Office (VSTO) to remote-control Excel. Another way would be to create an empty template XSLX file and fill that using OLEDB, for example described here. Or you could use one of the many libraries out there that do that.