...

1. Open Visual Studio and create a .NET project.
   • The sample code uses a web application.
2. Add a reference to SoftArtisans.OfficeWriter.ExcelWriter.dll
   • SoftArtisans.OfficeWriter.ExcelWriter.dll is located under Program Files > SoftArtisans > OfficeWriter > dotnet > bin

Writing the Code

The code for this report uses two functions- the Main function and the BindCountryData functions. The Main function calls the BindCountryData function taking each country's worksheet as a parameter. See below for further explanation.

1. Include the SoftArtisans.OfficeWriter.ExcelWriter namespace in the code behind

...

xlt.Open(xla, wb);

10. The use of function in an ExcelWriter code file is sometimes the most efficient way to approach a situation. In this case, a separate function is created to bind the data. This function is called in a for loop that is contained with the other code. Let the function that deals with data binding be called BindCountryData() and takes a worksheets name's as a string parameter.

            
for (int i = 0; i < wb.Worksheets.Count; i++)
{
     BindCountryData(wb.Worksheets[i].Name);
}

11. Call ExcelTemplate.Process() to import all data into the file.

xlt.Process();

12. Call ExcelTemplate.Save to save the output file.

ExcelTemplate has several output options: save to disk, save to a stream, stream the output file in a page's Response inline or as an attachment.

xlt.Save(Page.Response, "output.xlsx", false);