Skip to content

v0.41.0 - DataFrame.toSheet (2026-03-23)

What Changed?

This release adds toSheet to both DataFrame and FlameFrame in the v2 module. You can now write a DataFrame directly to a Google Apps Script Sheet object with a single method call. The method supports overwrite (default) and append workflows via clear, header, and startRow options.

What's New

Main Feature: DataFrame.toSheet / FlameFrame.toSheet

What it does: Writes the DataFrame contents to a GAS Sheet object. By default it clears the sheet and writes from row 1 with a header row. Options allow appending data without clearing the sheet.

How to use it:

TypeScript
// Overwrite sheet (default)
df.toSheet(sheet);

// Append without header
df.toSheet(sheet, {
  clear: false,
  header: false,
  startRow: sheet.getLastRow() + 1,
});

// FlameFrame works the same way
const { frame } = FlameFrame.fromColumns({ name: ["Alice"], age: [25] }, schema);
frame.toSheet(sheet);

Added

  • DataFrame.toSheet(sheet, options?) — writes DataFrame to a GAS Sheet (src/v2/frame.ts)
  • FlameFrame.toSheet(sheet, options?) — delegates to DataFrame.toSheet (src/v2/flameframe.ts)
  • ToSheet options: clear (default: true), header (default: true), startRow (default: 1)

Changed

  • pilotlamp/suites/suiteFlameFrame.js — error reporting test simplified to use errorDf.toSheet(sheet); suiteToSheet added for write and append integration tests

Fixed

  • None

Is It Safe to Upgrade?

  • Breaking Changes: No
  • Backward Compatible: Yes

Existing code is unaffected. toSheet is a new addition to DataFrame and FlameFrame.

Release Details

  • Date: 2026-03-23
  • Version: v0.41.0
  • gaslamp: clasp version 88
  • pilotlamp: clasp version 45
  • Files Changed: 151
  • Commits:
    • 2132a2d feat(v2/frame): add DataFrame.toSheet
    • e25a52a feat(v2/frame): add options to DataFrame.toSheet
    • 8a011f2 feat(v2/flameframe): add FlameFrame.toSheet
    • 6194eb3 docs(v2): add @since tags to toSheet, fromRange, fromSheet
    • a4eb9ec chore: update uv.lock for v0.41.0
    • 2e42bb0 bump: version 0.40.0 → 0.41.0

Known Issues

  • None

Next Steps

  • Consider adding toSheet to FlameFrameErrors for direct error reporting to sheets