Create an export to Excel functionality.

Jorriss / StatisticsParser

Parses and formats SQL Server Statistics IO and Statistics Time output.

http://statisticsparser.com

89 stars 42 forks source link

Create an export to Excel functionality. #1

Open Jorriss opened 11 years ago

nycdotnet commented 9 years ago

Just saw that this was on GitHub.

You may be able to take advantage of this with just a few changes: https://github.com/nycdotnet/TSqlFlex/blob/master/Code/TSqlFlex.Core/XmlSpreadsheetRenderer.cs

The XML Spreadsheet schema is very easy to use (it's just a text file), opens in Excel as a real spreadsheet without mangling everything like CSVs do, and supports data types and simple formatting such as bold.

jzabroski commented 8 years ago

This should be done in pure JavaScript, IMHO. See:

https://github.com/jmaister/excellentexport