I Found this VBA code from

The column L is fine:

CodePudding user response：

thank you for your attention @Jeremy Thompson, I have found the solution, so that it can be retrieved by the vba webquery, to change the column type in google sheet from number to text or vice versa