The sample source codes on this page shows how to convert XLS to XLSX in VB.NET. ByteScout Spreadsheet SDK: the SDK component for writing, reading, modifying and calculating Excel and CSV spreadsheets. Can calculate and reculculate formulas with Excel installed. You may import or export data to and from CSV, XML, JSON. Supports export to databases, arrays, streams. It can convert XLS to XLSX in VB.NET.
Fast application programming interfaces of ByteScout Spreadsheet SDK for VB.NET plus the instruction and the code below will help you quickly learn how to convert XLS to XLSX. In order to implement the functionality, you should copy and paste this code for VB.NET below into your code editor with your app, compile and run your application. Code testing will allow the function to be tested and work properly with your data.
Our website provides trial version of ByteScout Spreadsheet SDK for free. It also includes documentation and source code samples.
Imports Bytescout.Spreadsheet Imports System.Diagnostics Imports System.IO Module Module1 Sub Main() ' Open existing XLS file Dim spreadsheet As New Spreadsheet() spreadsheet.LoadFromFile("Input.xls") ' delete output file if exists already if File.Exists("Output.xlsx") Then File.Delete("Output.xlsx") End If ' Save it as XLSX spreadsheet.SaveAs("Output.xlsx") ' open output document in default viewer Process.Start("Output.xlsx") End Sub End Module