Question & Answer > View Question

Load list from Excel

Confluence User - 14 Sep, 2020

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

datalists;forms

1

Confluence User •

15 Sep, 2020 •

confluenceUser •

•

confluenceUser •

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.

1

CSV | Excel | XML | PDF

Your answer

Print

Load list from Excel

1

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

Load list from Excel.builder-style-d5401db1-0a9b-4f5f-ac1a-14b1a01e9357{background: #efefef59 !important; margin: 0px !important; padding: 10px !important; border-radius: 5px !important; border: 1px solid #ddd !important; text-align: left !important; color:#0E4A40 !important;}

1.builder-style-3d02cbd8-7039-4199-8e89-9b37813efcde{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-09449cbc-db37-46a0-a8e7-04e9b5dc0723{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

Load list from Excel

1

Your answer