In this article I will explain with an example, how to download
Excel file from URL in ASP.Net Core (.Net Core) Razor Pages.
The
Excel file will be downloaded from the URL using
WebClient class and then will be saved in a Folder (Directory).
Excel File URL
The following
Excel file will be used in this article.
Namespaces
You will need to import the following namespace.
Razor PageModel (Code-Behind)
The PageModel consists of following Handler method.
Handler method for handling GET operation
Inside this Handler method, the
Excel file is downloaded from the URL using
DownloadFile method of the
WebClient class.
DownloadFile method
It accepts the following two parameters:
address – The URL of the file to be downloaded.
fileName – Path of the Folder (Directory) where the file will be downloaded.
public class IndexModel : PageModel
{
public void OnGet ()
{
ServicePointManager.Expect100Continue = true;
ServicePointManager.SecurityProtocol = (SecurityProtocolType)3072;
WebClient webClient = new WebClient();
webClient.DownloadFile("https://raw.githubusercontent.com/aspsnippets/test/master/Sample.xlsx", @"D:\Files\Customers.xlsx" );
}
}
Razor Page (HTML)
HTML Markup
There is no coding part in Razor Page. Hence, it is skipped.
@page
@model Download_Excel_URL_Core_Razor.IndexModel
@{
Layout = null;
}
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width" />
<title>Index</title>
</head>
<body>
</body>
</html>
Screenshot
The downloaded Excel file
Downloads