Replace placeholders

The following example shows you how to use a workbook as a template by finding cells with placeholder values and replacing them.

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.independentsoft.office.spreadsheet.Cell;
import com.independentsoft.office.spreadsheet.Sheet;
import com.independentsoft.office.spreadsheet.Workbook;
import com.independentsoft.office.spreadsheet.Worksheet;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            Workbook book = new Workbook("c:\\test\\template.xlsx");
            Worksheet ws = (Worksheet) book.getSheets().get(0);

            Map<String, String> replacements = new HashMap<>();
            replacements.put("{{COMPANY}}", "Acme Corporation");
            replacements.put("{{DATE}}", "2026-01-01");
            replacements.put("{{AUTHOR}}", "John Smith");
            replacements.put("{{VERSION}}", "1.0");

            List<Cell> cells = ws.getCells();
            for (Cell cell : cells)
            {
                if (cell.getValue() != null)
                {
                    String val = cell.getValue().toString();
                    if (replacements.containsKey(val))
                    {
                        ws.set(cell.getReference(), new Cell(replacements.get(val)));
                    }
                }
            }

            book.save("c:\\test\\output.xlsx", true);
            System.out.println("Placeholders replaced successfully.");
        }
        catch (Exception e)
        {
            System.out.println(e.getMessage());
            e.printStackTrace();
        }
    }
}

IndependentsoftProfessional software libraries for developers

JSpreadsheet > Tutorial > Replace placeholders

Need help? Ask our developers: