OpenSpreadsheet icon indicating copy to clipboard operation
OpenSpreadsheet copied to clipboard

Document how to do single iteration of IEnumerable

Open jzabroski opened this issue 6 years ago • 0 comments

From reddit:

using (var spreadsheet = new Spreadsheet(filepath))
{
    var records = spreadsheet.ReadWorksheet<TestClass, TestClassMap>("Sheet1");

    using (var writerNegative = spreadsheet.CreateWorksheetWriter<TestClass, TestClassMap>("Negative"))
    using (var writerPositive = spreadsheet.CreateWorksheetWriter<TestClass, TestClassMap>("Positive"))
    {
        foreach (var record in records)
        {
            if (record.Amount < 0)
            {
                writerNegative.WriteRecord(record);
            }
            else
            {
                writerPositive.WriteRecord(record);
            }
        }
    }
}

jzabroski avatar Feb 15 '19 16:02 jzabroski