Grid and Spreadsheet : copy/paste import xlsx

Suite and Optimus Suite 7
#1

I have some questions :
I need to load data into a grid from excel

  • It’s seems that the new grid (above 6.0) doesn’t allow copy/paste from excel, is that correct ?
  • the suggested solution is to use spreadsheet ?
    –> i don’t see any sample about copy/paste from excel , i miss something ?
    –> if i use the load function with xlsx parameter, i can load a local xlsx file
    however : i can’t choose the sheet and i have some format issue (date format)

thx

#2
  • It’s seems that the new grid (above 6.0) doesn’t allow copy/paste from excel, is that correct ?
  • the suggested solution is to use spreadsheet ?

Yes, you’re right.
The solution is to use a spreadsheet.

–> i don’t see any sample about copy/paste from excel , i miss something ?

This is a default feature of the spreadsheet. You may check it in any spreadsheet sample

–> if i use the load function with xlsx parameter, i can load a local xlsx file
however : i can’t choose the sheet and i have some format issue (date format)

Could you please, clarify your problem, and provide a snippet, where it can be reconstructed.

#3

This is a default feature of the spreadsheet. You may check it in any spreadsheet sample
–> OK, work with Ctrl-C, Ctrl-V, i was expecting a Cut/Paste in edit menu. no important, that’s work.

–> Could you please, clarify your problem, and provide a snippet, where it can be reconstructed.
I try again and all work fine…my xlsx was initially with a password, perhaps side effect
I see all the sheets and date are correct

thx