Matterway
    Preparing search index...

    Function sheet

    • Sheet component for displaying spreadsheet data.

      Parameters

      • props: SheetBlockProps

        Configuration object

        • name

          Name of the component

        • base64

          Base64 encoded spreadsheet data. Can be a static string or a function that receives params with data and value, returning a promise of string

        • handsontableLicenseKey

          Optional Handsontable license key

        • nameOrIndex

          Sheet name or index to display. Can be a string, number, or function that receives params with data and value

        • defaultValue

          Default value for the sheet

      Returns Element

      Basic usage

      sheet({
        name: 'spreadsheet',
        base64: 'base64-encoded-excel-data'
      });

      Usage with dynamic data and sheet selection

      sheet({
        name: 'salesData',
        base64: async ({data}) => data.spreadsheetBase64,
        nameOrIndex: 'Q1 Sales',
        handsontableLicenseKey: 'your-license-key'
      });

    Settings