kandi background
Explore Kits

easyexcel | 快速、简单避免OOM的java处理Excel工具 | Data Visualization library

 by   alibaba Java Version: v1.1 License: Apache-2.0

 by   alibaba Java Version: v1.1 License: Apache-2.0

Download this library from

kandi X-RAY | easyexcel Summary

easyexcel is a Java library typically used in Analytics, Data Visualization applications. easyexcel has no bugs, it has no vulnerabilities, it has build file available, it has a Permissive License and it has medium support. You can download it from GitHub, Maven.
快速、简洁、解决大文件内存溢出的java处理Excel工具
Support
Support
Quality
Quality
Security
Security
License
License
Reuse
Reuse

kandi-support Support

  • easyexcel has a medium active ecosystem.
  • It has 22981 star(s) with 6192 fork(s). There are 584 watchers for this library.
  • It had no major release in the last 12 months.
  • There are 138 open issues and 1988 have been closed. On average issues are closed in 53 days. There are 25 open pull requests and 0 closed requests.
  • It has a neutral sentiment in the developer community.
  • The latest version of easyexcel is v1.1
easyexcel Support
Best in #Data Visualization
Average in #Data Visualization
easyexcel Support
Best in #Data Visualization
Average in #Data Visualization

quality kandi Quality

  • easyexcel has 0 bugs and 0 code smells.
easyexcel Quality
Best in #Data Visualization
Average in #Data Visualization
easyexcel Quality
Best in #Data Visualization
Average in #Data Visualization

securitySecurity

  • easyexcel has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.
  • easyexcel code analysis shows 0 unresolved vulnerabilities.
  • There are 0 security hotspots that need review.
easyexcel Security
Best in #Data Visualization
Average in #Data Visualization
easyexcel Security
Best in #Data Visualization
Average in #Data Visualization

license License

  • easyexcel is licensed under the Apache-2.0 License. This license is Permissive.
  • Permissive licenses have the least restrictions, and you can use them in most projects.
easyexcel License
Best in #Data Visualization
Average in #Data Visualization
easyexcel License
Best in #Data Visualization
Average in #Data Visualization

buildReuse

  • easyexcel releases are available to install and integrate.
  • Deployable package is available in Maven.
  • Build file is available. You can build the component from source.
  • Installation instructions are not available. Examples and code snippets are available.
  • easyexcel saves you 2088 person hours of effort in developing the same functionality from scratch.
  • It has 4583 lines of code, 536 functions and 60 files.
  • It has high code complexity. Code complexity directly impacts maintainability of the code.
easyexcel Reuse
Best in #Data Visualization
Average in #Data Visualization
easyexcel Reuse
Best in #Data Visualization
Average in #Data Visualization
Top functions reviewed by kandi - BETA

kandi has reviewed easyexcel and discovered the below as its top functions. This is intended to give you an instant insight into easyexcel implemented functionality, and help decide if they suit your requirements.

  • Create date format .
  • Fills the rows .
  • Adds a Java object to an Excel object .
  • Builds the style property .
  • Determines if the specified format string is an internal date format .
  • Get a map of all field content properties for a given class .
  • Build the execution chain .
  • Set the cell data
  • Builds the cell value .
  • This method creates a workbook based on write workbook .

easyexcel Key Features

快速、简洁、解决大文件内存溢出的java处理Excel工具

Community Discussions

Trending Discussions on easyexcel
  • why the easy excel set cell style did not work
Trending Discussions on easyexcel

QUESTION

why the easy excel set cell style did not work

Asked 2022-Feb-14 at 12:07

I am using easy excel api group: 'com.alibaba', name: 'easyexcel', version: '3.0.3' to set the cell color, this is the main.java code:

public class AppStarter {

    public static void main(String[] args) {
        SparkUserExcelRequest request = new SparkUserExcelRequest();
        request.setNickname("test");
        String writePathName = "/Users/dolphin/source/dabai/microservice/soa-zhuolian-org/";
        String fullPathName = writePathName  + "a.xlsx";
        if (!new File(writePathName).exists()) {
            new File(writePathName).mkdirs();
        }
        ExcelWriterBuilder writerBuilder = EasyExcel.write(fullPathName, SparkUserExcelRequest.class);
        writerBuilder.excelType(ExcelTypeEnum.XLSX);
        writerBuilder.registerWriteHandler(new CellStyleWriteHandler());
        ExcelWriter writer = writerBuilder.build();
        WriteSheet writeSheet = new WriteSheet();
        writeSheet.setSheetName("mark");
        writer.write(Arrays.asList(request), writeSheet);
        writer.finish();
    }
}

this is the class which change the cell color:

public class CellStyleWriteHandler extends AbstractCellStyleStrategy {

    @Override
    protected void setContentCellStyle(Cell cell, Head head, Integer relativeRowIndex) {
        Workbook workbook = cell.getSheet().getWorkbook();
        CellStyle cellStyle = workbook.createCellStyle();
        cellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
        cellStyle.setFillForegroundColor(IndexedColors.LIGHT_BLUE.getIndex());
        cell.setCellStyle(cellStyle);
    }
}

and this is the entity class:

@Data
@ExcelIgnoreUnannotated
public class SparkUserExcelRequest implements Serializable {

    @ExcelProperty("user name")
    private String nickname;
}

when I run this code, this cell color did not changed to light blue, why the cell color set failed? what should I do to fix this problem? I want the test cell color changed to blue.

enter image description here

ANSWER

Answered 2022-Feb-14 at 12:07

I tried your code, and the color did not change. Tried to downgrade your easyexcel version to 2.2.11 should fix this problem.You could add an issue to make sure is it a bug.

api group: 'com.alibaba', name: 'easyexcel', version: '2.2.11'

Source https://stackoverflow.com/questions/71111037

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install easyexcel

You can download it from GitHub, Maven.
You can use easyexcel like any standard Java library. Please include the the jar files in your classpath. You can also use any IDE and you can run and debug the easyexcel component as you would do with any other Java program. Best practice is to use a build tool that supports dependency management such as Maven or Gradle. For Maven installation, please refer maven.apache.org. For Gradle installation, please refer gradle.org .

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

DOWNLOAD this Library from

Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from
over 430 million Knowledge Items
Find more libraries
Reuse Solution Kits and Libraries Curated by Popular Use Cases

Save this library and start creating your kit

Explore Related Topics

Share this Page

share link
Consider Popular Data Visualization Libraries
Compare Data Visualization Libraries with Highest Support
Compare Data Visualization Libraries with Highest Quality
Compare Data Visualization Libraries with Highest Security
Compare Data Visualization Libraries with Permissive License
Compare Data Visualization Libraries with Highest Reuse
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from
over 430 million Knowledge Items
Find more libraries
Reuse Solution Kits and Libraries Curated by Popular Use Cases

Save this library and start creating your kit

  • © 2022 Open Weaver Inc.