tags:

views:

5

answers:

0
Q: 

Export DataGrid for use in Excel

Does anybody have a sample of how to export a paged DataGrid so that it can be used in Excel (csv or Xml)?

All of the examples I've seen so far can only output the currently displayed data, not the whole set or use automation.

related questions

Setting a cell's format using Excel 2007 Interop and C#
Where should I post my python code?
excel: charting with unknown number of data
Read specific Coloumns from Excel files with C#
add decimal as time
How to display .net automation add-in functions in excel's formula autocomplete
Excel formula to refrence 'CELL TO THE LEFT'
Problems Reading a .xlsx file?
VBA code for SUMIFS?
Accessing Excel 2007 Binary (.xlsb) via OleDb ACE
How can I permanently prevent Excel from setting all new documents to R1C1 mode?
How do get the index of a table's column by using a structured reference in excel?
Can I make a structured reference absolute in excel 07?
Excel countif Pulling apart a cell to do different things
Upgrade from Excel 2003 to 2007 results in "stack overflow error" on previously working vba
System.Windows.Forms.ToolStrip height or autosize
VSTO problem - cannot create visual studio excel workbook project
Round function in Excel, worksheet function vs VBA
Reliable real values generator for Excel for Office 2007 and Vista SP1
Create an Excel workbook on a x64 system
How to import data from Excel 2007 xlsx file into SQL Server 2000 Database?
How do I send an alert to a blackberry from an Excel 2007 spreadsheet?
How to convert a column number (eg. 127) into an excel column (eg. AA)
How do I create an Excel chart that pulls data from multiple sheets?
VSTO Excel 2007 PivotTable, having a PivotField in more than one column