Similar to the following feature request logged in Kendo UI for jQuery - Add ability to sanitize exported data in Excel spreadsheet to prevent formula-injection

So far cell values starting with '=', are executable in the Excel file:

https://stackblitz.com/edit/angular-v3pp4n-vspiss

There is a way to prevent that by manually customizing the generated workbook and adding a single quote prefix to the cell value.

cell.value = "'=Executable-Formula";

However, this will change the initial value of the cell.

Provide a way to prevent the formula injection and persist the value in the cell.

Hi

Can you include the type property on the interface WorkbookSheetRow?

Reasoning: it is useful to filter out rows based on their type and having this available just makes life easier.

https://www.telerik.com/kendo-angular-ui/components/excelexport/api/WorkbookSheetRow/

Code snippet below.

/**
 * The sheets rows configuration.
 */
export interface WorkbookSheetRow {
    /**
     * The cells of the every row. Each cell represents a cell from the final Excel document.
     */
    cells?: WorkbookSheetRowCell[];

    /**
     * The zero-based index of the row in the sheet. Defaults to the index of the object in the array.
     */
    index?: number;

    /**
     * The row height in pixels.
     */
    height?: number;
    /**
     *The type of row as string
     */
     type?:string;

}

Thanks

Lynden

Please provide Page Setup options for the Excel Export similar to the options provided by the WorksheetPageSetup Properties.

I should be so usefull to have something like that :

<kendo-excelexport fileName="Reporting.xlsx" #excelexport>

  <kendo-excelexport-sheet  sheetName="Products">

    <kendo-excelexport-grid [data]="products">

        <kendo-excelexport-column field="ProductID" title="Product ID"></kendo-excelexport-column>

        <kendo-excelexport-column field="ProductName" title="Product Name"></kendo-excelexport-column>

    </kendo-excelexport-grid>

  </kendo-excelexport-sheet>

<kendo-excelexport-sheet  sheetName="Stock">

    <kendo-excelexport-grid [data]="stockFromWarehouseOne">

        <kendo-excelexport-column field="ProductID" title="Product ID"></kendo-excelexport-column>

        <kendo-excelexport-column field="ProductName" title="Product Name"></kendo-excelexport-column>

        <kendo-excelexport-column field="Qt" title="Qt"></kendo-excelexport-column>

    </kendo-excelexport-grid>

    <kendo-excelexport-row></kendo-excelexport-row>


    <kendo-excelexport-grid [data]="stockFromWarehouseTwo">

        <kendo-excelexport-column field="ProductID" title="Product ID"></kendo-excelexport-column>

        <kendo-excelexport-column field="ProductName" title="Product Name"></kendo-excelexport-column>

        <kendo-excelexport-column field="Qt" title="Qt"></kendo-excelexport-column>

    </kendo-excelexport-grid>

  </kendo-excelexport-sheet>

</kendo-excelexport>

One export, two sheets, on first sheet we have one grid, on second sheet we have two grids splitted by a blank row...

Hi, 

It will be a good addition to both ExcelExport and Grid Excel Export modules to have an option to define a hyperlink cell that will be recognized by Excel.

Currently, this can happen by adding a formula but would be great to have a separate option for developers.

Thank you for your consideration.

Hi Kendo Angular,

It will be a good enhancement to the component if there is an option to set the default font of the exported Excel file as currently it is set to Calibri 11.

Thank you for your consideration.

It will be a good option to have if there is a setting to set to true and enable the autofit row height option from Excel.

Hi All,

We have a requirement to include logo of our company in exported excel files, so as a solution we thought of using IMAGE excel function, however when I used this function and tried to export excel file then I see error in the cell "#NAME?" and when I edit the cell formula with no changes and hit enter then I can see the image appearing inside cell.

IMAGE function

after I edit the cell formula with no change and hit enter then image appears.

Have anyone faced this issue, or have anyone tried any other solution to include images in exported excel file ? if yes, then your help will of great help to me.

Thank you.