ASP.NET Core Blazor Excel Import

Question

question

Cenk-1028 asked Jun 20, '22 AgaveJoe commented Jun 21, '22

ASP.NET Core Blazor Excel Import

Hello,

I am new to ASP.NET core blazor. I would like to know if there are some tutorials about importing excel data into SQL database. The user selects the excel file from file explorer then uploads it and saved data into the database is displayed on the view.

Thanks in advance.

dotnet-aspnet-core-blazor

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-06-21T02:36:50.153Z

BrandoZhang-MSFT answered Jun 21, '22 BrandoZhang-MSFT edited Jun 21, '22

According to your description, I suggest you could use System.Data.OleDb and System.Data.SqlClient package to achieve your requirement inside the blazor server app.

You could firstly save the uploaded excel inside the server and then use olddb to read it and insert it into the sql database.

More details, you could refer to below codes:

Connection string:

   "ConnectionStrings": {
     "constr": "Server=(localdb)\\mssqllocaldb;Database=xxxxxxxxxx;Trusted_Connection=True;MultipleActiveResultSets=true",
     "ExcelConString": "Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 8.0;HDR=YES'"
   }

Razor codes(Please refer to below extension):

213069-pagecodes.txt

Result:

pagecodes.txt (4.2 KiB)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2022-06-21T05:30:46.44Z

Cenk-1028 answered Jun 21, '22 AgaveJoe commented Jun 21, '22

Hi @BrandoZhang-MSFT ,

Thanks for your reply. I wonder after saving to the DB can I navigate to the list page?

Something like this;

 private async Task OnValidSubmit()
     {
         if (this.inventory != null)
         {
             NavigationManager.NavigateTo("/inventories");
         }
                
     }

· 3

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BrandoZhang-MSFT · Jun 21 at 09:31 AM

Sure you could redirect to it.

0 ·

Cenk-1028 BrandoZhang-MSFT · Jun 21 at 10:55 AM

One last thing, can I use EPPlus non-commercial version? Do you know about this?

0 ·

AgaveJoe Cenk-1028 · Jun 21 at 12:21 PM

There is nothing stopping you from using EPPlus non-commercial version. I recommend reading the EPPlus documentation and writing sample code to figure out if EPPlus fits your expectations.

0 ·

question