You can’t directly return a file for download via an AJAX call so, an alternative approach is to to use an AJAX call to post the related data to your server. You can then use server side code to create the Excel File (I would recommend using EPPlus or NPOI for this although it sounds … Read more
excel4node is a maintained, native Excel file creator built from the official specification. It’s similar to, but more maintained than msexcel-builder mentioned in the other answer. // Require library var excel = require(‘excel4node’); // Create a new instance of a Workbook class var workbook = new excel.Workbook(); // Add Worksheets to the workbook var worksheet … Read more
I’m going to throw my hand in for flat csv files, if only because you’ve got the greatest control over the code. Just make sure that you read in the rows and process them one at a time (reading the document to the end and splitting will eat up all of your memory – same … Read more
Tools > Options > Query Results > SQL Server > Results to Text (or Grid if you want) > Include columns headers in the result set You might need to close and reopen SSMS after changing this option. On the SQL Editor Toolbar you can select save to file without having to restart SSMS