there are different ways depending on the level of control you want to have.... Importing garbage is never a good idea, in my opinion, and an excel spreadsheet is very rarely controlled correctly...
That said, the simplest method (and the one with the least control is the himportxls function... [
help.windev.com]
After that, you can also import by reading the spreadsheet with the xlsxxxx functions, and looping on the lines to control and import them... That method is much better because you can massage the data, manage errors, etc... However, if your spreadsheet is big, you may encounter some problems.
My preferred method is to first transform the spreadsheet into a csv file, and then read that file with floadfile and process the lines by loops of extractstrings... This remove basically all size limit, and I can control exactly what is imported or not.
