Question: how to export data in excel using vb.net?
Answer: Start a new workbook in Excel. Add the following headers to cells A1:B1 of Sheet1: A1: FirstName B1: LastName. Format cell B1 as right-aligned. Select A1:B1. On the Insert menu, choose Names and then select Define. ...  Save the new workbook as C:\Book1.