Search Shortcut cmd + k | ctrl + k
Excel Extension

This extension, contrary to its name, does not provide support for reading Excel files. It instead provides a function that wraps the number formatting functionality of the i18npool library, which formats numbers per Excel’s formatting rules.

Excel files can be handled through the spatial extension: see the Excel Import and Excel Export pages for instructions.

Installing and Loading

The excel extension will be transparently autoloaded on first use from the official extension repository. If you would like to install and load it manually, run:

INSTALL excel;
LOAD excel;

Usage

SELECT excel_text(1234567.897, 'h:mm AM/PM') AS timestamp;
┌───────────┐
│ timestamp │
│  varchar  │
├───────────┤
│ 9:31 PM   │
└───────────┘

Functions

Function Description Example Result
excel_text(number, format_string) Alias for text. excel_text(1234567.897, 'h:mm AM/PM') 9:31 PM
text(number, format_string) Format the given number per the rules given in the format_string text(1234567.897, 'h AM/PM') 9 PM

GitHub

The excel extension is part of the main DuckDB repository.

About this page

Last modified: 2024-03-03