level: basic / verified: 2026-10-04 / tabs: Node.js・Python・Java・PHP・WebAssembly / Back to Index / 日本語
What you want to do
Create a new xlsx, write a table (headers, strings, numbers, formulas) and save the file. This applies the basic flow from the overview to real table building.
Resulting image
Sheet1 of sales.xlsx will contain this table:
A
B
C
D
1
Product
Unit Price
Qty
Amount
2
Apple
100
3
300
3
Orange
50
6
300
4
Grape
150
2
300
5
Total
900
Column D holds the formula B*C; D5 holds SUM(D2:D4).
For detailed per-OS PHP installation steps (Linux / macOS / Windows, including when Composer is not installed), see the Quickstart.
The WebAssembly build uses MEMORY64 (Wasm 3.0), so the runtime must support it (Chrome/Edge 133+, Firefox 134+, Node.js 24+. Safari is not supported yet).
If you omit the directory in the path ("sales.xlsx"), the file is written to the process current working directory.
npm install ./nodeosbxl-2.0.1.tgz
# (example) Python 3.12+ (a single abi3 wheel covers 3.12 and later)
pip install ./pyosbxl-2.0.1-cp312-abi3-linux_x86_64.whl
# Add the JAR to your classpath (javacpp-1.5.14.jar is also required)
javac -cp osbxl-2.0.1.jar:javacpp-1.5.14.jar Main.java
java -cp osbxl-2.0.1.jar:javacpp-1.5.14.jar:. Main
# Place the downloaded .zip matching your OS and PHP version into the working directory
# (e.g. ~/phposbxl-test)
composer config repositories.phposbxl artifact ~/phposbxl-test/
composer require osb-office/phposbxl
vendor/bin/phposbxl-install
# Install the package
npm install wasmosbxl-2.0.1.tgz
// Loading example (requires Node.js 24+: this wasm is a MEMORY64 = Wasm 3.0 build)
const fs = require("fs");
const createModule = require("./package/osbxl_wasm.js"); // emscripten factory
const { createOsbxl } = require("./package/osbxl_em.js"); // loader + enum definitions
createOsbxl(createModule).then(({ Module, osbxl, dto, chart, enums }) => {
// Stage the license file into the wasm virtual FS (required before new App())
const lic = process.env.OSB_LICENSE_PATH_WASM; // e.g. /root/lic_node.osb
if (lic && fs.existsSync(lic)) {
Module.FS.mkdirTree(lic.substring(0, lic.lastIndexOf("/")));
Module.FS.writeFile(lic, fs.readFileSync(lic));
}
const app = new osbxl.App(); // from here on it matches the Node.js build (namespace name is osbxl)
// ...
});
// In the browser, load osbxl_wasm.js via <script> and call createOsbxl the same way.
// Supported: Chrome/Edge 133+, Firefox 134+ (Safari not supported yet)
Code
Output:
// values-formulas.js — create a book, write values and formulas, save
const { nodeosbxl, dto } = require("nodeosbxl");
const app = new nodeosbxl.App();
const wb = app.createWorkBook("sales.xlsx"); // new workbook
const ws = wb.openWorkSheet("Sheet1"); // open the default sheet
// --- header (row 1) ---
// app.convertFromRowColNumber(row, col) gives the A1 address for (1,1) -> "A1"
["Product", "Unit Price", "Qty", "Amount"].forEach((text, i) => {
const cell = app.convertFromRowColNumber(1, i + 1);
ws.getRange(`${cell}:${cell}`).setValue(text);
});
// --- detail rows (2-4) ---
const data = [["Apple", 100, 3], ["Orange", 50, 6], ["Grape", 150, 2]];
data.forEach(([name, price, qty], i) => {
const row = i + 2;
ws.getRange(`A${row}:A${row}`).setValue(name);
ws.getRange(`B${row}:B${row}`).setNumberValue(price);
ws.getRange(`C${row}:C${row}`).setNumberValue(qty);
});
// --- amount column (D2:D4) ---
// Each row needs its own relative reference, so use setRangeFormulas.
// Formula strings do NOT take a leading "=".
const formulas = data.map((_, i) => [`B${i + 2}*C${i + 2}`]);
ws.setRangeFormulas("D2", formulas);
// --- total (D5) ---
ws.getRange("C5:C5").setValue("Total");
ws.getRange("D5:D5").setFormula("SUM(D2:D4)");
// --- read back ---
// getValue(true) returns raw values = formula results
const values = ws.getRange("A1:D5").getValue(true);
console.log("Amount D2:D4 =", [values["D2"], values["D3"], values["D4"]].join(", "));
console.log("Total:", values["D5"]);
// --- save and close ---
wb.save();
wb.close();
# values-formulas.py — same verification as the Node.js sample (pyosbxl)
import pyosbxl
app = pyosbxl.App()
wb = app.createWorkBook("sales-py.xlsx") # new workbook
ws = wb.openWorkSheet("Sheet1") # open the default sheet
# --- header (row 1) ---
# app.convertFromRowColNumber(row, col) gives the A1 address for (1,1) -> "A1"
for i, text in enumerate(["Product", "Unit Price", "Qty", "Amount"]):
cell = app.convertFromRowColNumber(1, i + 1)
ws.getRange(f"{cell}:{cell}").setValue(text)
# --- detail rows (2-4) ---
data = [("Apple", 100, 3), ("Orange", 50, 6), ("Grape", 150, 2)]
for i, (name, price, qty) in enumerate(data):
row = i + 2
ws.getRange(f"A{row}:A{row}").setValue(name)
ws.getRange(f"B{row}:B{row}").setNumberValue(price)
ws.getRange(f"C{row}:C{row}").setNumberValue(qty)
# --- amount column (D2:D4) ---
# Each row needs its own relative reference, so use setRangeFormulas.
# Formula strings do NOT take a leading "=".
formulas = [[f"B{i + 2}*C{i + 2}"] for i in range(len(data))]
ws.setRangeFormulas("D2", formulas)
# --- total (D5) ---
ws.getRange("C5:C5").setValue("Total")
ws.getRange("D5:D5").setFormula("SUM(D2:D4)")
# --- read back ---
# getValue(True) returns raw values = formula results
values = ws.getRange("A1:D5").getValue(True)
print("Amount D2:D4 =", ", ".join([values["D2"], values["D3"], values["D4"]]))
print("Total:", values["D5"])
# --- save and close ---
wb.save()
wb.close();
// values-formulas.java — same verification as the Node.js sample (javaosbxl)
import com.osboffice.osbxl.*;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;
import java.util.Map;
public class Main {
public static void main(String[] args) {
AppWrapper app = new AppWrapper();
WorkBookWrapper wb = app.createWorkBook("sales-java.xlsx"); // new workbook
WorkSheetWrapper ws = wb.openWorkSheet("Sheet1"); // open the default sheet
// --- header (row 1) ---
// app.convertFromRowColNumber(row, col) gives the A1 address for (1,1) -> "A1"
String[] headers = { "Product", "Unit Price", "Qty", "Amount" };
for (int i = 0; i < headers.length; i++) {
String cell = app.convertFromRowColNumber(1, i + 1);
ws.getRange(cell + ":" + cell).setValue(headers[i]);
}
// --- detail rows (2-4) ---
String[] names = { "Apple", "Orange", "Grape" };
double[] prices = { 100, 50, 150 };
double[] qtys = { 3, 6, 2 };
for (int i = 0; i < names.length; i++) {
int row = i + 2;
ws.getRange("A" + row + ":A" + row).setValue(names[i]);
ws.getRange("B" + row + ":B" + row).setNumberValue(prices[i]);
ws.getRange("C" + row + ":C" + row).setNumberValue(qtys[i]);
}
// --- amount column (D2:D4) ---
// Each row needs its own relative reference, so use setRangeFormulas.
// Formula strings do NOT take a leading "=".
List<List<String>> formulas = new ArrayList<>();
for (int i = 0; i < names.length; i++) {
formulas.add(Collections.singletonList("B" + (i + 2) + "*C" + (i + 2)));
}
ws.setRangeFormulas("D2", formulas);
// --- total (D5) ---
ws.getRange("C5:C5").setValue("Total");
ws.getRange("D5:D5").setFormula("SUM(D2:D4)");
// --- read back ---
// getValue(true) returns raw values = formula results
Map<String, String> values = ws.getRange("A1:D5").getValue(true);
System.out.println("Amount D2:D4 = "
+ String.join(", ", values.get("D2"), values.get("D3"), values.get("D4")));
System.out.println("Total: " + values.get("D5"));
// --- save and close ---
wb.save();
wb.close();
}
}
// values-formulas.php — same verification as the Node.js sample (phposbxl)
// Body only (<?php and the autoload require are added by the harness)
$app = new \phposbxl\App();
$wb = $app->createWorkBook("sales-php.xlsx"); // new workbook
$ws = $wb->openWorkSheet("Sheet1"); // open the default sheet
// --- header (row 1) ---
// $app->convertFromRowColNumber(row, col) gives the A1 address for (1,1) -> "A1"
$headers = ["Product", "Unit Price", "Qty", "Amount"];
foreach ($headers as $i => $text) {
$cell = $app->convertFromRowColNumber(1, $i + 1);
$ws->getRange("{$cell}:{$cell}")->setValue($text);
}
// --- detail rows (2-4) ---
$data = [["Apple", 100, 3], ["Orange", 50, 6], ["Grape", 150, 2]];
foreach ($data as $i => [$name, $price, $qty]) {
$row = $i + 2;
$ws->getRange("A{$row}:A{$row}")->setValue($name);
$ws->getRange("B{$row}:B{$row}")->setNumberValue($price);
$ws->getRange("C{$row}:C{$row}")->setNumberValue($qty);
}
// --- amount column (D2:D4) ---
// Each row needs its own relative reference, so use setRangeFormulas.
// Formula strings do NOT take a leading "=".
$formulas = [];
for ($i = 0; $i < count($data); $i++) {
$row = $i + 2;
$formulas[] = ["B{$row}*C{$row}"];
}
$ws->setRangeFormulas("D2", $formulas);
// --- total (D5) ---
$ws->getRange("C5:C5")->setValue("Total");
$ws->getRange("D5:D5")->setFormula("SUM(D2:D4)");
// --- read back ---
// getValue(true) returns raw values = formula results
$values = $ws->getRange("A1:D5")->getValue(true);
echo "Amount D2:D4 = " . implode(", ", [$values["D2"], $values["D3"], $values["D4"]]) . "\n";
echo "Total: " . $values["D5"] . "\n";
// --- save and close ---
$wb->save();
$wb->close();
// values-formulas.wasm.js — same verification as the Node.js sample (wasmosbxl / embind)
// Note (WebAssembly build): load the module first with createOsbxl(createModule).
// osbxl / dto / chart / enums used below are the four namespaces it returns
// (the equivalent of require("nodeosbxl") in the Node.js build).
const app = new osbxl.App();
const wb = app.createWorkBook("sales-wasm.xlsx"); // new workbook
const ws = wb.openWorkSheet("Sheet1"); // open the default sheet
// --- header (row 1) ---
// app.convertFromRowColNumber(row, col) gives the A1 address for (1,1) -> "A1"
["Product", "Unit Price", "Qty", "Amount"].forEach((text, i) => {
const cell = app.convertFromRowColNumber(1, i + 1);
ws.getRange(`${cell}:${cell}`).setValue(text);
});
// --- detail rows (2-4) ---
const data = [["Apple", 100, 3], ["Orange", 50, 6], ["Grape", 150, 2]];
data.forEach(([name, price, qty], i) => {
const row = i + 2;
ws.getRange(`A${row}:A${row}`).setValue(name);
ws.getRange(`B${row}:B${row}`).setNumberValue(price);
ws.getRange(`C${row}:C${row}`).setNumberValue(qty);
});
// --- amount column (D2:D4) ---
// Each row needs its own relative reference, so use setRangeFormulas.
// Formula strings do NOT take a leading "=".
const formulas = data.map((_, i) => [`B${i + 2}*C${i + 2}`]);
ws.setRangeFormulas("D2", formulas);
// --- total (D5) ---
ws.getRange("C5:C5").setValue("Total");
ws.getRange("D5:D5").setFormula("SUM(D2:D4)");
// --- read back ---
// getValue(true) returns raw values = formula results
const values = ws.getRange("A1:D5").getValue(true);
console.log("Amount D2:D4 =", [values["D2"], values["D3"], values["D4"]].join(", "));
console.log("Total:", values["D5"]);
// --- save and close ---
wb.save();
wb.close();
Amount D2:D4 = 300, 300, 300
Total: 900
Notes
new nodeosbxl.App() is the single entry point. From App you get a WorkBook via createWorkBook() / openWorkBook(), then a WorkSheet via openWorkSheet(), then a Range via getRange().
Cell addresses are strings like "A1:B2". Even a single cell uses the range form "A1:A1". To build them from 1-based row/column numbers use app.convertFromRowColNumber(row, col), or app.convertFromRowColNumber2(startRow, startCol, endRow, endCol) for ranges.
Each value type has its own setter.setValue(string) / setNumberValue(number) / setDateValue(DateTimeObject) / setDateStringValue(date string) / setBooleanValue(bool).
The true in getValue(true) means "raw value" (formula result). Without it you get the display value (after number formatting). The return value is a map like { "A1": "100", ... } and all values are strings; convert with Number(...) when comparing.
Finish with wb.save() then wb.close(). Use wb.saveAs(path) to write a second file, but note that saveAs() does not switch the destination of later saves (see overview caveats).
Caveats
Do not prefix formulas with =. Use setFormula("SUM(A1:A3)"), not setFormula("=SUM(A1:A3)").
setValue / setNumberValue on a multi-cell Range writes the same value to every cell.ws.getRange("A1:C1").setValue("X") puts "X" into A1, B1 and C1.
setFormula() does not auto-fill relative references.ws.getRange("B1:B3").setFormula("A1*2") puts the formula into B1 only; B2 / B3 stay empty. The third argument variant setFormula("A1*2", false, true) (setAllCell = true) merely copies the same string into every cell — it does not become A2*2, A3*2 (all of B1:B3 end up with the same value). To shift formulas per row, use setRangeFormulas() (high-speed bulk write via 2D array) as in this sample.
A license banner line is printed to stdout once per process. Keep it in mind when parsing standard output.