Assign data to cell by opendialog.

Posted by: prapas-jb on 8 September 2017, 1:57 pm EST

  • Posted 8 September 2017, 1:57 pm EST

    Dear Sir,

    I try to get filename from dialog open and set file name to cells but it not work when i choose file and press ok button it show error "out of index" something like this. my code follow by above

    If Dialog.ShowDialog() = Windows.Forms.DialogResult.OK Then Filename = Dialog.FileName.ToString Dialog.Dispose() FpSpread2.Sheets(0).Cells(e.Row, 2).Text = Filename End If

    please help me.

     Thank advance. 


  • Replied 8 September 2017, 1:57 pm EST


    What event do you have this code? I tested it in the Spread's CellClick event and all worked correctly. Could you post a small zipped project reproducing the behavior you are seeing for us to debug?

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels