...
- Open Visual Studio and create a .NET project.
- The sample code uses a web application.
- 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
...
Code Block |
---|
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.
Code Block |
---|
for (int i = 0; i < wb.Worksheets.Count; i++)
{
BindCountryData(wb.Worksheets[i].Name);
}
|
Info |
---|
We will return to this function after completing the main code. |
11. Call ExcelTemplate.Process() to import all data into the file.
Code Block |
---|
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.
Code Block |
---|
xlt.Save(Page.Response, "output.xlsx", false); |