Opening and Saving Text Files

You can load or save text files. You can specify the open or save flags as well as the column, row, and cell delimiters. You can also specify the encoding.

You can use the OpenTextFile method to load text files and the SaveTextFileRange method to save text files.

Using Code

The following example opens a text file.

CS	Copy Code
OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.Filter = "Text File (.txt)\|*.txt"; bool? useClick = openFileDialog.ShowDialog(); if (useClick == true) { var stream = openFileDialog.File.OpenRead(); stream.Seek(0, System.IO.SeekOrigin.Begin); gcSpreadSheet1.Sheets[0].OpenTextFile(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, "\r", ",", ""); stream.Dispose(); }

Copy Code

OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Text File (.txt)|*.txt";
bool? useClick = openFileDialog.ShowDialog();
if (useClick == true)
{
var stream = openFileDialog.File.OpenRead();
stream.Seek(0, System.IO.SeekOrigin.Begin);
gcSpreadSheet1.Sheets[0].OpenTextFile(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, "\r", ",", "");

stream.Dispose();
}

VB.NET	Copy Code
Dim openFileDialog = New OpenFileDialog() openFileDialog.Filter = "Text File(.txt)\|*.txt" Dim useClick As Boolean = openFileDialog.ShowDialog() If (useClick = True) Then Dim stream = openFileDialog.File.OpenRead() stream.Seek(0, IO.SeekOrigin.Begin)GcSpreadSheet1.Sheets(0).OpenTextFile(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, ChrW(13), ",", "") End If

VB.NET

Copy Code

Dim openFileDialog = New OpenFileDialog()
openFileDialog.Filter = "Text File(.txt)|*.txt"
Dim useClick As Boolean = openFileDialog.ShowDialog()
If (useClick = True) Then
Dim stream = openFileDialog.File.OpenRead()
stream.Seek(0, IO.SeekOrigin.Begin)GcSpreadSheet1.Sheets(0).OpenTextFile(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, ChrW(13), ",", "")

End If