ExcelToCsv 0.0.2

ExcelToCsv

Lightweight library allowing to convert tabular Excel worksheets to csv files.

Complete auto-generated documentation can be found here: sandcastle-documentation.

Example

Below example illustrates the basic usage of the library.

string? targetDirectory = "some-target-directory";
string path = @"ExampleFiles\ExampleExcelFile.xlsx";

ExcelFile.New(path)
    .Do(excel =>
    {
        Console.WriteLine($"Found {excel.Tables.Count()} worksheets:");
        foreach (var table in excel.Tables)
            Console.WriteLine(table);
    })
    .FlatMap(excel =>
    {
        Console.WriteLine("\n\nSaving tables in worksheets as csv.");
        var saveResults = excel.Tables.Select(table =>
        {
            // explicitly:
            var result = excel.SaveAsCsv
            (
                tableIndex: table.Index,
                targetPath: $"{table.Name}.csv",
                delimiter: ","                  // default is comma
            );

            // or in short:
            result = excel.SaveAsCsv(table.Index, $"{table.Name}.csv");

            return result;
        });
        
        Console.WriteLine("\n\nSaving a table with known worksheet name, by cautiously checking its existence.");
        Res resultSingleTable = excel
            .GetTable("Table1")                                                     // Opt<TableInfo>
            .IntoRes("worksheet Table1")                                            // Res<TableInfo>
            .FlatMap(table => excel.SaveAsCsv(table.Index, $"{table.Name}.csv"));   // Res
        
        Console.WriteLine("\n\nSaving a table directly by worksheet name, without checking its existence (errors still handled).");
        Res resultSingleTableDirect = excel.SaveAsCsv("Table1", "Table1-directly.csv");

        Res mergedResult = ReduceResults(saveResults.Reduce(stopAtFirstError: true), resultSingleTable, resultSingleTableDirect);
        return mergedResult;
    })
    .MatchDo
    (
        whenOk: () => Console.WriteLine($"\n\nAll tables successfully saved as csv files in:\n{targetDirectory}"),
        whenErr: err => Console.WriteLine($"\n\nFAILED:\n{err}")
    );