How to create excel file?

[ssccinng]

How to create excel file?

[paillave]

I will come back to you asap. Can you give me an example of your code?

[ssccinng]

I will come back to you asap. Can you give me an example of your code?

I know how to use it. Can I add some test cases to this project?

It took me some time to find out how to use them

using System;
using System.Threading.Tasks;
using Paillave.Etl.Core;

namespace SimpleTutorial
{
    class Program
    {
        static async Task Main(string[] args)
        {
            var processRunner = StreamProcessRunner.Create<string>(DefineProcess);
            var res = await processRunner.ExecuteAsync("InputFiles");
            Console.Write(res.Failed ? "Failed" : "Succeeded");
        }
        private static void DefineProcess(ISingleStream<string> contextStream)
        {

            contextStream.CrossApplyFolderFiles("get data", "*.csv")
                .CrossApplyTextFile("Parse data", FlatFileDefinition.Create(i => new
                {
                    a = i.ToColumn("a")
                }).IsColumnSeparated(','))
                ////.CrossApplyExcelSheets("dani")
                //.CrossApplyExcelRows("get rows", o => new  { a = "!"})
                .ToExcelFile("to excel", "ex.xlsx", ExcelFileDefinition.Create(i => new
                {
                    a = i.ToColumn("b")
                }).HasColumnHeader("A1:C1")
                .WithDataset("A2:C2"))
                .WriteToFile("write", i => i.Name);
            // TODO: Define the ETL process here
        }
    }
}

[paillave]

Sorry for this, I tried to find some time yesterday to provide an example. As I mentioned on the cast, documentation is an ongoing project and I'm glad questions are posted here to mitigate this (temporary) lack.
Bty, I will make some changes to provide a more straightforward way to read/write excels (with HasColumnHeader and WithDataset being optional)

[paillave]

Can I add some test cases to this project?

Every pull request is more than welcome!
There was a time when I had bunch of them, but I put them apart since the new version. This is also a work to be done.