1

Topic: To return at import from Excel a cell format

Day kind.
There is file Excel, outswapping of the report from 1 with grouping. Whether it is possible to return value of an amount of indents of a cell or level of grouping and if that is possible as?
In the sheet by Ekselnom it is not difficult for making, made, but it would be desirable without the intermediate pressures......
Thanks.

2

Re: To return at import from Excel a cell format

simply wrote:

Title: "to Return at import from Excel a cell format"
In the text: "There is file Excel, outswapping of the report from 1 with grouping."

So, actually, it is necessary?
Which 1?

3

Re: To return at import from Excel a cell format

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
End Function

Or

Public Function  (CELL As Range) As Long
 = .Rows (1).OutlineLevel
End Function

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.

4

Re: To return at import from Excel a cell format

simply;
Create in  object Excel, open it, yes use all its methods. To import it in  it is optional. The result can be written down also optionally in , and though in.txt

5

Re: To return at import from Excel a cell format

alecko wrote:

simply;
Create in  object Excel, open it, yes use all its methods. To import it in  it is optional. The result can be written down also optionally in , and though in.txt

As not mandatory to give answers to a question which I did not set.
I did not ask, WHERE to me to store my data , in basis or in a file.txt