SaveTextFileRange(Int32,Int32,Int32,Int32,String,TextFileFlags,IncludeHeaders,String,String,String) Method
In This Topic
Saves the range of cells in a sheet to a text file with the specified name, formatting settings, and delimiters.
Syntax
'Declaration
Public Overloads Function SaveTextFileRange( _
ByVal As Integer, _
ByVal column As Integer, _
ByVal As Integer, _
ByVal columnCount As Integer, _
ByVal As String, _
ByVal As TextFileFlags, _
ByVal As IncludeHeaders, _
ByVal As String, _
ByVal columnDelimiter As String, _
ByVal As String _
) As Boolean
'Usage
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)
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
See Also