I'm not professional in coding. Now I have successfully generated my users on nodebb from the EXCEL data. Guys you may think it is so easy and can be done by serval codes，but it's quite hard for me to understand the http protocols and programing think.
And now thank you I can do it myself.
Here is the code of generating new users on EXCEL VBA. Hope it can help people like me. ; )
Dim i As Integer
Dim data, user, pass, mail As String
Dim XMLHTTP As New MSXML2.XMLHTTP, myurl As String
myurl = "http://yourhost/api/v1/users/"
For i = 6 To 8
user = "username=" & Cells(i, 1)
pass = "&password=" & Cells(i, 2)
mail = "&email=" & Cells(i, 4)
data = user + pass + mail
XMLHTTP.Open "POST", myurl, False
XMLHTTP.setRequestHeader "Authorization", "Bearer yourtoken"
XMLHTTP.setRequestHeader "Content-type", "application/x-www-form-urlencoded"
Here I set
i as the row, and I put username, password and email in column A,B,and D.
Thank you again!