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
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.
=20Table of Contents | =20
---|
=20
| =20
To upgrade ExcelWriter 6 to ExcelWriter 7 or 8, you should first uninsta= ll OfficeWriter 3 (which contains Excelwriter 6).
=20Unlike 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.
= =20To 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.
=20A number of minor changes were made to ExcelWriter properties, methods, = and enumerations in the shift from J# source code to pure C#.
=20The 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.=
=20ExcelWriter v6 Method | =20
ExcelWriter v7 Property | =20
---|---|
ChartType.getCategory() | =20
=20 |
ChartType.getName() | =20
=20 |
ChartType.is3D() | =20
=20 |
Worksheet.IsSelected() | =20
=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.
=20ExcelWriter v6 Method | =20
ExcelWriter v7 Property | =20
---|---|
Axis.TickLabelPos.getValue() | =20
Axis.TickLabelPos.Value | =20
Axis.TickType.getValue() | =20
Axis.TickType.Value | =20
AxisLabel.LabelPosition.getValue() | =
=20
AxisLabel.LabelPosition.Value | =20
Axis.Type.getValue() | =20
Axis.Type.Value | =20
Border.LineStyle.getValue() | =20
Border.LineStyle.Value | =20
Border.Part.getValue() | =20
Border.Part.Value | =20
CategoryAxis.AxisDisplayType.getValue() = | =20
CategoryAxis.AxisDisplayType.Value | =
=20
CategoryAxis.AxisTimeUnit.getValue() =20 | CategoryAxis.AxisTimeUnit.Value | =20
Cell.CellValueType.getValue() | =20
Cell.CellValueType.Value | =20
Chart.ChartLocation.getValue() | =20
Chart.ChartLocation.Value | =20
ChartLine.LineStyle.getValue() | =20
ChartLine.LineStyle.Value | =20
ChartLine.LineWeight.getValue() | =20
ChartLine.LineWeight.Value | =20
ChartPageSetup.PrintedChartSize.getValue() <= /p> | =20
ChartPageSetup.PrintedChartSize.Value = td>=20 |
ChartRegion.HorizontalAlignment.getValue() <= /p> | =20
ChartRegion.HorizontalAlignment.Value = td>=20 |
ChartRegion.VerticalAlignment.getValue() | =20
ChartRegion.VerticalAlignment.Value | =20
ChartType.ChartCategory.getValue() | =
=20
ChartType.ChartCategory.Value | =20
Condition.Comparison.getValue() | =20
Condition.Comparison.Value | =20
CopyPasteProperties.CopyPasteType.getValue()= | =20
CopyPasteProperties.CopyPasteType.Value = | =20
DataPointMarker.ShapeType.getValue() =20 | DataPointMarker.ShapeType.Value | =20
DataValidation.ComparisonType.getValue() | =20
DataValidation.ComparisonType.Value | =20
DataValidation | =20
DataValidation | =20
DataValidation.ValidationType.getValue() | =20
DataValidation.ValidationType.Value | =20
DocumentProperties.BuiltIn.getValue() = td>=20 | DocumentProperties.BuiltIn.Value | =
=20
ErrorBar.BarDirection.getValue() | =
=20
ErrorBar.BarDirection.Value | =20
ErrorBar.ErrorValueType.getValue() | =
=20
ErrorBar.ErrorValueType.Value | =20
Font.UnderlineStyle.getValue() | =20
Font.UnderlineStyle.Value | =20
Font.VerticalPosition.getValue() | =
=20
Font.VerticalPosition.Value | =20
Legend.LegendLocation.getValue() | =
=20
Legend.LegendLocation.Value | =20
NamedObject.BuiltInName.getValue() | =
=20
NamedObject.BuiltInName.Value | =20
NamedObject.ReturnType.getValue() | =
=20
NamedObject.ReturnType.Value | =20
NamedObject.Scope.getValue() | =20
NamedObject.Scope.Value | =20
NumberFormat.Color.getValue() | =20
NumberFormat.Color.Value | =20
ObjectPositioning.getValue() | =20
ObjectPositioning.Value | =20
PageSetup.CellErrorsAs.getValue() | =
=20
PageSetup.CellErrorsAs.Value | =20
PageSetup.PageOrientation.getValue() =20 | PageSetup.PageOrientation.Value | =20
PageSetup.PagePaperSize.getValue() | =
=20
PageSetup.PagePaperSize.Value | =20
PageSetup.PagePrintOrder.getValue() | =20
PageSetup.PagePrintOrder.Value | =20
Pattern.getValue() | =20
Pattern.Value | =20
SettingsBarColumn.ShapeType.getValue() <= /td>=20 | SettingsBarColumn.ShapeType.Value | =
=20
Style.ColumnInsertBehavior.getValue() = td>=20 | Style.ColumnInsertBehavior.Value | =
=20
Style.HAlign.getValue() | =20
Style.HAlign.Value | =20
Style.RowInsertBehavior.getValue() | =
=20
Style.RowInsertBehavior.Value | =20
Style.TextDir.getValue() | =20
Style.TextDir.Value | =20
Style.VAlign.getValue() | =20
Style.VAlign.Value | =20
Trendline.Regression.getValue() | =20
Trendline.Regression.Value | =20
Worksheet.SheetViewState.getValue() | =20
Worksheet.SheetViewState.Value | =20
Worksheet.SheetVisibility.getValue() =20 | Worksheet.SheetVisibility.Value | =20
Worksheet.SummaryColumnsLocation.getValue() = | =20
Worksheet.SummaryColumnsLocation.Value <= /td>=20 |
Worksheet.SummaryRowsLocation.getValue() | =20
Worksheet.SummaryRowsLocation.Value | =20
The following properties were renamed because of changes in the source c= ode:
=20ExcelWriter v6 Property | =20
ExcelWriter v7 Equivalent Property | =
=20
---|---|
ChartType.Custom.Custom | =20
ChartType.Custom.Combo | =20
ChartType.Scatter.Scatter | =20
ChartType.Scatter.StandardScatter | =
=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:
=20ChartType.Area.getValue() | =20
ChartType.Bar.getValue() | =20
ChartType.Bubble.getValue() | =20
ChartType.Column.getValue() | =20
ChartType.Custom.getValue() | =20
ChartType.Doughnut.getValue() | =20
ChartType.Line.getValue() | =20
ChartType.Pie.getValue() | =20
ChartType.Radar.getValue() | =20
ChartType.Scatter.getValue() | =20
ChartType.Surface.getValue() | =20
SettingsPieDoughnut.BopPopSplit.getValue() <= /p> | =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.
= =20The 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.
=20This table lists the deprecated SetDataSource methods and their new Bind= Data equivalents:
=20Deprecated SetDataSource method | =20
New BindData method | =20
---|---|
=20 | =20 |
=20 | =20 |
=20 | =20 |
=20 | =20 |