We preempt in file Excel the report from 1 8.3. Structure of outswapping with grouping, standard for 1.
From the report I load the data in Access for the further usage.
I need to transfer the order of grouping from Excel to basis Access.
In Ekselnom sheet to deduce the grouping order (level number) it is not difficult.
Added a column and it was transversed by function:
Function KolOtstupov (Ssylka As Range)
= Ssylka. IndentLevel
Public Function (CELL As Range) As Long
= .Rows (1).OutlineLevel
I asked a question, whether it is possible to return this value of an indent at once at import from Exsel in Access not
Changing an initiating file of outswapping.
If it is possible, as. If there is no that probably it will be program necessary to open the Book, to create the unit, to interpose function, to interpose a column into the beginning, to be transversed on a column from beginning to end........
As that so.