Home > Back-end >  How to find the same data in the EXCLE, and use a different background color grouping symbol to dist
How to find the same data in the EXCLE, and use a different background color grouping symbol to dist

Time:09-19

As shown in figure, EXCLE file, multi-line
Category is to merge cells, order chain consists of multiple column of figures
Implement requirements:
Order chain (that is, the same beauty column of Numbers are the same) the category of the line, all with the same background color (or add a tag other fields), grouping, and so on,
For example:
Project was "AA project" and "BB" exactly the same as the order of the chain, then the background color of the two categories are marked red, tag, fill the number 1,
XXX and YYY "applications" exactly the same as the order of the chain, the background color was red, the tag column, fill the number 2,


The thoughts and the code of implementation, genuflect is begged please than action, be obliged!

CodePudding user response:

Easypoi CellStyle class specific see http://easypoi.mydoc.io/website document
  • Related