Excel File

[Sarah]

Hi,

I want to use the XIslo component in Blazer Web Assembly. I created an Excel file for the invoice. I put this file in wwwroot. When the user requests to download the file, I read the data from the server and put it in the Excel file, and the Excel file is downloaded in the user's browser. There are two problems:

1- When the user opens the file, the image in the Excel file is not displayed

2- The file I mentioned was created for 10 items. If the number of products is more than 10, how can I create a new line after the 10th?

Attachment: Invoice_fad80a76.rar

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Sarah,

Regarding When the user opens the file, the image in the Excel file is not displayed: We are unable to reproduce the reported issue.

Regarding The file I mentioned was created for 10 items. If the number of products is more than 10, how can I create a new line after the 10th?: You requirement of inserting a new row can be achieved through InsertRow method of IRange.

The sample tried at our end along with the code snippet for inserting row, can be downloaded from the below link.

https://www.syncfusion.com/downloads/support/directtrac/general/ze/EditExcel964513841.zip

Kindly share an issue reproducing sample for the image in the Excel file is not displayed, to investigate the query further.

Regards,

Keerthi.

[Sarah]

Hi Konduru Keerthi Konduru Ravichandra Raju,

Thank you for your guidance. The problem was solved. I want to receive an Excel file from the user. In the past, I used the following code and there was no problem. But after upgrading to .NET 7 and upgrading the version of Syncfusion , an error is displayed.

https://easyupload.io/t66dsy

[Konduru Keerthi Konduru Ravichandra Raju]

Hi Sarah,

Kindly confirm in which version of Syncfusion and framework this requirement was working fine. And please let us know what the error is you are facing in the latest version.

Regards,

Keerthi.

[Sarah]

Hi Konduru Keerthi Konduru Ravichandra Raju,

It worked correctly in version 20.2.0.36 and .NET 6.

[Konduru Keerthi Konduru Ravichandra Raju]

Thanks for sharing the requested information, Sarah.

We request you to remove the try-catch and share the complete exception stack trace.

[Sarah]

Hi,

I removed the try catch and I don't get an error, but the execution does not reach the following line:

IWorksheet worksheet = workbook.Worksheets[0];

Is it possible to introduce a sample that uploads an Excel file and displays the contents of the file in the Datagrid?

[Konduru Keerthi Konduru Ravichandra Raju]

Sarah, regarding displaying the Excel content in data grid, please look into the below link.

https://www.syncfusion.com/kb/13131/how-to-import-data-from-excel-sheet-and-bind-to-blazor-grid

Regarding exception, we have created a new support ticket under your account and request you to follow that for further updates.

[Sarah]

Hi  Konduru Keerthi Konduru Ravichandra Raju,

Thank you for your follow up. I had checked this reference that you introduced. This reference works correctly, but it is a Blazer server. Is it possible to introduce a case for Blazer Web Assembly?

[Konduru Keerthi Konduru Ravichandra Raju]

Sarah, we will prepare a Blazor Web Assembly application and will share you on April 19^th, 2023.

[Konduru Keerthi Konduru Ravichandra Raju]

Sarah, we have prepared a sample for you and this can be downloaded from the below link.

https://www.syncfusion.com/downloads/support/directtrac/general/ze/EditExcel-1241534248.zip 

Kindly try and let us know if this helps.  

[Sarah]

Hi  Konduru Keerthi Konduru Ravichandra Raju,

Thank you for the sample. As I explained in the past, the import was OK in .NET 6 and lower versions of Syncfusion, but in .NET 7 and higher versions of Syncfusion, there is an error. Unfortunately, your sample is .NET 6 and a lower version of SyncFusion. Please send a sample for .NET 7 and Syncfusion version 21.1.38 and later.

[Konduru Keerthi Konduru Ravichandra Raju]

Sarah, we have modified the sample for .NET 7.0 and latest version of Syncfusion. This sample can be downloaded from below link.

https://www.syncfusion.com/downloads/support/directtrac/general/ze/EditExcel_70-967348974.zip 

Kindly try and let us know if this helps.