Message-ID: <995897475.9401.1711690292879.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9400_631642028.1711690292879" ------=_Part_9400_631642028.1711690292879 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
An anchor represents the position of a floating (non-cell data) object w= ithin a spreadsheet. The position is maintained as a row number + a percent= age of the row's width and a column number + a percentage of the column's h= eight.
=20public sealed class Anchor=20
Public NotInheritable Class Anchor=20
ExcelApplication xla =3D new ExcelApplication(); Workbook wb =3D xla.Create(); Worksheet ws =3D wb.Worksheets[0]; Anchor anc =3D ws.CreateAnchor(2, 4, 0, 0);=20
Dim xla As New ExcelApplication() Dim wb As Workbook =3D xla.Create() Dim ws As Worksheet =3D wb.Worksheets(0) Dim anc As Anchor =3D ws.CreateAnchor(2, 4, 0, 0)=20
Name | =20
Description | =20
---|---|
=20 | Returns the 0-based number of the column contain= ing the anchor. | =20
=20 | Returns the X offset from the left side of the c= olumn containing the anchor, as a percentage of column width. | =20
=20 | Returns the Y offset from the top of the row con= taining the anchor, as a percentage of row height. | =20
Row= p> | =20
Returns the 0-based number of the row containing= the anchor.. | =20