Support Knowledge Base, Article 1225

In ExcelWriter versions prior to 6.6.1, setting conditional formatting with the API does not work properly with .NET 2.0. The functionality works correctly with .NET 1.1 and 1.0. If your virtual application is set to run on .NET 2.0, calling the SetConditionalFormat() method will generate a corrupt file which can not be opened in Excel.

Here is an example of code which can cause Microsoft Excel to fail:

ExcelApplication xla = new ExcelApplication();

Workbook wb = xla.Create();

Worksheet ws = wb.Worksheets.CreateWorksheet("SampleSheet");

/* we create the area to which our sample conditional format
   will apply */

Area sampleArea = ws.CreateArea(1,1,0,0);

ConditionalFormat sampleFormat = wb.CreateConditionalFormat();

Condition sampleCondition = sampleFormat.
CreateCondition(Condition.Comparison.CellValueLessThan,”100”); 
                
sampleArea.SetConditionalFormat(sampleFormat);

After running this code, Microsoft Excel is not able to open the output file and may generate the following error:

• If possible, upgrade to ExcelWriter version 6.6.1,which is included in OfficeWriter version 3.6.1
• If not, change your ExcelWriter application virtual directory configuration to run on .NET 1.1

1. Open your IIS,right-click on the corresponding ExcelWriter application virtual directory and select "Properties"
2. Click on "Configuration" to get to the Application Mappings panel
3. Select the ".aspx" extension and click on "Edit"
4. Click on "Browse" and go to "v1.1.4322" folder under the "Framework" sub-directory



5. Select the "aspnet_isapi.dll" file and then click OK