渲染为CSV

渲染为CSV
逗号分隔值（CSV）是纯文本形式的结构化数据形式。 CSV文件中的文本另存为一系列值，并用逗号分隔。 您可以使用CsvRenderingExtension以这种格式呈现报告。

以下步骤提供了以Csv格式呈现报告的示例。

1、创建一个新的Visual Studio项目。

2、在出现的“新建项目”对话框中，选择“ ActiveReports 14页面报表应用程序”，然后在“名称”字段中指定项目的名称。

3、单击“确定”创建一个新的ActiveReports 14页面报表应用程序。 默认情况下，页面报告将添加到项目中。

4、在项目中添加对GrapeCity.ActiveReports.Export.Xml包的引用。

5、在打开的Form.cs或Form.vb上，双击标题栏以创建Form_Load事件。

6、在Form_Load事件中添加以下代码。

Visual Basic.NET代码。 粘贴到Form Load事件中。

' Provide the page report you want to render.
Dim report As New GrapeCity.ActiveReports.PageReport()
Dim reportDocument As New GrapeCity.ActiveReports.Document.PageDocument(report)

' Create an output directory.
Dim outputDirectory As New System.IO.DirectoryInfo("C:\MyCSV")
outputDirectory.Create()

' Provide settings for your rendering output.
Dim csvSettings As New GrapeCity.ActiveReports.Export.Text.Page.CsvRenderingExtension.Settings()
csvSettings.ColumnsDelimiter = ","
csvSettings.Encoding = System.Text.Encoding.UTF8
csvSettings.NoHeader = "True"
csvSettings.QuotationSymbol = """"c
csvSettings.RowsDelimiter = vbCr & vbLf

' Set the rendering extension and render the report.
Dim csvRenderingExtension As New GrapeCity.ActiveReports.Export.Text.Page.CsvRenderingExtension()
Dim outputProvider As New GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider(outputDirectory, System.IO.Path.GetFileNameWithoutExtension(outputDirectory.Name))

' Overwrite output file if it already exists.
outputProvider.OverwriteOutputFile = True

reportDocument.Render(csvRenderingExtension, outputProvider, csvSettings)

C＃代码。 粘贴到Form Load事件中。

// Provide the page report you want to render.
GrapeCity.ActiveReports.PageReport report = new GrapeCity.ActiveReports.PageReport();
GrapeCity.ActiveReports.Document.PageDocument reportDocument = new GrapeCity.ActiveReports.Document.PageDocument(report);

// Create an output directory.
System.IO.DirectoryInfo outputDirectory = new System.IO.DirectoryInfo(@"C:\MyCSV");
outputDirectory.Create();

// Provide settings for your rendering output.
GrapeCity.ActiveReports.Export.Text.Page.CsvRenderingExtension.Settings csvSettings = new GrapeCity.ActiveReports.Export.Text.Page.CsvRenderingExtension.Settings();
csvSettings.ColumnsDelimiter = ",";
csvSettings.Encoding = Encoding.UTF8;
csvSettings.NoHeader = "True";
csvSettings.QuotationSymbol = '"';
csvSettings.RowsDelimiter = "\r\n";

// Set the rendering extension and render the report.
GrapeCity.ActiveReports.Export.Text.Page.CsvRenderingExtension csvRenderingExtension = new GrapeCity.ActiveReports.Export.Text.Page.CsvRenderingExtension();
GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider outputProvider = new GrapeCity.ActiveReports.Rendering.IO.FileStreamProvider(outputDirectory, System.IO.Path.GetFileNameWithoutExtension(outputDirectory.Name));

// Overwrite output file if it already exists.
outputProvider.OverwriteOutputFile = true;

reportDocument.Render(csvRenderingExtension, outputProvider, csvSettings);

相关资源：