根據excel自帶的vba宏進行操作
首先alt+F11

點擊插入~模塊

錄取執行語句

Sub GenerateSQL()Dim lastRow As IntegerlastRow = Cells(Rows.Count, 1).End(xlUp).RowFor i = 2 To lastRow '假設第一行是標題Cells(i, "S").Value = "INSERT INTO table_name (ID, RELEVANCE_ID, DATA_SOURCE, CREATE_DATE, MODIFY_DATE, DELETE_FLAG) VALUES ('" & _Cells(i, "A").Value & "', '" & Cells(i, "B").Value & "', '" & Cells(i, "C").Value & "', '" & Cells(i, "D").Value & "', '" & Cells(i, "E").Value & "', '" & Cells(i, "F").Value & "');"Next i
End Sub

第一個Cells后的是要輸出腳本的列
& _ 代表另起一行

最后執行

腳本就在所輸出列了