Re: Excel - import text souboru

From: Kamil Sverak (sverak@csadbk.cz)
Date: 25. 07. 2003, 15:23 CEST


> Prosim o pomoc. Zase mi predelali v ucetnim programu jeden report a ja musim
> znovunastavit makro.
> Ted vypada takto:
>     Workbooks.OpenText Filename:="C:\cas", Origin:=xlWindows, StartRow _
>         :=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
>         ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False
> _
>         , Space:=False, Other:=False, FieldInfo:=Array(Array(1, 9), Array(2,
> 1), _
>         Array(3, 9), Array(4, 4), Array(5, 9), Array(6, 2), Array(7, 9),
> Array(8, 9), Array(9, 9), _
>         Array(10, 1), Array(11, 9), Array(12, 9), Array(13, 9)),
> ThousandsSeparator:="."

> Muzete mi prosim nekdo vysvetlit, co jsou to ty udaje:
> FieldInfo:=Array(Array(1, 9)

> Prvni chapu, poradove cislo sloupce, ale co ta cisla za carkou?

Co takhle stisknout F1?

----------------------------------------------------
Array(Array(3, 9), Array(1, 2))
If the source data has fixed-width columns, the first
element in each two-element array specifies the
position of the starting character in the column (as an
integer; character 0 (zero) is the first character).
The second element in the two-element array specifies
the parse option for the column as a number between 1
and 9, as listed in the preceding table.

The following example parses two columns from a
fixed-width text file. The first column includes
characters 1 through 10. Characters 11, 12, 13, 14, and
15 are skipped. The second column includes character 16
through the last character in the line.

Array(Array(0, 1), Array(10, 9), Array(15, 1))
----------------------------------------------------

Preklad treba? Druhe cislo vyjadruje druh sloupce
1 - obecny
...
9 - preskocit

--
cao,
 Kamil 



This archive was generated by hypermail 2.1.3 : 25. 07. 2003, 15:18 CEST