excel files to website and programming gui

[ipaq4444]

Hi Guys,

Can i check if there is high level programming software or gui that allow for configuration of website setting / programming setting based of excel sheet?

For example, if i have a excel sheet with field box that mimic the appearance of a technical software with similar field box in the software. Can i know what kind of software can i use to high level program the data in the excel field box into the technical software field box?

 

[davidktw]

Hi Guys,

Can i check if there is high level programming software or gui that allow for configuration of website setting / programming setting based of excel sheet?

For example, if i have a excel sheet with field box that mimic the appearance of a technical software with similar field box in the software. Can i know what kind of software can i use to high level program the data in the excel field box into the technical software field box?

VBA
https://stackoverflow.com/questions/158633/how-can-i-send-an-http-post-request-to-a-server-from-excel-using-vba

as long as the same configuration in the website is something you can control via web requests, you can always fire off the web request on change event change of the data box form you are creating in your excel sheet.



It can be as a simplistic as one control per website setting or as complex as an absolute configuration expressed in XML that is populated by the corresponding data controls found in your worksheet.

 

[ipaq4444]

VBA
https://stackoverflow.com/questions...post-request-to-a-server-from-excel-using-vba

as long as the same configuration in the website is something you can control via web requests, you can always fire off the web request on change event change of the data box form you are creating in your excel sheet.



It can be as a simplistic as one control per website setting or as complex as an absolute configuration expressed in XML that is populated by the corresponding data controls found in your worksheet.

thank you David, if this a installed software on a remote box or local machine, is there any screen click macro software that can carry out the task?

Sorry for the noob question....

 

[davidktw]

thank you David, if this a installed software on a remote box or local machine, is there any screen click macro software that can carry out the task?

Sorry for the noob question....

Don’t quite get what you are talking about? Is this question the same as the earlier one? Who is controlling who? What is the target software to be controlled and so on. It is hard to make out what is the client and server end on both sides unless you give a more complete picture.

 

[jackoats.sg]

What you see as 'macro software' is a finished product of some software development.

macros are written in Microsoft VBA. Another alternative is to use an add-in to MS Excel written in Python - Try google for Python VBA.

In either case, someone has to write the program.

BTW, these are desktops-based software. Another choice is cloud-based software, which is the trend nowadays.

What you want the engineering software to do, and how you want to package and sell it, will influence your choices.

thank you David, if this a installed software on a remote box or local machine, is there any screen click macro software that can carry out the task?

Sorry for the noob question....