Apache POI的DataFormatter类是否线程安全？能否多线程共享实例？

Great question! Let's break this down clearly and practically:

Short Answer #

Yes, you can safely share a single DataFormatter instance across multiple threads — it’s designed to be thread-safe for standard usage scenarios.

Context & Official Alignment #

First, referencing the POI FAQ note you cited:

…全局持有的对象（如全局缓存或其他数据结构）会针对多线程访问进行保护……

While the FAQ doesn’t explicitly name DataFormatter, this design principle applies directly to it. POI’s tooling classes like DataFormatter rely on internal cached data structures (for cell formats, locale mappings, etc.) that are guarded for multi-threaded access. The core method formatCellValue() is thread-safe when you’re only using the formatter to read and process cell values.

Key Caveats to Keep in Mind #

• If you’re adding custom format rules (via addFormat() or similar configuration methods), those modification operations are not thread-safe. To avoid issues:
  • Configure all custom formats once before sharing the instance across threads, or
  • Wrap any configuration changes in synchronization locks if you need to modify the formatter at runtime.
• For the most common use case — just formatting cell values across threads — you won’t run into concurrency problems.

Example of Safe Shared Usage #

// Initialize a single DataFormatter instance once (e.g., as a static field)
private static final DataFormatter SHARED_FORMATTER = new DataFormatter();

// Use it safely across multiple threads
ExecutorService threadPool = Executors.newFixedThreadPool(4);
for (Row row : myExcelSheet) {
    threadPool.submit(() -> {
        for (Cell cell : row) {
            String formattedValue = SHARED_FORMATTER.formatCellValue(cell);
            // Process the formatted value without worries
        }
    });
}

内容的提问来源于stack exchange，提问作者Ehler