MySheet 1.0.5

MySheet

Thanks

Icon author: Excel icons created by Freepik - Flaticon

Contacts

To report a bug or make a request, send an email to: microboz_reg-dev@yahoo.com

Examples

Create new Excel package

    MySheet.MySheet objXsl = new()
    {
        Creator = "Microboz",
        Description = "New Excel test !",
        Title = "My title",
        Subject = "My subject",
        Category = "My category",
        Keywords = "tag 1, tag 2, tag 3"
    };
    MySheet.WorkSheet objWs = objXsl.CreateWorkSheet("Test");
    objWs.AddCell(
        new Point(4, 4),
        new Cell(
            "TEST STYLE",
            new()
            {
                Border = new Cell.StyleInfo.BorderInfo(true, Cell.StyleInfo.BorderInfo.BorderSize.medium, Color.Red),
                BgColor = Color.Yellow,
                FgColor = Color.Blue,
                Font = new Font("Arial", 20),
                TextAlignment = Cell.StyleInfo.TextAlign.center
            }
        )
    );
    objWs.AutoFitColumns();
    byte[] bXslx = objXsl.Save();
    File.WriteAllBytes(@"C:\myExcel\test.xlsx", bXslx);
    objXsl.Dispose();

Load Excel package

    MySheet.MySheet objXsl = new();
    objXsl.Load(File.ReadAllBytes(@"C:\myExcel\test.xlsx"));
    objXsl.Dispose();

Import / Export

    MySheet.MySheet objXsl = new();
    // Load Excel
    objXsl.Load(File.ReadAllBytes(@"C:\myExcel\test_src.xlsx"));
    // Export WorkSheet into datatable
    MySheet.WorkSheet objWs = objXsl.GetWorkSheet(0);
    DataTable dt = objWs.ExportToDataTable(true);
    // Create new WorkSheet ad import data from datatable
    MySheet.WorkSheet objWs2 = objXsl.CreateWorkSheet("second");
    objWs2.ImportFromDataTable(dt);
    objWs2.AutoFitColumns();
    // Export all sheets into dataset
    DataSet ds = objXsl.ExportToDataSet(true);
    // Remove first worksheet
    objXsl.RemoveWorkSheet(0);
    // Finalize
    File.WriteAllBytes(@"C:\myExcel\test_dst.xlsx", objXsl.Save());
    objXsl.Dispose();

Version history

1.0.5 (2023-05-24)

• Various optimizations.
• Bugfix: styles generation.

1.0.4 (2023-05-18)

• Export WorkSheet to DataTable.
• Export WorkSheet to CSV.
• Import WorkSheet from DataTable.
• Import WorkSheet from CSV.
• Merge cells.
• Remove formula.
• Remove cell.
• Add images.

1.0.3 (2023-04-06)

• Custom columns width.
• Custom rows height.
• Vertical alignment.
• Font attributes (bold/italic/underline).
• Load Excel package.

1.0.2 (2023-03-17)

• Formulas.
• Rows height.
• Fix calculate cell position.

1.0.1 (2023-03-03)

• Added icon.
• Added cell diagonals.
• Various improvements.

1.0.0 (2023-02-27)

• First public release.