Skip to main content

Excel Constraints

xlmake automatically checks Excel specification constraints and throws errors when violated.

Constraints List​

ItemConstraint
Sheet nameMax 31 characters
Sheet name forbidden characters: \ / ? * [ ]
Max rows1,048,576 rows
Max columns16,384 columns (XFD)

Sheet Name Constraints​

Character Limit​

Sheet names can have a maximum of 31 characters.

// OK
xlmake().sheet("Sales Data 2024")  // 15 characters

// NG: Error thrown
xlmake().sheet("This is a very long sheet name that exceeds 31 characters")

Forbidden Characters​

These characters cannot be used in sheet names:

  • : (colon)
  • \ (backslash)
  • / (slash)
  • ? (question mark)
  • * (asterisk)
  • [ (left bracket)
  • ] (right bracket)
// NG: Error thrown
xlmake().sheet("Sales/Stock")    // Contains slash
xlmake().sheet("Data[2024]")     // Contains brackets

Row/Column Constraints​

Excel's maximum row count is 1,048,576 and maximum column count is 16,384 (XFD column).

xlmake automatically checks these constraints and throws errors when exceeded.

Error Handling​

Constraint violations throw errors, so you can handle them with try-catch.

try {
  const output = await xlmake()
    .sheet("This is a very long sheet name that exceeds 31 characters")
    .table({ ... })
    .getNode();
} catch (error) {
  console.error("Excel constraint violation:", error.message);
}