|
Syncfusion Excel (XlsIO) library is a .NET Excel library used to create, read, and edit Excel documents. Using this library, you can convert Excel to PDF in Azure platform. Steps to convert Excel to PDF in Azure programmatically:Prerequisites:
Step 1: Create a new ASP.NET Web application project and add Excel to PDF conversion code snippet in it
Create a new ASP.NET web application 1. Install Syncfusion.ExcelToPdfConverter.Base NuGet package as a reference to your .NET Framework applications from the NuGet.org.
Install NuGet package 2. Add a new Web Form in ASP .NET project. Right click on the project and select Add > New Item and add a Web Form from the list. Name it as MainPage. 3. Add a new button in the MainPage.aspx as shown below. CSHTML <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <body> <form id="form1" runat="server"> <div> <asp:Button ID="Button1" runat="server" Text="Create Document" OnClick="OnButtonClicked" /> </div> </form> </body> </html>
4. Include the following namespace in your MainPage.aspx.cs file. C# using Syncfusion.XlsIO; using Syncfusion.Pdf; using Syncfusion.ExcelToPdfConverter;
VB.NET Imports Syncfusion.XlsIO Imports Syncfusion.Pdf Imports Syncfusion.ExcelToPdfConverter
5. Include the below code snippet in the click event of the button in MainPage.aspx.cs, to create an Excel file and download it. C# //Create an instance of ExcelEngine
using (ExcelEngine excelEngine = new ExcelEngine())
{
//Set the default application version as Excel 2016
excelEngine.Excel.DefaultVersion = ExcelVersion.Excel2016;
//Create a workbook with a worksheet
IWorkbook workbook = excelEngine.Excel.Workbooks.Open(filePath);
//Convert the workbook into PDF
ExcelToPdfConverter converter = new ExcelToPdfConverter(workbook);
PdfDocument pdf = converter.Convert();
//Saves the pdf document
pdf.Save("WordtoPDF.pdf", Response, HttpReadType.Save);
}
VB.NET 'Create an instance of ExcelEngine
Using excelEngine As ExcelEngine = New ExcelEngine
'Set the default application version as Excel 2016
excelEngine.Excel.DefaultVersion = ExcelVersion.Excel2016
'Create a workbook with a worksheet
Dim workbook As IWorkbook = excelEngine.Excel.Workbooks.Open(filePath)
'Convert the workbook into PDF
Dim converter As ExcelToPdfConverter = New ExcelToPdfConverter(workbook)
Dim pdf As PdfDocument = converter.Convert()
'Save the pdf document
pdf.Save("WordtoPDF.pdf", Response, HttpReadType.Save)
End Using
Step 2: Publish the Application to AzureIn the Solution Explorer, right-click on the project name and select Publish.
Publish via Solution Explorer Or we can go to Build Menu and select Publish myASPApp (your_project_name) to open Publish page.
Publish via Build Menu Now select the Microsoft Azure App Service, make sure Create New option is selected and then select Publish.
Publish via Microsoft Azure App Service This opens a Create App Service dialog, where we can add all the necessary resources required to run the application in Azure. Step 3: Sign in to Azure accountIn the Create App Service dialog, select Add an account, and sign in to the Azure subscription. If you're already signed in, select the account containing the desired subscription from the dropdown.
Create App Service Step 4: Create a resource groupA resource group is a logical container into which Azure resources like web apps, databases, and storage accounts are deployed and managed. Next to Resource Group, select New. Provide a name for the Resource Group and select OK.
Create a resource group Step 5: Create an App Service planAn App Service plan specifies the location, size, and features of the web server farm that hosts your app. Next to App Service Plan, select New. In the Configure App Service Plan dialog, update the details as per the requirements and Select.
Create and configure an App Service Plan Step 6: Create and publish the web appIn Web App Name, type a unique app name or accept the automatically generated unique name. The URL of the web app is http://<app_name>.azurewebsites.net, where <app_name> is your web app name. Select Create to start creating the Azure resources.
Create Azure resources Now the application is being deployed to Azure.
Deploying to Azure Once the deployment completes, it publishes the ASP.NET web application to Azure, and then launches the app in the default browser. Please make use of the below sample to convert Excel to PDF in Azure platform. Sample link:http://www.syncfusion.com/downloads/support/directtrac/general/ze/SampleAspWebApp1716085819.zip |
2X faster development
The ultimate ASP.NET Web Forms UI toolkit to boost your development speed.
This page will automatically be redirected to the sign-in page in 10 seconds.
You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.
