Spread Windows Forms 9.0 Product Documentation
LoadTextFile(SheetView,String,IncludeHeaders,String,String,String,TextFileFlags) Method
Example 


Sheet into which to load the text data
Path and name of file from which to load text
Whether headers are handled as data
Row delimiter string
Column delimiter string
Cell delimiter string
Specifies how to process the data when loading from a text file
Loads the text file with the specified formatting.
Syntax
'Declaration
 
Public Overloads Shared Sub LoadTextFile( _
   ByVal sheetView As SheetView, _
   ByVal fileName As String, _
   ByVal includeHeaders As IncludeHeaders, _
   ByVal rowDelimiter As String, _
   ByVal columnDelimiter As String, _
   ByVal cellDelimiter As String, _
   ByVal flags As TextFileFlags _
) 
'Usage
 
Dim sheetView As SheetView
Dim fileName As String
Dim includeHeaders As IncludeHeaders
Dim rowDelimiter As String
Dim columnDelimiter As String
Dim cellDelimiter As String
Dim flags As TextFileFlags
 
SpreadSerializer.LoadTextFile(sheetView, fileName, includeHeaders, rowDelimiter, columnDelimiter, cellDelimiter, flags)
public static void LoadTextFile( 
   SheetView sheetView,
   string fileName,
   IncludeHeaders includeHeaders,
   string rowDelimiter,
   string columnDelimiter,
   string cellDelimiter,
   TextFileFlags flags
)

Parameters

sheetView
Sheet into which to load the text data
fileName
Path and name of file from which to load text
includeHeaders
Whether headers are handled as data
rowDelimiter
Row delimiter string
columnDelimiter
Column delimiter string
cellDelimiter
Cell delimiter string
flags
Specifies how to process the data when loading from a text file
Example
This example uses the LoadTextFile method.
FarPoint.Win.Spread.Model.SpreadSerializer.LoadTextFile(fpSpread1.ActiveSheet, "D:\\SpreadFiles\\tabbed.txt", FarPoint.Win.Spread.Model.IncludeHeaders.None, "\t", ",", "", FarPoint.Win.Spread.TextFileFlags.None);
Dim s As New FarPoint.Win.Spread.Model.SpreadSerializer
s.LoadTextFile(FpSpread1.ActiveSheet, "D:\SpreadFiles\tabbed.txt", FarPoint.Win.Spread.Model.IncludeHeaders.None, Chr(13), ",", "", FarPoint.Win.Spread.TextFileFlags.None)
Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

SpreadSerializer Class
SpreadSerializer Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.