With this source code sample you may quickly learn how to convert XLS to CSV in VB.NET. ByteScout Spreadsheet SDK is the SDK that can write and read, modify and calculate Excel and CSV spreadsheets. Most popular formulas are supported. You may import or export data to and from CSV, XML, JSON as well as to and from databases, arrays and you can use it to convert XLS to CSV with 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 CSV. 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. Further enhancement of the code will make it more vigorous.
Free trial version of ByteScout Spreadsheet SDK is available on our website. Documentation and source code samples are included.
Imports Bytescout.Spreadsheet Imports System.IO Imports System.Diagnostics Module Module1 Sub Main() ' Open Spreadsheet Dim document As New Spreadsheet() document.LoadFromFile("SimpleReport.xls") ' remove output file if already exists If File.Exists("SimpleReport.csv") Then File.Delete("SimpleReport.csv") End If document.Workbook.Worksheets(0).SaveAsCSV("SimpleReport.csv") document.Close() ' open output document in default viewer Process.Start("SimpleReport.csv") End Sub End Module