Message-ID: <1000075972.10499.1711726602674.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_10498_2011592499.1711726602674" ------=_Part_10498_2011592499.1711726602674 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Upgrading from ExcelWriter 6.x

Upgrading from ExcelWriter 6.x

Though ExcelWriter 7.x and higher are for the most part backward= s compatible with applications written for ExcelWriter Version 6, there are= a number of changes which must be considered when upgrading from Version 6= to Version 7.

=20
=20 =20 =20 =20 =20 =20 =20

Table of Contents

=20 =20
=20

Installation

=20

To upgrade ExcelWriter 6 to ExcelWriter 7 or 8, you should first uninsta= ll OfficeWriter 3 (which contains Excelwriter 6).

=20

Unlike OfficeWriter v3, there are no .NET 1.0 DLLs available for OfficeW= riter v4. Before running the OfficeWriter Version 4 installer, you must mak= e sure that you have the .NET runtime 2.0 or higher installed on your serve= r. However, OfficeWriter v4 no longer requires the J# redistributable, so y= ou will not need to install or upgrade J# to install OfficeWriter v4.

= =20

To install OfficeWriter v4, follow the installation instructions found i= n the Installation documentation. Re= member to use an OfficeWriter v4 or ExcelWriter v7 license key, as OfficeWr= iter license keys are version-specific and an OfficeWriter v3/ExcelWriter v= 6 license key will not register correctly with OfficeWriter v4/ExcelWriter = v7.

=20

Changes

=20

A number of minor changes were made to ExcelWriter properties, methods, = and enumerations in the shift from J# source code to pure C#.

=20

Methods

=20

The following is a list of methods that have been changed to properties = in SoftArtisans ExcelWriter v7. If you use any of these methods in your app= lication, you will need to replace them with the appropriate property call.=

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

ExcelWriter v6 Method

ExcelWriter v7 Property

ChartType.getCategory()

ChartType= .Category

ChartType.getName()

ChartType= .Name

ChartType.is3D()

ChartType= .Is3D

Worksheet.IsSelected()

Worksheet= .IsSelected

=20

Enumerations

=20

The following is a list of enumerations for which the getValue method ha= s been replaced with a Value property in ExcelWriter v7. If you used the ge= tValue method of any of these enumerations in your application, you will ne= ed to replace them with the appropriate property call.

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 = =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 = =20 =20 =20 =20 = =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

ExcelWriter v6 Method

ExcelWriter v7 Property

Axis.TickLabelPos.getValue()

Axis.TickLabelPos.Value

Axis.TickType.getValue()

Axis.TickType.Value

AxisLabel.LabelPosition.getValue()

AxisLabel.LabelPosition.Value

Axis.Type.getValue()

Axis.Type.Value

Border.LineStyle.getValue()

Border.LineStyle.Value

Border.Part.getValue()

Border.Part.Value

CategoryAxis.AxisDisplayType.getValue()

=

CategoryAxis.AxisDisplayType.Value

CategoryAxis.AxisTimeUnit.getValue()

=20

CategoryAxis.AxisTimeUnit.Value

Cell.CellValueType.getValue()

Cell.CellValueType.Value

Chart.ChartLocation.getValue()

Chart.ChartLocation.Value

ChartLine.LineStyle.getValue()

ChartLine.LineStyle.Value

ChartLine.LineWeight.getValue()

ChartLine.LineWeight.Value

ChartPageSetup.PrintedChartSize.getValue() <= /p>

ChartPageSetup.PrintedChartSize.Value

=20

ChartRegion.HorizontalAlignment.getValue() <= /p>

ChartRegion.HorizontalAlignment.Value

=20

ChartRegion.VerticalAlignment.getValue()

ChartRegion.VerticalAlignment.Value

=20

ChartType.ChartCategory.getValue()

ChartType.ChartCategory.Value

Condition.Comparison.getValue()

Condition.Comparison.Value

CopyPasteProperties.CopyPasteType.getValue()=

CopyPasteProperties.CopyPasteType.Value

=

DataPointMarker.ShapeType.getValue()

=20

DataPointMarker.ShapeType.Value

DataValidation.ComparisonType.getValue()

DataValidation.ComparisonType.Value

=20

DataValidation
.ErrorAlertStyleType.ge= tValue()

DataValidation
.ErrorAlertStyleType.Va= lue

DataValidation.ValidationType.getValue()

DataValidation.ValidationType.Value

=20

DocumentProperties.BuiltIn.getValue()

=20

DocumentProperties.BuiltIn.Value

ErrorBar.BarDirection.getValue()

ErrorBar.BarDirection.Value

ErrorBar.ErrorValueType.getValue()

ErrorBar.ErrorValueType.Value

Font.UnderlineStyle.getValue()

Font.UnderlineStyle.Value

Font.VerticalPosition.getValue()

Font.VerticalPosition.Value

Legend.LegendLocation.getValue()

Legend.LegendLocation.Value

NamedObject.BuiltInName.getValue()

NamedObject.BuiltInName.Value

NamedObject.ReturnType.getValue()

NamedObject.ReturnType.Value

NamedObject.Scope.getValue()

NamedObject.Scope.Value

NumberFormat.Color.getValue()

NumberFormat.Color.Value

ObjectPositioning.getValue()

ObjectPositioning.Value

PageSetup.CellErrorsAs.getValue()

PageSetup.CellErrorsAs.Value

PageSetup.PageOrientation.getValue()

=20

PageSetup.PageOrientation.Value

PageSetup.PagePaperSize.getValue()

PageSetup.PagePaperSize.Value

PageSetup.PagePrintOrder.getValue()

=20

PageSetup.PagePrintOrder.Value

Pattern.getValue()

Pattern.Value

SettingsBarColumn.ShapeType.getValue()

<= /td>=20

SettingsBarColumn.ShapeType.Value

Style.ColumnInsertBehavior.getValue()

=20

Style.ColumnInsertBehavior.Value

Style.HAlign.getValue()

Style.HAlign.Value

Style.RowInsertBehavior.getValue()

Style.RowInsertBehavior.Value

Style.TextDir.getValue()

Style.TextDir.Value

Style.VAlign.getValue()

Style.VAlign.Value

Trendline.Regression.getValue()

Trendline.Regression.Value

Worksheet.SheetViewState.getValue()

=20

Worksheet.SheetViewState.Value

Worksheet.SheetVisibility.getValue()

=20

Worksheet.SheetVisibility.Value

Worksheet.SummaryColumnsLocation.getValue() =

Worksheet.SummaryColumnsLocation.Value

<= /td>=20

Worksheet.SummaryRowsLocation.getValue()

Worksheet.SummaryRowsLocation.Value

=20
=20

Properties

=20

The following properties were renamed because of changes in the source c= ode:

=20
=20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20

ExcelWriter v6 Property

ExcelWriter v7 Equivalent Property

ChartType.Custom.Custom

ChartType.Custom.Combo

ChartType.Scatter.Scatter

ChartType.Scatter.StandardScatter

=20

Unsupported Metho= ds

=20

Additionally, there are a small number of methods which are no longer su= pported in ExcelWriter v7 and have not been replaced with an alternative me= thod or property:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

ChartType.Area.getValue()

ChartType.Bar.getValue()

ChartType.Bubble.getValue()

ChartType.Column.getValue()

ChartType.Custom.getValue()

ChartType.Doughnut.getValue()

ChartType.Line.getValue()

ChartType.Pie.getValue()

ChartType.Radar.getValue()

ChartType.Scatter.getValue()

ChartType.Surface.getValue()

SettingsPieDoughnut.BopPopSplit.getValue() <= /p>

=20

New DataBindin= g Methods

=20

The methods used to bind data to a template in ExcelWriter v6 using the = ExcelTemplate object have been deprecated in ExcelWriter v7. Though the old= SetDataSource methods are still sup= ported for backwards compatibility reasons in ExcelWriter v7, they have bee= n replaced by BindData methods.

= =20

The new BindData methods enable the use of the new DataBindingProperties object. Instead of passing a MaxRow= s or Transpose parameter to BindData= as you would SetDataSource, you can= set the MaxRows or Transpose properties of the DataBindingProperties ob= ject. Additionally, DataBindingProperties includes a WorksheetName property which, when set, will allow you to = specify a worksheet if you wish for your data to only be bound to a single = worksheet in the template. Multiple BindData calls could bind data to each = worksheet in a template from a different data source. Additionally, the sam= e DataBindingProperties object can be used for multiple BindData calls if t= he same settings are desired for multiple data sets.

=20

This table lists the deprecated SetDataSource methods and their new Bind= Data equivalents:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

Deprecated SetDataSource method

New BindData method

SetDataSo= urce

BindData<= /a>

SetCellDa= taSource

BindCellD= ata

SetColumn= DataSource

BindColum= nData

SetRowDat= aSource

BindRowDa= ta

------=_Part_10498_2011592499.1711726602674--