How Do I Upload xls sheet Read it and save it into database in Blazor WASM

Question

I saw so many examples about bulk upload from excel sheet into database. But the problem is all videos and tutorials are in Blazor Server. So many ready example also available on youtube.
I want develop this blazor wasm and also have asp.net core web api hosted with it . So how do I implement it ? any example please or tutorial.

Answer 1

for Blazor WASM its a standard file upload (<input file>) to the asp.net core webapi. You should be able to find lots of asp.net core examples.

https://learn.microsoft.com/en-us/aspnet/core/blazor/file-uploads?view=aspnetcore-5.0&pivots=server

if you meant to parse the xls sheet in blazor then you need an excel parser that runs in blazor. find a .netstandard 2.0 library version that supports memory streams to read the excel file. if you can not find one, there are javascript ones you could use.

note: with WASM blazor you need to careful of the file sizes