示例#1
0
    public void RowSerializer_Exports_Into_Csv()
    {
        var config = new ExampleClassMap();
        var data   = TestData.GenerateExampleClasses();

        using var stream = new MemoryStream();
        using var writer = new StreamWriter(stream);
        using var csv    = new CsvWriter(writer, new CsvConfiguration(CultureInfo.InvariantCulture)
        {
            HasHeaderRecord = false
        });

        foreach (var header in config.GetHeader())
        {
            csv.WriteField(header);
        }
        csv.NextRecord();

        foreach (var item in ExportSerializer.RowSerializer(data, config))
        {
            foreach (var field in item.Data)
            {
                csv.WriteField(field);
            }
            csv.NextRecord();
        }
        csv.Flush();
        var result = writer.Encoding.GetString(stream.ToArray());

        result.Should().MatchSnapshot();
    }
示例#2
0
    public void DataReaderSerializer_Exports_Into_MiniExcel()
    {
        var config = new ExampleClassMap();
        var data   = TestData.GenerateExampleClasses();

        using var stream = new MemoryStream();


        MiniExcelLibs.MiniExcel.SaveAs(stream, ExportSerializer.DataReaderSerializer(data, config));

        ResultData.VerifyExcel(stream);
    }
示例#3
0
    public void RowSerializer_Exports_Into_ClosedXml()
    {
        var config = new ExampleClassMap();
        var data   = TestData.GenerateExampleClasses();

        using var stream = new MemoryStream();
        var workbook  = new ClosedXML.Excel.XLWorkbook();
        var worksheet = workbook.AddWorksheet("Sheet1");

        worksheet.Cell(1, 1).InsertData(new[] { config.GetHeader() });
        worksheet.Cell(2, 1).InsertData(ExportSerializer.RowSerializer(data, config).Select(e => e.Data));

        ResultData.VerifyExcel(worksheet);
    }
    public void FieldSerializer_Exports_Into_ClosedXml()
    {
        var config    = new ExampleClassMap();
        var data      = TestData.GenerateExampleClasses();
        var workbook  = new XLWorkbook();
        var worksheet = workbook.AddWorksheet("Sheet1");

        foreach (var item in config.HeaderSerializer())
        {
            worksheet.Cell(1, 1 + item.FieldIndex).SetValue(item.Value);
        }

        foreach (var item in ExportSerializer.FieldSerializer(data, config))
        {
            worksheet.Cell(2 + item.RowIndex, 1 + item.FieldIndex).SetValue(item.Value);
        }

        ResultData.VerifyExcel(worksheet);
    }