ToText

This method exports a range in a worksheet to a string. You can configure the format of this content by using the ExcelOutputTextFormat class as input parameter. This method generates the same output as the SaveToText method, which sends the output to a file instead of a string.

Basic usage

Lets create a worksheet and add some values to the cells:

using(var package = new ExcelPackage())
{
    var sheet = package.Workbook.Worksheets.Add("test");
    sheet.Cells["A1"].Value = 1;
    sheet.Cells["B1"].Value = 2;
    sheet.Cells["A2"].Value = 3;
    sheet.Cells["B2"].Value = 4;
}

...and then call the ToText method:

var content = sheet.Cells["A1:B2"].ToText();

The value of the string content will be "1,2\r\n3,4";

ExcelOutputTextFormat

An instance of this class can be sent in as a parameter to the ToText method.

var format = new ExcelOutputTextFormat{
    TextQualifier = '\''
};
var content = sheet.Cells["A1:B2"].ToText(format);

The ExcelOutputTextFormat has the following properties:

• Header - A text written at the start of the content
• Footer - A text written at the end of the content
• FirstRowIsHeader (bool) - First row of the range contains the headers. All header cells will be treated as strings.