Visual Basic (Declaration) | |
---|---|
Public Overloads Function SaveTextFileRange( _ ByVal row As Integer, _ ByVal column As Integer, _ ByVal rowCount As Integer, _ ByVal columnCount As Integer, _ ByVal stream As Stream, _ ByVal textFileFlags As TextFileFlags, _ ByVal includeHeaders As IncludeHeaders, _ ByVal rowDelimiter As String, _ ByVal columnDelimiter As String, _ ByVal cellDelimiter As String, _ ByVal encoding As Encoding _ ) As Boolean |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As SheetView Dim row As Integer Dim column As Integer Dim rowCount As Integer Dim columnCount As Integer Dim stream As Stream Dim textFileFlags As TextFileFlags Dim includeHeaders As IncludeHeaders Dim rowDelimiter As String Dim columnDelimiter As String Dim cellDelimiter As String Dim encoding As Encoding Dim value As Boolean value = instance.SaveTextFileRange(row, column, rowCount, columnCount, stream, textFileFlags, includeHeaders, rowDelimiter, columnDelimiter, cellDelimiter, encoding) |
C# | |
---|---|
public bool SaveTextFileRange( int row, int column, int rowCount, int columnCount, Stream stream, TextFileFlags textFileFlags, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter, Encoding encoding ) |
Parameters
- row
- Starting row index
- column
- Starting column index
- rowCount
- Number of rows
- columnCount
- Number of columns
- stream
- Stream to which to save the text of the sheet
- textFileFlags
- Specifies how to process the data when saving to a text file
- includeHeaders
- Whether to export headers as data
- rowDelimiter
- Row delimiter string
- columnDelimiter
- Column delimiter string
- cellDelimiter
- Cell delimiter string
- encoding
- Encoding
This example saves to a text file.
C# | Copy Code |
---|---|
SaveFileDialog sfd = new SaveFileDialog(); System.IO.Stream s; sfd.Filter = "text files (*.txt)|*.txt"; sfd.FilterIndex = 2; sfd.RestoreDirectory = true; if (sfd.ShowDialog() == DialogResult.OK) { s = sfd.OpenFile(); fpSpread1.ActiveSheet.SaveTextFileRange(0,0, 5, 5, s, FarPoint.Win.Spread.TextFileFlags.Unformatted, FarPoint.Win.Spread.Model.IncludeHeaders.BothCustomOnly, "\r",",", "", System.Text.Encoding.ASCII); s.Close(); } |
Visual Basic | Copy Code |
---|---|
Dim sd As New SaveFileDialog() Dim s As System.IO.Stream sd.Filter = "text files (*.txt)|*.txt" sd.FilterIndex = 2 sd.RestoreDirectory = True If sd.ShowDialog() = DialogResult.OK Then s = sd.OpenFile FpSpread1.ActiveSheet.SaveTextFileRange(0, 0, 5, 5, s, FarPoint.Win.Spread.TextFileFlags.Unformatted, FarPoint.Win.Spread.Model.IncludeHeaders.BothCustomOnly, Chr(13), ",", "", System.Text.Encoding.ASCII) s.Close() End If |
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2