Convert XLS file to Text file in C# and .NET


Complete code

using System;
using System.IO;
using System.Collections;

namespace Sample
{
    class Test
    {
        static void Main(string[] args)
        {
			// Before starting, we recommend to get a free 100-day key:
            // https://sautinsoft.com/start-for-free/
            
            // Apply the key here:
			// UseOffice.SetLicense("...");
			
            // Convert XLS file to Text file.
            // If you need more information about UseOffice .Net email us at:
            // support@sautinsoft.com.

            SautinSoft.UseOffice u = new SautinSoft.UseOffice();

            string inpFile = Path.GetFullPath(@"..\..\..\..\..\..\TestFiles\example.xls");
            string outFile = Path.GetFullPath("Result.txt");

            // Prepare UseOffice .Net, loads MS Excel in memory
            int ret = u.InitExcel();

            // Return values:
            // 0 - Loading successfully
            // 1 - Can't load MS Excel library in memory 

            if (ret == 1)
            {
                Console.WriteLine("Error! Can't load MS Excel library in memory");
                return;
            }

            // Perform the conversion.
            ret = u.ConvertFile(inpFile, outFile, SautinSoft.UseOffice.eDirection.XLS_to_TEXT);

            // Release MS Excel from memory
            u.CloseExcel();

            // 0 - Converting successfully
            // 1 - Can't open input file. Check that you are using full local path to input file, URL and relative path are not supported
            // 2 - Can't create output file. Please check that you have permissions to write by this path or probably this path already used by another application
            // 3 - Converting failed, please contact with our Support Team
            // 4 - MS Office isn't installed. The component requires that any of these versions of MS Office should be installed: 2000, XP, 2003, 2007, 2010, 2013, 2016 or 2019.
            if (ret == 0)
            {
                // Open the result.
                System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(outFile) { UseShellExecute = true });
            }
            else
                Console.WriteLine("Error! Please contact with SautinSoft support: support@sautinsoft.com.");
        }

    }
}

Download

Imports System
Imports System.IO
Imports System.Collections

Namespace Sample
	Friend Class Test
		Shared Sub Main(ByVal args() As String)
			' Before starting, we recommend to get a free 100-day key:
			' https://sautinsoft.com/start-for-free/

			' Apply the key here:
			' UseOffice.SetLicense("...");

			' Convert XLS file to Text file.
			' If you need more information about UseOffice .Net email us at:
			' support@sautinsoft.com.

			Dim u As New SautinSoft.UseOffice()

			Dim inpFile As String = Path.GetFullPath("..\..\..\..\..\..\TestFiles\example.xls")
			Dim outFile As String = Path.GetFullPath("Result.txt")

			' Prepare UseOffice .Net, loads MS Excel in memory
			Dim ret As Integer = u.InitExcel()

			' Return values:
			' 0 - Loading successfully
			' 1 - Can't load MS Excel library in memory 

			If ret = 1 Then
				Console.WriteLine("Error! Can't load MS Excel library in memory")
				Return
			End If

			' Perform the conversion.
			ret = u.ConvertFile(inpFile, outFile, SautinSoft.UseOffice.eDirection.XLS_to_TEXT)

			' Release MS Excel from memory
			u.CloseExcel()

			' 0 - Converting successfully
			' 1 - Can't open input file. Check that you are using full local path to input file, URL and relative path are not supported
			' 2 - Can't create output file. Please check that you have permissions to write by this path or probably this path already used by another application
			' 3 - Converting failed, please contact with our Support Team
			' 4 - MS Office isn't installed. The component requires that any of these versions of MS Office should be installed: 2000, XP, 2003, 2007, 2010, 2013, 2016 or 2019.
			If ret = 0 Then
				' Open the result.
				System.Diagnostics.Process.Start(New System.Diagnostics.ProcessStartInfo(outFile) With {.UseShellExecute = True})
			Else
				Console.WriteLine("Error! Please contact with SautinSoft support: support@sautinsoft.com.")
			End If
		End Sub

	End Class
End Namespace

Download

If you need a new code example or have a question: email us at support@sautinsoft.com or ask at Online Chat (right-bottom corner of this page).