In today’s digital age, whether it’s software development, data analysis, or everyday automation tasks, interaction with web services is indispensable. For instance, you might need to fetch weather data from an API to create a weather application, or batch download images from a website, or automate testing a web interface. The core of these operations … Read more
Today, I will share code that sends <span>HTTP</span> requests through <span>Excel</span> to retrieve web resources. Function BytesToBString(Body, Cset) On Error Resume Next '"GB2312" '"GBK" '"UTF-8" ' Excel byte encoding conversion Dim Objstream Set Objstream = CreateObject("adodb.stream") Objstream.Type = 1 Objstream.Mode = 3 Objstream.Open Objstream.Write Body Objstream.Position = 0 Objstream.Type = 2 Objstream.Charset = Cset BytesToBString … Read more
In the digital age, HTTP requests are the core bridge connecting local programs with web services—whether querying weather, calling API interfaces, scraping public data, or automating form submissions and testing web services, efficient HTTP communication is essential. Have you ever struggled with the cumbersome syntax of the urllib library? Have you written excessive code to … Read more
2.7 Handling Files with Gin 2.7.1 Static Files In the Gin framework, you can use the built-in static file handling middleware to serve static files (e.g., images, CSS files, JS files, etc.). An example is shown below: package main import "github.com/gin-gonic/gin" func main() { r := gin.Default() // Serve static files r.Static("images", "./static/images/") … Read more
2.6.3 Gin Template Engine Gin supports rendering various data formats, including <span>JSON</span>, <span>XML</span>, <span>HTML</span>, etc. Among these, rendering HTML templates is very common in web development, and Gin provides a very convenient way to load and render HTML templates. Gin uses the <span>html/template</span> package to render templates, and the process consists … Read more
2.4 Handling HTTP Requests The process of handling HTTP requests in Gin is mapping the request path to the corresponding handler function through routing. Each request first passes through middleware (if any), and then the routing handler function executes the corresponding business logic based on the request method and path. After processing, Gin … Read more
2.3 Using Middleware Gin supports the use of middleware for a specific route or route group, as shown in the example code below: package main import ( "log" "time" "github.com/gin-gonic/gin" ) // Custom Middleware func Logger() gin.HandlerFunc { return func(ctx *gin.Context) { t := time.Now() // Set variable ctx.Set("Name", "Surpass") // Before request … Read more
2.2 Gin Handler Functions In the Gin framework, a handler function is a function used to process incoming requests, responsible for executing business logic and returning responses to the client. Handler functions are typically defined as a function that takes <span>*gin.Context</span> as a parameter.<span>*gin.Context</span> provides methods to access request information (such as URL, … Read more
2.1 Gin Routing The routing in Gin is responsible for mapping incoming request paths to the corresponding handler functions. The handler function is the core part that processes the request and generates the response, typically defined as <span>func(c *gin.Context)</span>, where c provides access to the request and response interfaces. By coordinating routing and … Read more
Why is it Necessary to “Cancel” HTTP Requests? Many front-end developers have had this experience: quickly typing multiple keywords in a search box, switching pages, or loading while scrolling, old requests have not returned, and new requests have been sent out. The result is: Page display is chaotic (old data overwrites new data) The browser … Read more