AnQiCMS can be used to implement Excel batch import through the API interface.

Excel format requirements

Excel table must include columns such as title, content, category ID, and other necessary columns. Optional columns may include keywords, descriptions, and tags.

Import process

Step 1: Organize Excel data. Step 2: Write a script to read Excel. Step 3: Call the API interface to import line by line. Step 4: Check the import results.

Python script example

Use the pandas library to read Excel, use the requests library to call the API interface. The official documentation provides sample code that can be directly referred to for use.

Points to note

The HTML content in Excel needs to be formatted correctly. The category ID should be created in advance in the background. It is recommended to test a small amount of data before bulk import.

efficiency

The API interface supports fast import, and hundreds of contents can usually be completed in a few minutes. Significantly improves the efficiency of content entry.