Sep

Exporting data to CSV file function is enhanced in Spire.DataExport 3.4

Today we are glad to announce a new release version of Spire.DataExport v3.4 for function enhancement. In this new version, we add a new feature (new property CSVOption.KeepingLineBreak) to support keeping/removing the line-breaks during exporting data to CSV file. More details are as followed:

Code Snippet:

string sqlConn=@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\datasource.mdb";
string sql = "select * from test";

using (OleDbConnection conn = new OleDbConnection(sqlConn))
{
	using (OleDbDataAdapter oda = new OleDbDataAdapter(sql, conn))
	{
		DataTable dataTable = new DataTable();
		oda.Fill(dataTable);

		TXTExport txtExport = new TXTExport();
		txtExport.ExportType = TextExportType.CSV;
		txtExport.CSVOption.AllowQuote = true;
		txtExport.AutoFitColWidth = true;
		txtExport.DataSource = ExportSource.DataTable;
		txtExport.DataTable = dataTable;
		txtExport.CSVOption.Separator = ",";
		
		//keeping the line-break
		txtExport.CSVOption.KeepingLineBreak = true;
		
		txtExport.DataEncoding = Spire.DataExport.Common.EncodingType.UTF8;
		txtExport.ExportLongColumn = true;
		txtExport.SaveToFile("exporttest1.csv");
	}
}

Welcome to experience Spire.DataExport for .NET with downloading here:

http://www.e-iceblue.com/Download/download-dataexport-for-net-now.html

Written by daisy zhang.