Get Excel Range.ColumnWidth (DotNet variable)

KeeperRU

Hello, can't get ColumnWidth from Excel. (NAV 2016)

Have this error:
Result (decimal) := XlRange.ColumnWidth;

Microsoft Dynamics NAV

---

A DotNet variable has not been instantiated. Attempting to call Microsoft.Office.Interop.Excel.Range.ColumnWidth in CodeUnit Excel Management: CopyColumnWidth

---

OK

---

Also this code:
XlRange2.ColumnWidth := XlRange.ColumnWidth;

Crushed NAV at all.

How Can I get this ColumnWidth to operate with it as Decimal?

Duikmeester

Does the range have 1 or multiple columns? If multiple then XlRange.ColumnWidth only works when all columns in your range have the same widths otherwise it returns NULL.

See MSDN for details.

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

Duikmeester

Does the range have 1 or multiple columns? If multiple then XlRange.ColumnWidth only works when all columns in your range have the same widths otherwise it returns NULL.

See MSDN for details.

KeeperRU

Duikmeester wrote: »

Does the range have 1 or multiple columns? If multiple then XlRange.ColumnWidth only works when all columns in your range have the same widths otherwise it returns NULL.

See MSDN for details.

Thank you, I have multiple columns with different size.