Quote from Vadim on March 31, 2025, 5:51 pm

@javadrajabihakami

Check this out:

Plugin nzPluginXLS (Christian Chauvin)

Function XL2NB (Functions Library (Dembel))

Quote from javadrajabihakami on March 31, 2025, 8:47 pm

Mr. Vadim, thank you for your response! I will check if I can use it and let you know for further guidance. Thanks again.

Quote from javadrajabihakami on April 2, 2025, 1:58 am

Quote from Vadim on March 31, 2025, 5:51 pm

@javadrajabihakami

Check this out:

Plugin nzPluginXLS (Christian Chauvin)

Function XL2NB (Functions Library (Dembel))

Hello and good morning, is this a plugin for Visual Neo Web? I would appreciate it if you could provide an example that is with Visual Neo Web for learning and use. Thanks again for your help.

Quote from Vadim on April 2, 2025, 5:56 pm

@javadrajabihakami

Oh, no, sorry! These are plugins for VisualNEO Win.

Quote from luishp on April 2, 2025, 6:44 pm

@javadrajabihakami you can use neoSql plugin to get the data from a Microsoft Excel file and neoPhp plugin to write them into a database.
You can also upload your Excel file into Google Sheets and use neoGsheets plugin to load the data.
All those plugins are included with VisualNEO Web.

If you just need to transform an Excel file into SQLite database I can provide you a Python script for that if you want.

Quote from javadrajabihakami on April 3, 2025, 1:54 am

Quote from luishp on April 2, 2025, 6:44 pm

@javadrajabihakami you can use neoSql plugin to get the data from a Microsoft Excel file and neoPhp plugin to write them into a database.
You can also upload your Excel file into Google Sheets and use neoGsheets plugin to load the data.
All those plugins are included with VisualNEO Web.

If you just need to transform an Excel file into SQLite database I can provide you a Python script for that if you want.

Dear friend, thank you for your response, I just need an example of getting information from Excel and saving it in the database! So that I can save the information from the Excel file in the database! Thanks

Quote from javadrajabihakami on May 17, 2025, 3:52 pm

Hello and good morning, how do we insert a json file into the database?
With the help of Mr. Asmat's practical example, I managed to understand this issue a little! My problem is, how do I insert this information received in the form of a json file into the database? I would appreciate it if you could take a look at this example and solve my problem! Thanks

Quote from javadrajabihakami on May 17, 2025, 11:37 pm

Thanks for the tips Mr. Lewis:
I tried the following codes and it worked fine

.................................................................................

In the coding section of the Insert button in the table, I wrote the following codes:

... Reset any previous column definitions
neoTableResetColumns "neoTableContainer"
... setup columns; IMPORTANT: column numbers MUST start at 1
neoTableSetColumn "neoTableContainer" 1 "ردیف" "ردیف" "" false false false ""
neoTableSetColumn "neoTableContainer" 2 "نام" "نام" "" false false false ""
neoTableSetColumn "neoTableContainer" 3 "فامیل" "فامیل" "" false false false ""
neoTableSetColumn "neoTableContainer" 4 "شرکت" "شرکت" "" false false false ""
neoTableSetColumn "neoTableContainer" 5 "جنسیت" "جنسیت" "" false false false ""
neoTableSetColumn "neoTableContainer" 6 "آدرس" "آدرس" "" false false false ""

... define user permissions
neoTableInitTable "neoTableContainer" "" 0 "Table" true false false false false ""
... load Data
neoTableLoadData "neoTableContainer" [myArray]
.........................................................................................
createEmptyArray [data]
setvar [data] [myArray]
Arraylen [data] [total]
setvar [currentRecord] 0
SetVar [a] [data([currentRecord]).ردیف]
SetVar [b] [data([currentRecord]).نام]
SetVar [c] [data([currentRecord]).فامیل]
SetVar [d] [data([currentRecord]).شرکت]
SetVar [e] [data([currentRecord]).جنسیت]
SetVar [f] [data([currentRecord]).آدرس]
.....................................................
neoTableSetData [data] [idos] "id" [idos]
Math "[total]-1" 0 [tadad]
...........................................
SetVar [imageIndex] 0
handleNextnameInsert .....> The name of the subroutine is
...................
jsAlert "End of processing [total] Case"

...............................And in my subroutine section I wrote this code:........................................................

If [imageIndex] <= [tadad]
........................................................
SetVar [b] [data([currentRecord]).نام]
SetVar [c] [data([currentRecord]).فامیل]
SetVar [d] [data([currentRecord]).شرکت]
SetVar [e] [data([currentRecord]).جنسیت]
SetVar [f] [data([currentRecord]).آدرس]
.setvar [nameo] "[data([id]).name]"

neoPhpExecSql "db1" "insertSample" "[b]::[c]::[d]::[e]::[f]" "handleNextnameInsert"
Math "[imageIndex]+1" "0" [imageIndex]
setvar [currentRecord] [currentRecord]+1
EndIf

........................................................................................

This code got all the rows in the json file taken from the excel file in order and saved it in my database. Thanks for the guidance dear teacher.