Code: Select all
aExcel := oSheet:range( "A1:"+cEnde+LTRIM( STR(nRow) ) ):valueExcel - error al importar
Moderator: Rathinagiri
-
Rathinagiri
- Posts: 5481
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Excel - error al importar
This is working very fast really. But, the date value is imported as null if it has customformatting. Any clues?
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
-
AUGE_OHR
- Posts: 2096
- Joined: Sun Aug 25, 2019 3:12 pm
- DBs Used: DBF, PostgreSQL, MySQL, SQLite
- Location: Hamburg, Germany
Re: Excel - error al importar
hi,
i recommend to "format" Column "before" paste Array to SheetRathinagiri wrote: ↑Fri Jul 14, 2023 2:28 am This is working very fast really. But, the date value is imported as null if it has customformatting. Any clues?
Code: Select all
oSheet:Columns( nCol ) ::NumberFormat := "TT.MM.JJ"have fun
Jimmy
Jimmy