HMGforum.com

Posted: **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?

   aExcel := oSheet:range( "A1:"+cEnde+LTRIM( STR(nRow) ) ):value

Posted: **Tue Jul 18, 2023 9:04 pm**

hi,

Rathinagiri 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?

i recommend to "format" Column "before" paste Array to Sheet

Code: Select all

oSheet:Columns( nCol ) ::NumberFormat := "TT.MM.JJ"

HMGforum.com

Excel - error al importar

Re: Excel - error al importar

Re: Excel - error al importar