1、pom.xml

<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>4.1.2</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml-schemas</artifactId>
    <version>4.1.2</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi</artifactId>
    <version>4.1.2</version>
</dependency>
<dependency>
    <groupId>org.apache.commons</groupId>
    <artifactId>commons-collections4</artifactId>
    <version>4.4</version>
</dependency>
<dependency>
    <groupId>commons-codec</groupId>
    <artifactId>commons-codec</artifactId>
    <version>1.13</version>
</dependency>
<dependency>
    <groupId>org.apache.commons</groupId>
    <artifactId>commons-compress</artifactId>
    <version>1.19</version>
</dependency>
<dependency>
    <groupId>org.apache.xmlbeans</groupId>
    <artifactId>xmlbeans</artifactId>
    <version>3.1.0</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>ooxml-schemas</artifactId>
    <version>1.4</version>
</dependency>

2、poi 设置文本框

package com.poi.test;
import java.awt.Color;
import java.io.*;
import org.apache.poi.xssf.usermodel.*;
import org.openxmlformats.schemas.drawingml.x2006.main.CTTextCharacterProperties;

public class XlsColors23 {

    static String fileName = "I:/home/irfs/data_file/temp/TestWorkbook23.xlsx";

    public static void main(String[] args) throws Exception {
        XSSFWorkbook wb = new XSSFWorkbook();
        XSSFSheet sht = wb.createSheet();
        File file = new File(fileName);
        //列开始值
        int colStart = 5;
        //创建画布
        XSSFDrawing draw = sht.createDrawingPatriarch();
        //创建锚点（0，0，0，0，col1, row1, col2, row2）
        	/*创建一个新的客户端锚，并设置左上角和右下角
              *通过单元格引用和偏移量锚定的坐标。
              * @param dx1第一个单元格内的x坐标。
              * @param dy1第一个单元格内的y坐标。
              * @param dx2第二个单元格内的x坐标。
              * @param dy2第二个单元格内的y坐标。
              * @param col1第一个单元格的列（从0开始）。
              * @param row1第一个单元格的行（从0开始）。
              * @param col2第二个单元格的列（从0开始）。
              * @param row2第二个单元格的行（从0开始）。
        	 */
        XSSFClientAnchor createAnchor = draw.createAnchor(0, 0, 0, 0, colStart, 11, colStart + 6, 11+7);
        //XSSFShapeGroup group = draw.createGroup(createAnchor);
        //*设置该组的坐标空间。 所有孩子都受到约束至这些坐标。（ x1,  y1,  x2,  y2）
        //group.setCoordinates(colStart, 11, colStart + 6, 11+7);
        //创建子锚点，左上角和右下角（  x, y, cx, cy）
        //XSSFChildAnchor childAnchor = new XSSFChildAnchor(0, 0, 6, 7);
        //创建文本框
        //XSSFTextBox tb1 = group.createTextbox(childAnchor);
        
      //创建文本框
        XSSFTextBox tb1 = draw.createTextbox(createAnchor);
        
        //设置边框颜色，黑色
        tb1.setLineStyleColor(0, 0, 0);
        //设置边框宽度
        //tb1.setLineWidth(2);
        
        //设置填充色，白色
        Color col = Color.white;
        tb1.setFillColor(col.getRed(), col.getGreen(), col.getBlue());
        
        //富文本字符串
        XSSFRichTextString address = new XSSFRichTextString("测试");
        tb1.setText(address);      
        //文字字符属性
        CTTextCharacterProperties rpr = tb1.getCTShape().getTxBody().getPArray(0).getRArray(0).getRPr();
        //设置字体
        rpr.addNewLatin().setTypeface("Trebuchet MS");
        //设置字体大小9pt
        rpr.setSz(900); 
        //设置字体颜色，蓝色
        col = Color.blue;
        rpr.addNewSolidFill().addNewSrgbClr().setVal(new byte[]{(byte)col.getRed(),(byte)col.getGreen(),(byte)col.getBlue()});

        FileOutputStream fout = new FileOutputStream(file);
        wb.write(fout);
        fout.close();
        wb.close();
    }
}

直接上代码

js判断部分

/* 判断文字是否溢出，当溢出才显示popover */
    const hover = () => {
        const checkDom = myDom.cloneNode();
        checkDom.className = Styles.CloneNode;
        checkDom.innerHTML = myDom.innerHTML;
        const parent = myDom.parentNode;
        parent.appendChild(checkDom);
        const flag = checkDom.offsetWidth > myDom.offsetWidth || checkDom.offsetHeight > myDom.offsetHeight;
        parent.removeChild(checkDom);
        setPopoverVisible(flag);
    };

css部分

.Cell {
    :global {
        .ant-popover-content {
          white-space: pre-line;
        }
        .ant-popover-inner-content {
          max-height: 300px;
          overflow: auto;
        }
    }
    display: inline-block;
    vertical-align: middle;
    .Readonly {
        overflow: hidden;
        text-overflow: ellipsis;
        white-space: pre-line;
        display: -webkit-box;
        -webkit-line-clamp: 1;
        /* autoprefixer: off */
        -webkit-box-orient: vertical;
    }
    .CloneNode {
      position: absolute;
      white-space: pre-line;
      opacity: 0;
      z-index: -1;
      & > span {
        display: inline-block;
        width: inherit;
        line-height: 21px;
      }
    }
}

jsx部分

<div className={ Styles.Cell }>
   {
       popoverVisible && showPopover ?
           <Popover overlayStyle={{ width: popWidth }} getPopupContainer={triggerNode => triggerNode.parentNode} content={ value } arrowPointAtCenter autoAdjustOverflow={true}>
               <div
                   className={ Styles.Readonly }
                   style={style}
                   ref={(ref)=>{setMyDom(ref)}}
                   onMouseEnter={ (e) => { hover() } }
               >
               { value || '-' }
               </div>
           </Popover>
           :
           <div
               className={ Styles.Readonly }
               style={style}
               ref={(ref)=>{setMyDom(ref)}}
               onMouseEnter={ (e) => { hover() } }
           >
           {
               value || '-'
           }
           </div>
   }
 </div>

效果图

主要代码

bf_label.py

# -*- coding=utf-8 -*-
import threading
import pygame
from pygame.locals import MOUSEBUTTONDOWN
from bf_common import BFControlId,BFBase,DEFAULT_FONT,TEXT_ALIGN_LEFT,TEXT_ALIGN_MIDDLE,TEXT_ALIGN_RIGHT

CLICK_EFFECT_TIME = 100
PADDING = 4
class BFLabel(BFBase):
    def __init__(self, parent, rect, text='Label', click=None):
        super().__init__()
        self.x,self.y,self.width,self.height = rect
        self.bg_color = (225,225,225)
        self.parent = parent
        self.surface = parent.subsurface(rect)
        self.is_hover = False
        self.in_click = False
        self.click_loss_time = 0
        self.click_event_id = -1
        self.ctl_id = BFControlId().instance().get_new_id()
        self._text = text
        self._click = click
        self.init_font()

    def init_font(self):
        font = DEFAULT_FONT
        white = 100, 100, 100
        self.textImage = font.render(self._text, True, white)
        w, h = self.textImage.get_size()
        self._ty = (self.height - h) / 2
        if self._text_align == TEXT_ALIGN_LEFT:
            self._tx = PADDING
        elif self._text_align == TEXT_ALIGN_MIDDLE:
            self._tx = (self.width - PADDING * 2 - w) / 2
        else:
            self._tx = (self.width - PADDING - w) 

    @property
    def text(self):
        return self._text

    @text.setter
    def text(self, value):
        self._text = value
        self.init_font()

    @property
    def click(self):
        return self._click

    @click.setter
    def click(self, value):
        self._click = value

    def clear_hover(self):
        self.is_hover = False

    def update(self, event):
        if self.in_click and event.type == pygame.USEREVENT+1 and BFControlId().instance().click_id == self.ctl_id:
            if self._click: self._click(self)
            self.click_event_id = -1
            return True

        x, y = pygame.mouse.get_pos()
        if x > self.x and x < self.x + self.width and y > self.y and y < self.y + self.height:
            if self.panel: self.panel.clear_hover()
            self.is_hover = True
            if event.type == MOUSEBUTTONDOWN:
                pressed_array = pygame.mouse.get_pressed()
                if pressed_array[0]:
                    self.in_click = True
                    if self.panel: self.panel.clear_foucs()
                    self.click_loss_time = pygame.time.get_ticks() + CLICK_EFFECT_TIME
                    BFControlId().instance().click_id = self.ctl_id
                    pygame.time.set_timer(pygame.USEREVENT+1,CLICK_EFFECT_TIME-10)
            return True
        else:
            self.is_hover = False
        return False

    def draw(self):
        if self.in_click:
            if self.click_loss_time < pygame.time.get_ticks():
                self.in_click = False
        if not self._visible:
            return

        self.surface.blit(self.textImage, (self._tx, self._ty))

使用方式

bf_lebel = BFLabel(screen, (20,80,160,40),text='文字显示')
bf_lebel.text_align = TEXT_ALIGN_RIGHT
btn_panel.add_control(bf_lebel)

其他完整的代码已经上传github
https://github.com/zhangenter/bf_control