ColumnCollection.LastUsedIndex Property

Gets the index of the last edited column on a worksheet.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

[Browsable(false)]
int LastUsedIndex { get; }

VB.NET

<Browsable(False)>
ReadOnly Property LastUsedIndex As Integer

Property Value

Type	Description
Int32	A zero-based integer representing the index of the last modified column.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the LastUsedIndex property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-spreadsheet-load-an-ms-access-database-file-into-the-document/CS/WindowsFormsApplication1/MSAccessImportHelper.cs#L163

    table.Style = wb.TableStyles[BuiltInTableStyleId.TableStyleLight1];
    workSheet.Columns.AutoFit(0, workSheet.Columns.LastUsedIndex);
}

VB.NET

winforms-spreadsheet-load-an-ms-access-database-file-into-the-document/VB/WindowsFormsApplication1/MSAccessImportHelper.vb#L183

    table.Style = wb.TableStyles(BuiltInTableStyleId.TableStyleLight1)
    workSheet.Columns.AutoFit(0, workSheet.Columns.LastUsedIndex)
End Sub