Microsoft
Policy
Questions and answers to issues related to Microsoft: Windows, Applications, Development, Hardware, Server, Internet Protocols, Database, Exchange .
»
Development
»
.NET
»
Visual C Sharp
»
Export DataView to Excel Spreadsheet with C#
Export DataView to Excel Spreadsheet with C#
Hello Experts,
I am using the code below to export a DataView to a CSV file. I would prefer to export the dataview into an Excel Spreadsheet because ultimately the data is being used as a datasource for a mail merge. It appears that I cannot use a CSV as a datasource for a mail merge so currently I have a procedure that inserts this data into a Word.doc-- however, it takes a long time to create this Word.doc. I would like to cut out the middle step and believe performance will be better if I use an .xls as opposed to .doc for the datasource.
How can I create a spreadsheet from a DataView?
StreamWriter outputFile = new StreamWriter("c:\\"+fileNa
me+".csv")
;
string delim;
//write Header Row
delim = "";
foreach (DataColumn col in dv.Table.Columns)
{
outputFile.Write(delim);
outputFile.Write(col.Colum
nName);
delim = ",";
}
outputFile.WriteLine();
//write data into each row
foreach (DataRowView row in dv)
{
delim = "";
foreach (object item in row.Row.ItemArray)
{
outputFile.Write(delim);
outputFile.Write(item);
delim = ",";
}
outputFile.WriteLine();
}
outputFile.Close();
Thanks for your help.
internet advertising
Solution: Export DataView to Excel Spreadsheet with C#
use SaveAs method of Excel.WorkBook object
E.g.
// Instantiate Excel and start a new workbook.
objApp = new Excel.Application();
objBooks = objApp.Workbooks;
objBook = objBooks.Add( Missing.Value );
Then use
objBook.SaveAs(@"C:\folder
\Book1.xls
", m_objOpt, m_objOpt,
m_objOpt, m_objOpt, m_objOpt, Excel.XlSaveAsAccessMode.x
lNoChange,
m_objOpt, m_objOpt, m_objOpt, m_objOpt);
Popular Tags
.NET
Tags:
2.0
2005
2008
application
Asp.net
C#
C# .NET
C#.NET
datagridview
file
form
IE
javascript
linq
Microsoft
string
update
VB.NET
VC#
Visual Basic.net
Visual C#
Visual C#.net
visual studio
Visual Studio 2005
Visual Studio 2008
windows
winform
xml
Browse All Tags