Hey man, I have watch this video today and i really enjoy it and it was very helpful. I want to know if there is a way to send all the data from Excel(table) to SQL server after we load them in table? (without using entity framework) Thanks
Thanks for your comment. Sort is easy as using Linq method on DataTable desired column. To add pagination, a bit of more work is required to: - Get all row count e.g. 100 - fetch rows based on page number and row count in each page e.g. (PageNum * RowCountInPage) + 1 is the index of start row to fetch relevant rows for each page
![Blazor : Generate and Download Excel File [Microsoft Excel Report]](http://i.ytimg.com/vi/ALH7X0nZBkg/mqdefault.jpg)
![Blazor : Generate and Download Excel File [Microsoft Excel Report]](/img/tr.png)
I've been looking for a tuto like this for days now. First one that do what I needed. Thank you Sir.
Excellent
Thank you Sir
Good job. Thanks. Continuo your content
Bro, thanks so much from Colombia. Excellent video. You have helped me a lot. :)
Glad it helped!
thanks, can you make one for avalonia (reading xlxs not working in web)
Is there any form of getting some cells of the excel file?
Hey man, I have watch this video today and i really enjoy it and it was very helpful. I want to know if there is a way to send all the data from Excel(table) to SQL server after we load them in table? (without using entity framework)
Thanks
Good tutorial
Thanks
From turkey, Thanx
Is it the same on blazor server page? or could you recommend a source to get that information please?
No, It is a bit different. Lots of tutorial in RUclips and Google for it.
Great tutorial, please help how can you add a pager and sort functions on this method
Thanks for your comment. Sort is easy as using Linq method on DataTable desired column. To add pagination, a bit of more work is required to:
- Get all row count e.g. 100
- fetch rows based on page number and row count in each page e.g. (PageNum * RowCountInPage) + 1 is the index of start row to fetch relevant rows for each page
Thank you so much
Gracias.
Great tutorial , please help me on how to edit the imported file .
As far as I know, no way to change the imported file and write it back. So, I would recommend to create a new file or overwrite the existing one.
Is it free for commertial use?
If you are asking about Postman, it has a free tier.
I