Powered by Blogger.

Sunday, February 16, 2014

Opening one Excel template in Asp.net




Here in this article, we will discuss how to open one Exceltemplate in Asp.net.

You can also check my previous posts on:

Difference between web application and web site in Asp.Net

Permanently Redirect a Page in Asp.Net

Create and use User Control in Asp.Net

We have a requirement in our project that we have a link named as "ExcelTemplates",If you click this link one exceltemplate will open.

Under our project solution, we have a folder named as "TestDataTemplateExcel",which contains the excel template named as "TestTemplate.xlsx".

So what we did is we added a button in the .aspx page and in the .aspx.cs file in the button click event we called the below method.

private void GetTemplate()
        {
            //Get the application Path including the last \ and and truncate update to application root               //folder.
            string executablePath1 = Environment.CommandLine.Substring(1,                 Environment.CommandLine.IndexOf("\\bin"));

            // Append the Excel template folder file path from root folder onwards.
            executablePath1 = executablePath1 + "TestDataTemplateExcel\\TestTemplate.xlsx";
            System.Diagnostics.Process.Start(executablePath1);
        }

Description:
string executablePath1 = Environment.CommandLine.Substring(1, Environment.CommandLine.IndexOf("\\bin"));

The above line of code will get the application Path including the last \ and and truncate update to application root folder.

executablePath1 = executablePath1 + "TestDataTemplateExcel\\TestTemplate.xlsx";

This line of code will append the Excel template folder file path from root folder onwards.

System.Diagnostics.Process.Start(executablePath1);

System.Diagnostics.Process.Start will process and start the respective excel from the specified path.



0 comments

Post a Comment