Easily generate spreadsheets, like CSVs and Excel files.
- Generate CSV files
- Generate Excel files
- Store spreadsheets to disk
- Download spreadsheets as a Response object
- Simple API for creating and manipulating spreadsheets
- Fully typed
- Optimized for Bun
- Lightweight & dependency-free
bun install bun-spreadsheetsNow, you can use it in your project:
import { spreadsheet, createSpreadsheet } from 'bun-spreadsheets'
// Create a spreadsheet
const data = {
headings: ['Name', 'Age', 'City'],
data: [
['John Doe', 30, 'Los Angeles'],
['Jana Schmidt', 25, 'Berlin'],
['Bob Johnson', 35, 'London']
]
}
// Generate and manipulate spreadsheets
// 1. Using createSpreadsheet function
const spreadsheet = createSpreadsheet(data) // defaults to csv
const csvSpreadsheet = createSpreadsheet(data, { type: 'csv' })
const excelSpreadsheet = createSpreadsheet(data, { type: 'excel' })
// Store the spreadsheet to disk
await spreadsheet.store('output.csv')
// Create a download response
const response1 = excelSpreadsheet.download('data.xlsx') // downloads and stores as data.xlsx on your filesystem
// 2. Using spreadsheet object directly, and chain if desired
const csvContent = spreadsheet(data).generateCSV().store('output2.csv')
const csvContent2 = spreadsheet(data).csv().store('output3.csv') // same as above
const excelContent = spreadsheet(data).generateExcel()
await excelContent.store('output3.xlsx')
const response2 = await excelContent.download('output3.xlsx') // downloads and stores as output3.xlsx
// 3. Accessing raw content
const rawCsvContent = spreadsheet(data).csv().getContent()
const rawCsvContent2 = spreadsheet(data).generateCSV().getContent()
const rawExcelContent = spreadsheet(data).excel().getContent()
const rawExcelContent2 = spreadsheet(data).generateExcel().getContent()
console.log('CSV Content:', rawCsvContent)
console.log('Excel Content:', rawExcelContent)Creates a spreadsheet object with various methods.
data: An object containingheadingsanddatafor the spreadsheet.
Returns an object with the following methods:
csv(): Generates a CSV SpreadsheetWrapperexcel(): Generates an Excel SpreadsheetWrapperstore(path: string): Stores the spreadsheet to a filegenerateCSV(): Generates a CSV SpreadsheetWrappergenerateExcel(): Generates an Excel SpreadsheetWrapper
Example:
const csvWrapper = await spreadsheet(data).csv() // equivalent to spreadsheet(data).generateCSV()Creates a SpreadsheetWrapper with the given data and options.
data: An object containingheadingsanddatafor the spreadsheet.options: Optional. An object specifying the spreadsheet type ('csv' or 'excel').
Returns a SpreadsheetWrapper.
Example:
const spreadsheet = createSpreadsheet(data, { type: 'csv' })Returns the content of the spreadsheet as a string or Uint8Array.
Creates a download Response for the spreadsheet.
filename: The name of the file to be downloaded.
Returns a Response object.
Stores the spreadsheet to a file.
path: The file path where the spreadsheet will be stored.
Returns a Promise that resolves when the file is written.
Creates a SpreadsheetContent object.
data: An object containingheadingsanddatafor the spreadsheet.options: Optional. An object specifying the spreadsheet type ('csv' or 'excel').
Returns a SpreadsheetContent object.
Generates spreadsheet content based on the given data and options.
data: An object containingheadingsanddatafor the spreadsheet.options: Optional. An object specifying the spreadsheet type ('csv' or 'excel').
Returns a string or Uint8Array representing the spreadsheet content.
Generates a CSV SpreadsheetWrapper.
content: An object containingheadingsanddatafor the spreadsheet.
Returns a SpreadsheetWrapper for CSV, which can be used to chain other methods like store() or download().
Example:
await spreadsheet(data).generateCSV().store('output.csv')
// if one can rely on the file extension to determine the type, you may do this:
await spreadsheet(data).store('output.csv')Generates an Excel SpreadsheetWrapper.
content: An object containingheadingsanddatafor the spreadsheet.
Returns a SpreadsheetWrapper for Excel, which can be used to chain other methods like store() or download().
Example:
await spreadsheet(data).store('output.xlsx')
// or
await spreadsheet(data).generateExcel().store('output.xlsx')To view the full documentation, please visit https://stacksjs.org/docs/bun-spreadsheets.
bun testPlease see our releases page for more information on what has changed recently.
Please review the Contributing Guide for details.
For help, discussion about best practices, or any other conversation that would benefit from being searchable:
For casual chit-chat with others using this package:
Join the Stacks Discord Server
Many thanks to the following core technologies & people who have contributed to this package:
The MIT License (MIT). Please see LICENSE for more information.
Made with 💙