Knowledgebase (2330)
Children categories
The aim of the article is to introduce the procedure of exporting data into Office OpenXML in only two steps with a .net component. Spire.DataExport is a completely pure .NET component suit for exporting data into MS Excel, MS Word, HTML, Office OpenXML, PDF, MS Access, DBF, RTF, SQL Script, SYLK, DIF, CSV, MS Clipboard format. It has high performance for exporting data from Command, ListView, DataTable components, which help you to save much time and money.
Please download Spire.DataExport for .NET, add Spire.DataExport.dll as reference and set its target framework as .NET 4. Besides, many developers also check and download another C# excel component together - Spire.XLS for .NET.
Step1: Function to fill data in datatable
In this step, Spire.DataExport will help to load Data information from the datatable. After setting up the data source and SQL command, we can even preview and modify data through DataGridVew before exporting.
private void Form1_Load(object sender, EventArgs e)
{
oleDbConnection1.ConnectionString = txtConnectString.Text;
oleDbCommand1.CommandText = txtCommandText.Text;
using (OleDbDataAdapter da = new OleDbDataAdapter())
{
da.SelectCommand = oleDbCommand1;
da.SelectCommand.Connection = oleDbConnection1;
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
}
}
Check the Screenshot below:
Step2: Export Data to Office OpenXML
The code below shows how to export data from the datatable to Office OpenXML. Spire.DataExport will create a new Office OpenXML and export data into Office OpenXML through DataGridView. It also allows you to rename the generated Office OpenXML in this step.
private void btnExportToXml_Click(object sender, EventArgs e)
{
Spire.DataExport.XML.XMLExport xmlExport = new Spire.DataExport.XML.XMLExport();
xmlExport.DataSource = Spire.DataExport.Common.ExportSource.DataTable;
xmlExport.DataTable = this.dataGridView1.DataSource as DataTable;
xmlExport.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
xmlExport.FileName = @"..\..\ToXml.xml";
xmlExport.SaveToFile();
}
Check the Screenshot below:
This article will show you a clear introduction of how to Export Data to MS Access in C# via a .NET Data Export component. Spire.DataExport for.NET is designed to help developers to perform data exporting processing tasks. With Spire.DataExport, the whole exporting process is quickly and it only needs two simple steps.
Please download Spire.DataExport for .NET and install it on your system, add Spire.DataExport.dll as reference in the downloaded Bin folder thought the below path: “…\Spire.DataExport\Bin\NET4.0\ Spire.DataExport.dll”.
Step 1: Load Data Information
In this step, Spire.DataExport helps us load data from database. Through DataGridVew, we can even preview and modify data.
private void Form1_Load(object sender, EventArgs e)
{
oleDbConnection1.ConnectionString = txtConnectString.Text;
oleDbCommand1.CommandText = txtCommandText.Text;
using (OleDbDataAdapter da = new OleDbDataAdapter())
{
da.SelectCommand = oleDbCommand1;
da.SelectCommand.Connection = oleDbConnection1;
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
}
}
Please check the screenshot:
Step 2: Set Export into MS Access
Here we need to set it as Access format. Spire.DataExport will create a new Access and through DataGridView export data into Access file. You can rename the file as you like.
private void btnExportToAccess_Click(object sender, EventArgs e)
{
Spire.DataExport.Access.AccessExport accessExport = new
Spire.DataExport.Access.AccessExport();
accessExport.DataSource = Spire.DataExport.Common.ExportSource.DataTable;
accessExport.DataTable = this.dataGridView1.DataSource as DataTable;
accessExport.DatabaseName = @"..\..\ToMdb.mdb";
accessExport.TableName = "ExportFromDatatable";
accessExport.SaveToFile();
}
Here comes to the results:
How to Export Data from Datatable to Word Document in C#?
2013-10-10 07:39:18 Written by AdministratorThere are some requirements to export datatable or dataset to word file on many occasions at work. The aim of this article is to help you complete this requirement. Spire.DataExport can help easily load data from the datatable and create a new Word file for storing the data. In addition to this, Spire.DataExport (or Spire.Office) can export data into MS Excel, HTML, XML, PDF, MS Access, DBF, SQL Script, SYLK, DIF, CSV and MS Clipboard format as well, which can be downloaded here. The following code is the example of showing how Spire.DataExport works.
Step 1: Function to fill data in datatable
In this step, Spire.DataExport will help load Data information from the datatable. After setting up the data source and SQL command, it allows you to preview and edit data in DataGridView component before exporting.
private void Form1_Load(object sender, EventArgs e)
{
oleDbConnection1.ConnectionString = txtConnectString.Text;
oleDbCommand1.CommandText = txtCommandText.Text;
using (OleDbDataAdapter da = new OleDbDataAdapter())
{
da.SelectCommand = oleDbCommand1;
da.SelectCommand.Connection = oleDbConnection1;
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
}
}
Effect Picture
Step 2: Export Data to word document
The code below shows how to export data from the datatable to Word file. Spire.DataExport will create a new MS Word for storing exported Data. It also allows you to rename the generated Word file in this step.
private void btnExportToWord_Click(object sender, EventArgs e)
{
Spire.DataExport.RTF.RTFExport rtfExport = new Spire.DataExport.RTF.RTFExport();
rtfExport.DataSource = Spire.DataExport.Common.ExportSource.DataTable;
rtfExport.DataTable = this.dataGridView1.DataSource as DataTable;
rtfExport.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
RTFStyle rtfStyle = new RTFStyle();
rtfStyle.FontColor = Color.Blue;
rtfStyle.BackgroundColor = Color.LightGreen;
rtfExport.RTFOptions.DataStyle = rtfStyle;
rtfExport.FileName=@"..\..\ToWord.doc";
rtfExport.SaveToFile();
}
Effect Picture
