Replace placeholders

The following example shows you how to use a workbook as a template. Replace accepts a list of placeholders and a list of values and fills the whole workbook in a single pass. The format of every cell is preserved, so a template can be designed in Excel and filled from your application.

import java.util.ArrayList;
import java.util.List;

import com.independentsoft.office.spreadsheet.Workbook;

public class Example {

    public static void main(String[] args)
    {
        try
        {
            // Load a template workbook containing placeholders like {COMPANY}, {DATE}, {AUTHOR}
            Workbook book = new Workbook("c:\\test\\template.xlsx");

            List<String> placeholders = new ArrayList<String>();
            placeholders.add("{COMPANY}");
            placeholders.add("{DATE}");
            placeholders.add("{AUTHOR}");
            placeholders.add("{VERSION}");

            List<String> values = new ArrayList<String>();
            values.add("Acme Corporation");
            values.add("2026-06-30");
            values.add("John Smith");
            values.add("1.0");

            // Replace all placeholders in a single pass
            int count = book.replace(placeholders, values);

            System.out.println(count + " placeholders replaced.");

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

import com.independentsoft.office.spreadsheet.Workbook;

public class Example {

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

            book.replace("{COMPANY}", "Acme Corporation");

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

JSpreadsheet > Tutorial > Replace placeholders

Need help? Ask our developers: