How to transfer information from excel to a remote server?

Question

Computer networks

Actually, the task is to transfer information from a certain cell in the exel table to the server for further processing and output to the site.
Well, the second question, not so important, is it possible to write information to a json file?

Answer 1

I can write a sequence of actions only for 2007:
1) Main round menu button / "Excel Options" button / "Basic" tab / turn on the "Show menu = Developer = on the ribbon" checkbox.
2) Menu "Developer" / button "Insert" / Form control "Button" / on the Excel sheet, select a place for the button by clicking the mouse and selecting the area / Macro "Create"
3) In the window that opens, edit the VBA code between

Sub Кнопка1_Щелчок()

End Sub

insert the text from the example, replacing the server name with yours, and instead of an empty string in send("") write send( "Param1=" & Cells(5, 2).Value ), which will mean send to the server with the "Param1" parameter of the POST method the value from the cell Y=5, X=2
Well, every time the client opens this document, he will be asked to allow the execution of macros ...

Answer 2

You need a parser to process your files. It is best to use not excel, but csv file. They are easier to handle. In general, your requirements are very superficial.