cn.idev.excel.write.handler

Class EscapeHexCellWriteHandler

java.lang.Object

cn.idev.excel.write.handler.EscapeHexCellWriteHandler

All Implemented Interfaces:

Handler, Order, CellWriteHandler, WriteHandler

public class EscapeHexCellWriteHandler
extends Object
implements CellWriteHandler

A cell write handler that escapes _x[0-9A-Fa-f]{4}_ format strings to prevent POI from automatically decoding them.

In Office Open XML, _xHHHH_ format is used to encode special characters. For example, _x000D_ represents the Unicode character 0D (carriage return).

To store the literal _xHHHH_ sequence without it being decoded by POI, we need to escape the initial underscore by replacing _x with _x005F_x.

Constructor Summary

Constructors

Constructor and Description
EscapeHexCellWriteHandler()

Method Summary

Modifier and Type	Method and Description
void	afterCellDataConverted(WriteSheetHolder writeSheetHolder, WriteTableHolder writeTableHolder, WriteCellData<?> cellData, org.apache.poi.ss.usermodel.Cell cell, Head head, Integer relativeRowIndex, Boolean isHead) Called after the cell data is converted

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface cn.idev.excel.write.handler.CellWriteHandler

afterCellCreate, afterCellCreate, afterCellDataConverted, afterCellDispose, afterCellDispose, beforeCellCreate, beforeCellCreate

Methods inherited from interface cn.idev.excel.event.Handler

order

Constructor Detail

EscapeHexCellWriteHandler

public EscapeHexCellWriteHandler()

Method Detail

afterCellDataConverted

public void afterCellDataConverted(WriteSheetHolder writeSheetHolder,
                                   WriteTableHolder writeTableHolder,
                                   WriteCellData<?> cellData,
                                   org.apache.poi.ss.usermodel.Cell cell,
                                   Head head,
                                   Integer relativeRowIndex,
                                   Boolean isHead)

Description copied from interface: CellWriteHandler

Called after the cell data is converted

Specified by:

afterCellDataConverted in interface CellWriteHandler

writeTableHolder - Nullable.It is null without using table writes.

cellData - Nullable.It is null in the case of add header.

head - Nullable.It is null in the case of fill data and without head.

relativeRowIndex - Nullable.It is null in the case of fill data.

isHead - It will always be false when fill data.