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) | ![]() |
---|---|
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# | ![]() |
---|---|
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 | ![]() |
---|---|
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 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8