# spreadsheet-editor-cell-template

> Spreadsheet editor with cell template feature using interview registration form scenario with input components.

**Framework:** vue  **Component:** SpreadsheetEditor  **Variant:** cell-template

## Get this item

**If you are an agent, fetch the JSON.** Source is inlined, so one request is enough and no tooling is required:

```
GET https://ai.syncfusion.com/r/vue/spreadsheet-editor-cell-template.json
```

**Install Package(s)**

```bash
npm install @syncfusion/ej2-vue-spreadsheet @syncfusion/ej2-vue-dropdowns @syncfusion/ej2-vue-buttons @syncfusion/ej2-vue-inputs
```

**Notes**

- Syncfusion release: 2026 Volume 3 (v35.1.37)
- The Syncfusion package is licensed. The composition in this file is source you own and edit. See https://ai.syncfusion.com/licensing.md

## Source files

### src/components/spreadsheet-editor-cell-template/SpreadSheetEditor.vue

```vue
<template>
  <div class="control-section">
    <div id="spreadsheet-cell-template">
      <ejs-spreadsheet ref="spreadsheet" :showRibbon="false" :enableContextMenu="false" :allowResizing="false" :allowPrint="false" :showFormulaBar="false" cssClass="e-custom-spreadsheet" :allowOpen="false" :allowSave="false" :scrollSettings="scrollSettings" :created="created" :allowEditing="false" :selectionSettings="selectionSettings">
        <e-sheets>
          <e-sheet name="Registration Form" :rowCount="40" :colCount="30" :showGridLines="false">
            <e-ranges>
              <e-range :template="'nameTextbox'" address="C2">
                <template v-slot:nameTextbox>
                  <div>
                    <ejs-textbox placeholder="Name"></ejs-textbox>
                  </div>
              </template>
              </e-range>
              <e-range :template="'dobTextbox'" address="C3">
                <template v-slot:dobTextbox>
                  <div>
                    <ejs-textbox placeholder="DOB"></ejs-textbox>
                  </div>
                </template>
              </e-range>
              <e-range :template="'genderRadiobutton'" address="C4">
                <template v-slot:genderRadiobutton>
                  <div style="padding-left: 2px">
                    <ejs-radiobutton name="gender" value="male" label="Male"></ejs-radiobutton>
                    <ejs-radiobutton name="gender" value="female" label="Female" cssClass="margin"></ejs-radiobutton>
                  </div>
                </template>
              </e-range>
              <e-range :template="'dropdownlist'" address="C5">
                <template v-slot:dropdownlist>
                  <div>
                    <ejs-dropdownlist placeholder="Experience" :dataSource="experience"></ejs-dropdownlist>
                  </div>
                </template>
              </e-range>
              <e-range :template="'multiselect'" address="C6">
                <template v-slot:multiselect>
                  <div>
                    <ejs-multiselect :showClearButton="false" placeholder="Areas of Interest" :dataSource="languages"></ejs-multiselect>
                  </div>
                </template>
              </e-range>
              <e-range :template="'mobileTextbox'" address="C7">
                <template v-slot:mobileTextbox>
                  <div>
                    <ejs-textbox placeholder="Mobile Number"></ejs-textbox>
                  </div>
                </template>
              </e-range>
              <e-range :template="'emailTextbox'" address="C8">
                <template v-slot:emailTextbox>
                  <div>
                    <ejs-textbox placeholder="Email"></ejs-textbox>
                  </div>
                </template>
              </e-range>
              <e-range :template="'addressTextbox'" address="C9">
                <template v-slot:addressTextbox>
                  <div>
                    <ejs-textbox placeholder="Address" rows="2" :multiline="true"></ejs-textbox>
                  </div>
                </template>
              </e-range>
              <e-range :template="'addButton'" address="C11">
                <template v-slot:addButton>
                  <div>
                    <ejs-button cssClass="e-flat" v-bind:style="{float: 'right'}" content="Add"></ejs-button>
                  </div>
                </template>
              </e-range>
            </e-ranges>
            <e-rows>
              <e-row :height="55">
                        <e-cells>
                            <e-cell index=1 value="Interview Registration Form"></e-cell>
                        </e-cells>
                    </e-row>
                    <e-row :height="55">
                        <e-cells>
                            <e-cell index=1 value="Name"></e-cell>
                        </e-cells>
                    </e-row>
                    <e-row :height='45'>
                        <e-cells>
                            <e-cell index=1 value="Date of Birth:"></e-cell>
                        </e-cells>
                    </e-row>
                    <e-row :height='45'>
                        <e-cells>
                            <e-cell index=1 value="Gender:"></e-cell>
                        </e-cells>
                    </e-row>
                    <e-row :height='45'>
                        <e-cells>
                            <e-cell index=1 value="Year of Experience:"></e-cell>
                        </e-cells>
                    </e-row>
                    <e-row :height='45'>
                        <e-cells>
                            <e-cell index=1 value="Areas of Interest:"></e-cell>
                        </e-cells>
                    </e-row>
                    <e-row :height='45'>
                        <e-cells>
                            <e-cell index=1 value="Mobile Number:"></e-cell>
                        </e-cells>
                    </e-row>
                    <e-row :height='45'>
                        <e-cells>
                            <e-cell index=1 value="Email:"></e-cell>
                        </e-cells>
                    </e-row>
                    <e-row :height='82'>
                        <e-cells>
                            <e-cell index=1 value="Address:"></e-cell>
                        </e-cells>
                    </e-row>
            </e-rows>
            <e-columns>
                    <e-column index=1 :width="190"></e-column>
                    <e-column :width="350"></e-column>
                </e-columns>
          </e-sheet>
        </e-sheets>
      </ejs-spreadsheet>
    </div>
  </div>
</template>
<script>
import { SpreadsheetComponent, SheetsDirective, SheetDirective, ColumnsDirective, RowsDirective, RowDirective, CellsDirective, RangesDirective, RangeDirective, CellDirective, ColumnDirective } from "@syncfusion/ej2-vue-spreadsheet";
import { ButtonComponent, RadioButtonComponent } from '@syncfusion/ej2-vue-buttons';
import { TextBoxComponent } from '@syncfusion/ej2-vue-inputs';
import { DropDownListComponent, MultiSelectComponent } from '@syncfusion/ej2-vue-dropdowns';

export default {
   components: {
    'ejs-spreadsheet': SpreadsheetComponent,
    'e-sheet': SheetDirective,
    'e-sheets': SheetsDirective,
    'e-column': ColumnDirective,
    'e-columns': ColumnsDirective,
    'e-row': RowDirective,
    'e-rows': RowsDirective,
    'e-cell': CellDirective,
    'e-cells': CellsDirective,
    'e-range': RangeDirective,
    'e-ranges': RangesDirective,
    'ejs-button': ButtonComponent,
    'ejs-radiobutton': RadioButtonComponent,
    'ejs-textbox': TextBoxComponent,
    'ejs-dropdownlist': DropDownListComponent,
    'ejs-multiselect': MultiSelectComponent
   },
   data: () => {
    return {
      scrollSettings: { isFinite: true },
      selectionSettings: { mode: 'None' },
      experience: ['0 - 1 year', '1 - 3 years', '3 - 5 years', '5 - 10 years'],
      languages: ['JAVA', 'C#', 'SQL']
    }
  },
  methods: {
    created: function() {
      var spreadsheet = this.$refs.spreadsheet;
      // Applies format to specified range
      spreadsheet.cellFormat({ fontWeight: 'bold' }, 'B2:B9');
      spreadsheet.cellFormat({ fontSize: '12pt', fontWeight: 'bold', textAlign: 'center', verticalAlign: 'middle', textDecoration: 'underline' }, 'B1');
      // Merges B1 and C1 cells
      spreadsheet.merge('B1:C1');
      spreadsheet.cellFormat({ verticalAlign: 'middle' }, 'B2:C9');
    }
  }
}
</script>
```
