Giter VIP home page Giter VIP logo

Comments (4)

WeihanLi avatar WeihanLi commented on August 26, 2024

暂时不支持样式配置

from weihanli.npoi.

WeihanLi avatar WeihanLi commented on August 26, 2024

新发布了一个预览版 1.16.0-preview-20210306-055310,写了一个简单的示例,可以参考:

private static void FluentSettingsForExcel()

var setting = FluentSettings.For<TestEntity>();
// ExcelSetting
setting.HasAuthor("WeihanLi")
    .HasTitle("WeihanLi.Npoi test")
    .HasDescription("WeihanLi.Npoi test")
    .HasSubject("WeihanLi.Npoi test");

setting.HasSheetSetting(config =>
{
    config.StartRowIndex = 1;
    config.SheetName = "SystemSettingsList";
    config.AutoColumnWidthEnabled = true;

    config.RowAction = row =>
    {
        if (row.RowNum == 0)
        {
            var style = row.Sheet.Workbook.CreateCellStyle();
            style.Alignment = HorizontalAlignment.Center;
            var font = row.Sheet.Workbook.CreateFont();
            font.FontName = "JetBrains Mono";
            font.IsBold = true;
            font.FontHeight = 200;
            style.SetFont(font);
            row.Cells.ForEach(c => c.CellStyle = style);
        }
    };
});
//...

导出效果如下:
export result

from weihanli.npoi.

WeihanLi avatar WeihanLi commented on August 26, 2024

这里还有一个示例
https://github.com/WeihanLi/DbTool/blob/wpf-dev/src/DbTool/ExcelDbDocExporter.cs#L12

from weihanli.npoi.

WeihanLi avatar WeihanLi commented on August 26, 2024

fixed by #106 ,请使用 1.16.0 及以上版本,如果使用过程中有问题,欢迎重新提 issue

from weihanli.npoi.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.