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 unformatted As Boolean, _ ByVal includeHeaders As IncludeHeaders, _ ByVal rowDelimiter As String, _ ByVal columnDelimiter As String, _ ByVal cellDelimiter As String, _ ByVal forceCellDelimiter As Boolean _ ) 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 unformatted As Boolean Dim includeHeaders As IncludeHeaders Dim rowDelimiter As String Dim columnDelimiter As String Dim cellDelimiter As String Dim forceCellDelimiter As Boolean Dim value As Boolean value = instance.SaveTextFileRange(row, column, rowCount, columnCount, fileName, unformatted, includeHeaders, rowDelimiter, columnDelimiter, cellDelimiter, forceCellDelimiter) |
C# | |
---|---|
public bool SaveTextFileRange( int row, int column, int rowCount, int columnCount, string fileName, bool unformatted, IncludeHeaders includeHeaders, string rowDelimiter, string columnDelimiter, string cellDelimiter, bool forceCellDelimiter ) |
Parameters
- row
- Starting row index
- column
- Starting column index
- rowCount
- Number of rows
- columnCount
- Number of columns
- fileName
- Path and name of the file to which to save the range of cells
- unformatted
- Whether to save the data unformatted
- includeHeaders
- Which header cells from which to save data
- rowDelimiter
- Row delimiter string
- columnDelimiter
- Column delimiter string
- cellDelimiter
- Cell delimiter string
- forceCellDelimiter
- True to force every cell value to use cell delimiter, false to use as needed
This example uses the SaveTextFileRange method.
C# | Copy Code |
---|---|
FpSpread1.Sheets[0].RowCount = 6; FpSpread1.Sheets[0].ColumnCount = 6; FpSpread1.Sheets[0].Cells[0, 0, 5, 5].Text = "test"; FpSpread1.Sheets[0].ColumnHeader.Cells[0, 0].Text = "Custom"; FpSpread1.Sheets[0].Cells[0, 0].BackColor = System.Drawing.Color.CadetBlue; protected void Button1_Click(object sender, EventArgs e) { //FpSpread1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, "c:\\controls\\textfile.txt", true, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "", "^"); //FpSpread1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, "c", "^"); //FpSpread1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, "c:\\controls\\textfile.txt", true, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "", "^", System.Text.Encoding.ASCII); //FpSpread1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, "c", "^", System.Text.Encoding.ASCII); //FpSpread1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, "c:\\controls\\textfile.txt", false, FarPoint.Web.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly, false, "#", "", "^", false); //FpSpread1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, "c", "^", false); //FpSpread1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, "c:\\controls\\textfile.txt", false, FarPoint.Web.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly, false, "#", "", "^", false, System.Text.Encoding.ASCII); //FpSpread1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, "c", "^", false, System.Text.Encoding.ASCII); //FpSpread1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, "c:\\controls\\textfile.txt", false, FarPoint.Web.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly, "#", "%", "^", false, System.Text.Encoding.ASCII, false); FpSpread1.Sheets[0].SaveTextFileRange(0, 0, 5, 5, "c:\\controls\\textfile.txt", false, FarPoint.Web.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly, false, "#", "%", "^", false, System.Text.Encoding.ASCII, false); } |
VB.NET | Copy Code |
---|---|
FpSpread1.Sheets(0).RowCount = 6 FpSpread1.Sheets(0).ColumnCount = 6 FpSpread1.Sheets(0).Cells(0, 0, 5, 5).Text = "test" FpSpread1.Sheets(0).ColumnHeader.Cells(0, 0).Text = "Custom" FpSpread1.Sheets(0).Cells(0, 0).BackColor = Drawing.Color.CadetBlue Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click 'FpSpread1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, "c:\controls\textfile.txt", True, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "", "^") 'FpSpread1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, "c", "^") 'FpSpread1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, "c:\controls\textfile.txt", True, FarPoint.Web.Spread.Model.IncludeHeaders.None, "#", "", "^", System.Text.Encoding.ASCII) 'FpSpread1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, "c", "^", System.Text.Encoding.ASCII) 'FpSpread1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, "c:\controls\textfile.txt", False, FarPoint.Web.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly, False, "#", "", "^", False) 'FpSpread1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, "c", "^", False) 'FpSpread1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, "c:\controls\textfile.txt", False, FarPoint.Web.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly, False, "#", "", "^", False, System.Text.Encoding.ASCII) 'FpSpread1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, "c", "^", False, System.Text.Encoding.ASCII) 'FpSpread1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, "c:\controls\textfile.txt", False, FarPoint.Web.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly, "#", "%", "^", False, System.Text.Encoding.ASCII, False) FpSpread1.Sheets(0).SaveTextFileRange(0, 0, 5, 5, "c:\controls\textfile.txt", False, FarPoint.Web.Spread.Model.IncludeHeaders.ColumnHeadersCustomOnly, False, "#", "%", "^", False, System.Text.Encoding.ASCII, False) End Sub |
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6