Click or drag to resize

UseOfficeCPageStyleCPageOrientation Class

Allows to set page orientation for PDF document
Inheritance Hierarchy
SystemObject
  SautinSoftUseOfficeCPageStyleCPageOrientation

Namespace: SautinSoft
Assembly: UseOffice (in UseOffice.dll) Version: 2023.11.14
Syntax
Copy
public class CPageOrientation

The UseOfficeCPageStyleCPageOrientation type exposes the following members.

Constructors
 NameDescription
Public methodCode exampleUseOfficeCPageStyleCPageOrientation Creates a new instance of UseOfficeCPageStyleCPageOrientation class
Top
Methods
 NameDescription
Public methodAuto Set default page orientation, portrait
Public methodEqualsDetermines whether the specified object is equal to the current object.
(Inherited from Object)
Public methodGetHashCodeServes as the default hash function.
(Inherited from Object)
Public methodGetTypeGets the Type of the current instance.
(Inherited from Object)
Public methodLandscape Set landscape page orientation
Public methodPortrait Set portrait page orientation
Public methodToStringReturns a string that represents the current object.
(Inherited from Object)
Top
Example
How to convert a XLS file to a CSV file in C#
Copy
using System;
using System.IO;
using System.Collections;

namespace Sample
{
    class Test
    {
        static void Main(string[] args)
        {
            // Convert XLS file to CSV 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.csv");

            // 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_CSV);

            // 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.");
        }

    }
}
How to convert a XLS file to a CSV file in VB.Net
Copy
Imports System
Imports System.IO
Imports System.Collections

Namespace Sample
    Friend Class Test
        Shared Sub Main(ByVal args() As String)
            ' Convert XLS file to CSV 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.csv")

            ' 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_CSV)

            ' 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
See Also