Excel Export Intercept

Question

Hello

Is it possible to intercept the export of a pivot table (Excel Export) and then turn this into a XLSIO Workbook for further manipulation in code?

I know I can change the styling, format, name etc. but I need to actually capture the workbook itself so that I can mess with it in code myself.

Is this possible?

Thanks

Sastha Prathap Selvamoorthy · Answer

Hi Richard,  
  
We are analyzing the reported problem at our end. We will update further details within two business days (September 14, 2021).  
  
Regards,  
Sastha Prathap S

Manikandan Murugesan · Answer

Hi Richard, 

We have prepared a sample to export pivot table at sample level. Please refer to the following sample. 
Sample: https://www.syncfusion.com/downloads/support/forum/168732/ze/SYNCFU~1-339288797 

Kindly refer to the following UG document to know more about the excel exporting. 
Document: https://help.syncfusion.com/file-formats/xlsio/create-read-edit-excel-files-in-blazor-c-sharp 

Please let us know if you have any concerns. 
 
Regards, 
Manikandan

Ditchford · Answer

Hello

Thank you. There was obviously a lot of work that went into that, so much appreciated. Couple of questions

I have never heard of Syncfusion.ExcelExport before. Is there any doco about why you would use instead of Syncfusion.XLSio?

Is there a way to convert a Syncfusion.ExcelExport workbook to a Syncfusion.XLSio workbook?

Thanks

Syncfusion.ExcelExport workbook to a

Syncfusion.XLSio workbook?Thanks

Manikandan Murugesan · Answer

Hi Richard, 
 
Please find the response below. 
 




Query 

Comments 


I have never heard of Syncfusion.ExcelExport before.  Is there any doco about why you would use instead of Syncfusion.XLSio? 

You can use both “Syncfusion.ExcelExport” and “Syncfusion.XlsIO” for excel exporting in blazor. 
 
Kindly refer the following document the know more details about the excel exporting using “Syncfusion.XlsIO” library. Based on that, you can create and export the pivot table to excel document. 
 
Document: https://help.syncfusion.com/file-formats/xlsio/create-read-edit-excel-files-in-blazor-c-sharp 
 


Is there a way to convert a Syncfusion.ExcelExport workbook to a  Syncfusion.XLSio workbook? 

No. You cannot convert a “Syncfusion.ExcelExport” workbook to “Syncfusion.XlsIO” workbook. 
 
Please let us know if you have any concerns. 
 
Regards, 
Manikandan

Query	Comments
I have never heard of Syncfusion.ExcelExport before. Is there any doco about why you would use instead of Syncfusion.XLSio?	You can use both “Syncfusion.ExcelExport” and “Syncfusion.XlsIO” for excel exporting in blazor. Kindly refer the following document the know more details about the excel exporting using “Syncfusion.XlsIO” library. Based on that, you can create and export the pivot table to excel document. Document: https://help.syncfusion.com/file-formats/xlsio/create-read-edit-excel-files-in-blazor-c-sharp
Is there a way to convert a Syncfusion.ExcelExport workbook to a Syncfusion.XLSio workbook?	No. You cannot convert a “Syncfusion.ExcelExport” workbook to “Syncfusion.XlsIO” workbook.