Spread Windows Forms 6.0 Product Documentation
SaveTextFileRange(Int32,Int32,Int32,Int32,String,TextFileFlags,IncludeHeaders,String,String,String) Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class > SaveTextFileRange Method : SaveTextFileRange(Int32,Int32,Int32,Int32,String,TextFileFlags,IncludeHeaders,String,String,String) Method


row
Starting row index
column
Starting column index
rowCount
Number of rows
columnCount
Number of columns
fileName
Path and name of file to which to save the text of the range
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

Glossary Item Box

Saves the range of cells in a sheet to a text file with the specified name, formatting settings, and delimiters.

Syntax

Visual Basic (Declaration) 
Public Overloads Function SaveTextFileRange( _
   ByVal row As Integer, _
   ByVal column As Integer, _
   ByVal rowCount As Integer, _
   ByVal columnCount As Integer, _
   ByVal fileName As String, _
   ByVal textFileFlags As TextFileFlags, _
   ByVal includeHeaders As IncludeHeaders, _
   ByVal rowDelimiter As String, _
   ByVal columnDelimiter As String, _
   ByVal cellDelimiter As String _
) 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 fileName As String
Dim textFileFlags As TextFileFlags
Dim includeHeaders As IncludeHeaders
Dim rowDelimiter As String
Dim columnDelimiter As String
Dim cellDelimiter As String
Dim value As Boolean
 
value = instance.SaveTextFileRange(row, column, rowCount, columnCount, fileName, textFileFlags, includeHeaders, rowDelimiter, columnDelimiter, cellDelimiter)
C# 
public bool SaveTextFileRange( 
   int row,
   int column,
   int rowCount,
   int columnCount,
   string fileName,
   TextFileFlags textFileFlags,
   IncludeHeaders includeHeaders,
   string rowDelimiter,
   string columnDelimiter,
   string cellDelimiter
)

Parameters

row
Starting row index
column
Starting column index
rowCount
Number of rows
columnCount
Number of columns
fileName
Path and name of file to which to save the text of the range
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

Example

This example saves to a text file.
C#Copy Code
FpSpread1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, "c:\\test.txt", FarPoint.Win.Spread.TextFileFlags.IncludeFooter, FarPoint.Win.Spread.Model.IncludeHeaders.None, "\r", ",", ""); 
Visual BasicCopy Code
FpSpread1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, "c:\test.txt", FarPoint.Win.Spread.TextFileFlags.IncludeFooter, FarPoint.Win.Spread.Model.IncludeHeaders.None, Chr(13), ",", "")

Requirements

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

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.