Making OfficeWriter available to your applications
Once you've installed OfficeWriter, the next step is There are several steps to make OfficeWriter available to your .NET applications:
- Install OfficeWriter
- Include System.
...
- Web
- Add references to OfficeWriter
- Include OfficeWriter in your code
Add a reference to System.WebAll of the OfficeWriter API objects (ExcelTemplate
, ExcelApplication
, WordTemplate
, WordApplication
) have the output options for saving to disk, saving to memory stream, streaming to user in a page response. The last output option, streaming to the user, has a dependency on System.Web
. If you are developing a web application, the reference to System.Web
should have been added automatically. For other types of applications, you may need to add this reference.
If you are using Visual Studio .NET:
- Right-click the project name in the Solution Explorer and choose Add Reference.
- Click System and locate System.Web
Note |
---|
If you are compiling against .NET 4.0, make sure to use the full profile. The default profile does not include System.Web . |
Add a reference to OfficeWriterThere are two ways to do this:
- Make OfficeWriter available to a single application
- Make OfficeWriter available for all applications on machine
...
- Open a command prompt window and move to the directory OfficeWriter\bin\dotnet20\. #
- Enter gacutil /i SoftArtisans.OfficeWriter.ExcelWriter.dll.
- # Open the file machine.config (in [Windows directory]\Microsoft.NET\Framework[.NET version directory]\CONFIG).
...
Add the following line to the assemblies node of machine.config:
Code Block |
---|
|
<add assembly="Softartisans.OfficeWriter.ExcelWriter,
Version=x.x.x.x, Culture=neutral, PublicKeyToken=f593502af6ee46ae"/> |
...
Create a text file containing the following lines, and save it as web.config. Save web.config at the top level of your application.
Code Block |
---|
|
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<system.web>
<compilation>
<compilers>
</compilers>
<assemblies>
<add assembly="Softartisans.OfficeWriter.ExcelWriter,
Version=x.x.x.x,
Culture=neutral,
PublicKeyToken=f593502af6ee46ae"/>
<add assembly="*" />
</assemblies>
</compilation>
</system.web>
</configuration>
|
Note |
---|
|
The version attribute of the add assembly node must correspond exactly to the version of Softartisans.OfficeWriter.<Excel/Word>Writer.dll added to the GAC. If you add a new version of Softartisans.OfficeWriter.<Excel/Word>Writer.dll to the GAC using the gacutil command, update the dll version attributes in machine.config. To get the exact version of Softartisans.OfficeWriter.<Excel/Word>Writer.dll, right-click the file and select the Properties tab. |
Include OfficeWriter in your codeOn any page that uses OfficeWriter, make sure to add the appropriate using
statements:
Code Block |
---|
using SoftArtisans.OfficeWriter.ExcelWriter; //For ExcelWriter
using SoftArtisans.OfficeWriter.WordWriter; //For WordWriter
|
As mentioned above, you will also need to make sure that System.Web
is included in your project.