Load list from Excel

 
1
0
-1

Hi,

I have a problem loading a list from an Excel file (xlsx) using a Form and the import tool.

My Excel file is 736 lines long, but when loaded, the list contain a lot of blank lines and is about 32000 lines long ?

The stange thing is that I load another list from a 194 lines Excel file and I don't have the same problem.

What am I doing wrong ?

Is there a way to empty a list before reloading it ?

Thank you in advance,

Daniel

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      Use this guide Import Menu to learn how to configure the Import Menu.

      Add a delete button in Userview CRUD menu to clear your list, or use a database tool/manager (SQLYog for example, for MySQL DB) to truncate the DB table.

        CommentAdd your comment...