...
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
Anchor | ||||
---|---|---|---|---|
|
All 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.
...
Note |
---|
If you are compiling against .NET 4.0, make sure to use the full profile. The default profile does not include |
Anchor | ||||
---|---|---|---|---|
|
There are two ways to do this:
...
- 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. |
Anchor | ||||
---|---|---|---|---|
|
On 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
|
...