What am I missing, I'm modifying my code to export an XLSB from my web site. The template spreadsheet is XLSB and the file save string is explicit to save as XLSB. I changed the save option to XLSBSaveOption. Yet, I'm prompted that the output is Excel 2003 format and extension. My code is below, what am I missing?
Dim PriceCreditFile As String = path + "\price_credit\pc_challenge.xlsb"
Dim excel As Workbook = New Workbook(PriceCreditFile)
Dim sheet As Worksheet = excel.Worksheets("Raw_Data")
excel.FileFormat = FileFormatType.Xlsb
sheet.Cells.ImportDataTable(ExportDataSet.Tables(0), False, "A2")
excel.Save(Me.Response, strSaveAsFile, ContentDisposition.Inline, New XlsbSaveOptions(SaveFormat.Xlsb))