• Registered: 2017-05-15
  • Posts: 722

Topic: IMPORT EXCEL FILE

HELLO MVD.

Anybody from the MVD and experts to help this code.  When i import excel files with a currency column there is an error found.
Actually i download this sample from the forum. Credit to the Owner of this sample.

Please Help.

Thanks

Post's attachments

Attachment icon ImportExcel - Copy.zip 615.56 kb, 335 downloads since 2020-09-07 

  • From: Philippines
  • Registered: 2018-10-23
  • Posts: 417

Re: IMPORT EXCEL FILE

manixs2013 wrote:

HELLO MVD.

Anybody from the MVD and experts to help this code.  When i import excel files with a currency column there is an error found.
Actually i download this sample from the forum. Credit to the Owner of this sample.

Please Help.

Thanks

Change line 42 on script
from

result_string := result_string + '"'+Excel.ActiveSheet.Cells[rows,columns].Value+'",'

to 

result_string := result_string + '"'+VarToStr(Excel.ActiveSheet.Cells[rows,columns].Value)+'",'
brian
  • Registered: 2014-11-13
  • Posts: 371

Re: IMPORT EXCEL FILE

to insert a date?

Domebil

domebil's Website