Exporting large of amounts of data requires special handling by the web application so the user knows the excel export process is working.  With kendo-excelexport component, calling the save() function is where all the work is done and it doesn't return until the Excel file is complete due to it being synchronous.  There should be some way for the application to subscribe to progress events during the construction of the excel export process so the application can inform the user of this progress.

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.

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

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.

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...