01.
Using package =
New
ExcelPackage()
02.
Dim
workbook = package.Workbook
03.
04.
05.
Dim
worksheet = workbook.Worksheets.Add(
"Sheet1"
)
06.
worksheet.Cells(
"A1"
).Value =
"ThaiCreate.Com"
07.
worksheet.Cells(
"B2"
).Value =
"2017"
08.
09.
10.
Dim
worksheet2 = workbook.Worksheets.Add(
"Sheet2"
)
11.
worksheet2.Cells(
"C2"
).Value =
"ThaiCreate.Com"
12.
worksheet2.Cells(
"D3"
).Value =
"2017"
13.
14.
package.SaveAs(
New
FileInfo(Server.MapPath(
"Xls/myExcel.xlsx"
)))
15.
End
Using