The defined name "DataRange" will be used to obtain the range to be populated. SpreadsheetGear.IWorkbookSet workbookSet = Create a new "workbook set" object and open the above file stream. System.IO.Stream readStream = fileInfo.CreateReadStream() Open a stream to the template workbook file. Public IActionResult DownloadReportFromTemplate() Public HomeController( hostingEnv)Īdd the following action method to the HomeController class: Use MVC's built-in Dependency Injection to get an instance of this object in the HomeController class by adding the following to the beginning of the class (open from the Explorer pane at /Controllers/HomeController.cs): Opening and processing "Files/ReportTemplate.xlsx" requires accessing the web server's local file system, which can be done with IHostingEnvironment.This can be done by using an "Add Folder" icon near the top of the Explorer pane.ĭownload and save this Excel template file to the "Files" folder created in the previous step. Create a " Files" folder under your Web App's root project folder.NET Standard is now added to your project. Go back to the Terminal pane and enter the following command: Select the "SpreadsheetGearWebApp" folder and click the "Open".Īdd SpreadsheetGear for.and navigate to the folder where you just ran the above command from the Terminal. You should see a couple messages indicating the generation time and success of the command.
A Terminal pane should appear at the bottom of the Visual Studio Code window.Įnter the following command to create a new project from the "ASP.NET MVC Core Web App" template, giving the Project a name of "SpreadsheetGearWebApp": On the View menu, navigate to Integrated Terminal.
VISUAL STUDIO FOR MAC FORMAT CODE INSTALL
If not, please use the following links to install these now: This tutorial assumes you already have both Visual Studio Code and the.
0 kommentar(er)
