Knowledgebase (2597)
Children categories
Why Export Listview to RTF?
RTF (Rich Text Format) is one of three core file formats which Microsoft supports natively along with DOC and DOCX. It's a cross-platform file extension supported by almost all word processors regardless of operating system. RTF word processing files are typically smaller, safer and can be used across a variety of operating systems. Main advantages of RTF:
- File Transparency
- No Risk of Viruses
- Smaller File Size for Text Documents
The ability mentioned above of RTF files to be read by the receiver regardless of the type of word processor or its version or the operating system being used. While in some cases this may be the most essential requirement.
Unlike Word .doc files, RTF files cannot contain the numerous "macro" and other viruses that plague Microsoft Word documents. Many business and other e-mail servers refuse to accept e-mailed "attachments" which are in .doc format because of all the viruses that may be carried by Word .doc files. However, they will accept the same document in RTF, since the RTF file cannot transmit viruses. This security against the risk of virus infection applies regardless of whether your document would be conveyed via diskette, e-mail attachment, or as an archived web file.
For having greater disk storage capacity, this may sometimes be an advantage.
How to Export Listview to RTF?
Spire.DataExport for .NET as a professional .NET component suit for data exporting can easily help to export Listview to RTF. Download Spire.DataExport (or Spire.Office) with .NET framework 2.0 (or above) together and use the code below to Export Listview to RTF:
[C#]
this.rtfExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
this.rtfExport1.DataFormats.CultureName = "en-us";
this.rtfExport1.DataFormats.Currency = "c";
this.rtfExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
this.rtfExport1.DataFormats.Float = "g";
this.rtfExport1.DataFormats.Integer = "g";
this.rtfExport1.DataFormats.Time = "H:mm";
this.rtfExport1.FileName = "sample.doc";
this.rtfExport1.RTFOptions.DataStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
this.rtfExport1.RTFOptions.FooterStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
this.rtfExport1.RTFOptions.HeaderStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World);
this.rtfExport1.RTFOptions.TitleStyle.Alignment = Spire.DataExport.RTF.RtfTextAlignment.Center;
this.rtfExport1.RTFOptions.TitleStyle.Font = new System.Drawing.Font("Arial", 10F, System.Drawing.FontStyle.Bold);
this.rtfExport1.DataSource = ExportSource.ListView;
this.rtfExport1.ListView = this.ListView1
rtfExport1.SaveToFile();
[VB.NET]
Me.rtfExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView
Me.rtfExport1.DataFormats.CultureName = "en-us"
Me.rtfExport1.DataFormats.Currency = "c"
Me.rtfExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
Me.rtfExport1.DataFormats.Float = "g"
Me.rtfExport1.DataFormats.Integer = "g"
Me.rtfExport1.DataFormats.Time = "H:mm"
Me.rtfExport1.FileName = "sample.doc"
Me.rtfExport1.RTFOptions.DataStyle.Font = New System.Drawing.Font("Arial", 10.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World)
Me.rtfExport1.RTFOptions.FooterStyle.Font = New System.Drawing.Font("Arial", 10.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World)
Me.rtfExport1.RTFOptions.HeaderStyle.Font = New System.Drawing.Font("Arial", 10.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.World)
Me.rtfExport1.RTFOptions.TitleStyle.Alignment = Spire.DataExport.RTF.RtfTextAlignment.Center
Me.rtfExport1.RTFOptions.TitleStyle.Font = New System.Drawing.Font("Arial", 10.0!, System.Drawing.FontStyle.Bold)
Me.rtfExport1.DataSource = Common.ExportSource.ListView
Me.cellExport1.ListView = Me.ListView1
Me.cellExport1.SaveToFile()
Published in
ListView Export
Tagged under
Spire.DataExport for .NET, is a professional .NET component suit for data exporting. It allows programmers export data from database to MS Excel, MS Word, HTML, XML, PDF, MS Access, DBF, SQL Script, SYLK, DIF, CSV ,MS Clipboard format. Here we will introduce how to export data from listview to HTML.
As the predominant markup language for web pages, HTMLwhich stands for HyperText Markup Language is written in the form of HTML elements consisting of tags, enclosed in angle brackets (like ), within the web page content. It's the basic building-blocks of webpages. HTML has many advantages such as:
- Easy to use
- Loose syntax (although, being too flexible will not comply with standards)
- Supported on almost every browser, if not all browsers
- Free - You need not buy any software
- Easy to learn & code even for novice programmers
- Very similar to XML syntax, which is increasingly used for data storage
- Widely used; established on almost every website, if not all websites
Spire.DataExport presents an easy way to export data from Listview to HTML. Download Spire.DataExport (or Spire.Office) with .NET framework 2.0 (or above) together and use the code below to export data from Listview to HTML with C#/VB.NET.
[C#]
Spire.DataExport.HTML.HTMLExport htmlExport1;
this.htmlExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView;
this.htmlExport1.DataFormats.CultureName = "zh-CN";
this.htmlExport1.DataFormats.Currency = "c";
this.htmlExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
this.htmlExport1.DataFormats.Float = "g";
this.htmlExport1.DataFormats.Integer = "g";
this.htmlExport1.DataFormats.Time = "H:mm";
this.htmlExport1.FileName = "sample.html";
this.htmlExport1.HtmlStyle = Spire.DataExport.HTML.HtmlStyle.MSMoney;
this.htmlExport1.HtmlTableOptions.BackColor = System.Drawing.Color.FromArgb(((System.Byte)(222)), ((System.Byte)(231)), ((System.Byte)(222)));
this.htmlExport1.HtmlTableOptions.FontColor = System.Drawing.Color.Black;
this.htmlExport1.HtmlTableOptions.HeadersBackColor = System.Drawing.Color.FromArgb(((System.Byte)(206)), ((System.Byte)(198)), ((System.Byte)(181)));
this.htmlExport1.HtmlTableOptions.HeadersFontColor = System.Drawing.Color.Black;
this.htmlExport1.HtmlTableOptions.OddBackColor = System.Drawing.Color.FromArgb(((System.Byte)(255)), ((System.Byte)(251)), ((System.Byte)(240)));
this.htmlExport1.HtmlTextOptions.BackgroundColor = System.Drawing.Color.White;
this.htmlExport1.HtmlTextOptions.Font = new System.Drawing.Font("Arial", 8F);
this.htmlExport1.HtmlTextOptions.LinkActiveColor = System.Drawing.Color.Blue;
this.htmlExport1.HtmlTextOptions.LinkColor = System.Drawing.Color.Red;
this.htmlExport1.HtmlTextOptions.LinkVisitedColor = System.Drawing.Color.Purple;
this.htmlExport1.DataSource = Common.ExportSource.ListView;
this.htmlExport1.ListView = this.listView1;
htmlExport1.SaveToFile();
[VB.NET]
htmlExport1 As Spire.DataExport.HTML.HTMLExport
Me.htmlExport1.ActionAfterExport = Spire.DataExport.Common.ActionType.OpenView
Me.htmlExport1.DataFormats.CultureName = "zh-CN"
Me.htmlExport1.DataFormats.Currency = "c"
Me.htmlExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
Me.htmlExport1.DataFormats.Float = "g"
Me.htmlExport1.DataFormats.Integer = "g"
Me.htmlExport1.DataFormats.Time = "H:mm"
Me.htmlExport1.FileName = "sample.html"
Me.htmlExport1.HtmlStyle = Spire.DataExport.HTML.HtmlStyle.MSMoney
Me.htmlExport1.HtmlTableOptions.BackColor = System.Drawing.Color.FromArgb(CType(222, Byte), CType(231, Byte), CType(222, Byte))
Me.htmlExport1.HtmlTableOptions.FontColor = System.Drawing.Color.Black
Me.htmlExport1.HtmlTableOptions.HeadersBackColor = System.Drawing.Color.FromArgb(CType(206, Byte), CType(198, Byte), CType(181, Byte))
Me.htmlExport1.HtmlTableOptions.HeadersFontColor = System.Drawing.Color.Black
Me.htmlExport1.HtmlTableOptions.OddBackColor = System.Drawing.Color.FromArgb(CType(255, Byte), CType(251, Byte), CType(240, Byte))
Me.htmlExport1.HtmlTextOptions.BackgroundColor = System.Drawing.Color.White
Me.htmlExport1.HtmlTextOptions.Font = New System.Drawing.Font("Arial", 8.0!)
Me.htmlExport1.HtmlTextOptions.LinkActiveColor = System.Drawing.Color.Blue
Me.htmlExport1.HtmlTextOptions.LinkColor = System.Drawing.Color.Red
Me.htmlExport1.HtmlTextOptions.LinkVisitedColor = System.Drawing.Color.Purple
Me.htmlExport1.DataSource = Common.ExportSource.ListView
Me.htmlExport1.ListView = Me.listView1
htmlExport1.SaveToFile()
Published in
ListView Export
Tagged under
Because of safety, easy to transfer from one to another and also easy to use, PDf is now becoming No. 1 file format all over the world. Usually customers will need export data from database to PDF file format. Spire.DataExport for .NET is a .NET component suit, 100% pure managed by C# for data exporting from database such as ListView, datatable and SQL command into MS Excel,MS Word, HTML, XML, PDF, MS Access, DBF, SQL Script, SYLK, DIF, CSV ,MS Clipboard format.
Spire.DataExport for .Net provides a quick and easy solution to export data from Listview to PDF. With Spire.DataExport for .Net, users also have other rich options when export data from database.
Now Download Spire.DataExport (or Spire.Office) with .NET framework together and use the code below to export data from Listview to PDF with C#/VB.NET.
[C#]
protected void Button1_Click(object sender, System.EventArgs e)
{
oleDbConnection1.Open();
this.cellExport1.ActionAfterExport = DataExport.Common.ActionType.None;
this.cellExport1.DataFormats.CultureName = "zh-CN";
this.cellExport1.DataFormats.Currency = "?#,###,##0.00";
this.cellExport1.DataFormats.DateTime = "yyyy-M-d H:mm";
this.cellExport1.DataFormats.Float = "#,###,##0.00";
this.cellExport1.DataFormats.Integer = "#,###,##0";
this.cellExport1.DataFormats.Time = "H:mm";
this.cellExport1.SheetOptions.AggregateFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.CustomDataFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.DefaultFont.Name = "Arial";
this.cellExport1.SheetOptions.FooterFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.HeaderFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue;
this.cellExport1.SheetOptions.HyperlinkFormat.Font.Name = "Arial";
this.cellExport1.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single;
this.cellExport1.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left;
this.cellExport1.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top;
this.cellExport1.SheetOptions.NoteFormat.Font.Bold = true;
this.cellExport1.SheetOptions.NoteFormat.Font.Name = "Tahoma";
this.cellExport1.SheetOptions.NoteFormat.Font.Size = 8F;
this.cellExport1.SheetOptions.TitlesFormat.Font.Bold = true;
this.cellExport1.SheetOptions.TitlesFormat.Font.Name = "Arial";
this.cellExport1.DataSource = DataExport.Common.ExportSource.ListView;
this.cellExport1.ListView = this.listView1;
Using(MemoryStream stream = new MemoryStream())
{
cellExport1.SaveToFile(stream);
this.oleDbConnection1.Close();
Workbook workbook = new Workbook(stream);
PdfConverter pdfConverter = new PdfConverter(workbook);
PdfDocument pdfDocument = new PdfDocument();
pdfDocument.PageSettings.Orientation = pdf.PdfPageOrientation.Landscape;
pdfDocument.PageSettings.Width = 970;
pdfDocument.PageSettings.Height = 850;
PdfConverterSettings settings = new PdfConverterSettings();
settings.TemplateDocument = pdfDocument;
pdfDocument = pdfConverter.Convert(settings);
pdfDocument.SaveToFile("test.pdf");
}
}
[VB.NET]
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
oleDbConnection1.Open()
Me.cellExport1.ActionAfterExport = DataExport.Common.ActionType.None
Me.cellExport1.DataFormats.CultureName = "zh-CN"
Me.cellExport1.DataFormats.Currency = "?#,###,##0.00"
Me.cellExport1.DataFormats.DateTime = "yyyy-M-d H:mm"
Me.cellExport1.DataFormats.Float = "#,###,##0.00"
Me.cellExport1.DataFormats.Integer = "#,###,##0"
Me.cellExport1.DataFormats.Time = "H:mm"
Me.cellExport1.SheetOptions.AggregateFormat.Font.Name = "Arial"
Me.cellExport1.SheetOptions.CustomDataFormat.Font.Name = "Arial"
Me.cellExport1.SheetOptions.DefaultFont.Name = "Arial"
Me.cellExport1.SheetOptions.FooterFormat.Font.Name = "Arial"
Me.cellExport1.SheetOptions.HeaderFormat.Font.Name = "Arial"
Me.cellExport1.SheetOptions.HyperlinkFormat.Font.Color = Spire.DataExport.XLS.CellColor.Blue
Me.cellExport1.SheetOptions.HyperlinkFormat.Font.Name = "Arial"
Me.cellExport1.SheetOptions.HyperlinkFormat.Font.Underline = Spire.DataExport.XLS.XlsFontUnderline.Single
Me.cellExport1.SheetOptions.NoteFormat.Alignment.Horizontal = Spire.DataExport.XLS.HorizontalAlignment.Left
Me.cellExport1.SheetOptions.NoteFormat.Alignment.Vertical = Spire.DataExport.XLS.VerticalAlignment.Top
Me.cellExport1.SheetOptions.NoteFormat.Font.Bold = True
Me.cellExport1.SheetOptions.NoteFormat.Font.Name = "Tahoma"
Me.cellExport1.SheetOptions.NoteFormat.Font.Size = 8F
Me.cellExport1.SheetOptions.TitlesFormat.Font.Bold = True
Me.cellExport1.SheetOptions.TitlesFormat.Font.Name = "Arial"
Me.cellExport1.DataSource = DataExport.Common.ExportSource.ListView
Me.cellExport1.ListView = Me.listView1
Dim stream As New MemoryStream()
cellExport1.SaveToFile(stream)
stream.Close()
Me.oleDbConnection1.Close()
Dim workbook As New Workbook(stream)
Dim pdfConverter As New PdfConverter(workbook)
Dim pdfDocument As New PdfDocument()
pdfDocument.PageSettings.Orientation = pdf.PdfPageOrientation.Landscape
pdfDocument.PageSettings.Width = 970
pdfDocument.PageSettings.Height = 850
Dim settings As New PdfConverterSettings()
settings.TemplateDocument = pdfDocument
pdfDocument = pdfConverter.Convert(settings)
pdfDocument.SaveToFile("test.pdf")
End Sub
Published in
ListView Export
Tagged under
