Unplanned
Last Updated: 25 Sep 2023 10:05 by Varun
Created by: Varun
Comments: 0
Category: ExcelExport
Type: Feature Request
11
It would be nice if the exported Excel document supports images.
Declined
Last Updated: 04 May 2023 06:18 by ADMIN
Created by: Christophe
Comments: 1
Category: ExcelExport
Type: Feature Request
1
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...
Unplanned
Last Updated: 16 Nov 2022 22:16 by Scott

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.

Unplanned
Last Updated: 29 Sep 2022 14:43 by Anoop

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.

Unplanned
Last Updated: 14 Jun 2022 13:50 by Brian
Created by: Brian
Comments: 0
Category: ExcelExport
Type: Feature Request
3

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.

Unplanned
Last Updated: 30 Jul 2021 08:30 by ADMIN
Created by: IS Kendo Support
Comments: 0
Category: ExcelExport
Type: Feature Request
2

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

Completed
Last Updated: 14 Jun 2021 09:00 by ADMIN

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