vb.net - 使用字符串值创建 Excel

Question

我想创建一个包含字符串行的 Excel。现在默认情况下，Excel 创建数字行，我要设置的值是 00000111。我使用的代码如下:

Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object

oExcel = CreateObject("Excel.Application")
oBook = oExcel.Workbooks.Add

oSheet = oBook.Worksheets("Sheet1")

oSheet.Range("A1").Value = "0000111"
oSheet.Range("B1").Value ="Name"
oSheet.Range("C1").Value = "Name2"
oSheet.Range("D1").Value = "Phone"

oBook.SaveAs("C:\New folder\excel\" & datenw & ".xlsx")
oExcel.Quit()

亲切的问候，伊菲吉尼亚

Answer 1

另一种方式

改变

oSheet.Range("A1").Value = "0000111"

到

oSheet.Range("A1").Value = "'0000111" '<~~ Notice the ' before the number