ExcelToPdfConvertBytes Method |
Convert Excel bytes array to PDF, Word, RTF bytes array
Namespace: SautinSoftAssembly: SautinSoft.ExcelToPdf (in SautinSoft.ExcelToPdf.dll) Version: 2024.11.30
Syntax public byte[] ConvertBytes(
byte[] bytes
)
Public Function ConvertBytes (
bytes As Byte()
) As Byte()
Parameters
- bytes Byte
-
Return Value
Byte
Bytes array where output document will be saved after converting. You don't have to allocate memory for this array.
Example Convert Excel to PDF in memory using C#
using System;
using System.IO;
using SautinSoft;
namespace Sample
{
class Sample
{
static void Main(string[] args)
{
ConvertExcelAsMemoryStream();
}
public static void ConvertExcelAsByteArray()
{
ExcelToPdf x = new ExcelToPdf();
x.OutputFormat = SautinSoft.ExcelToPdf.eOutputFormat.Pdf;
string excelFile = Path.GetFullPath(@"..\..\..\test.xlsx");
string pdfFile = Path.ChangeExtension(excelFile, ".pdf"); ;
byte[] excelBytes = File.ReadAllBytes(excelFile);
byte[] pdfBytes = null;
try
{
pdfBytes = x.ConvertBytes(excelBytes);
File.WriteAllBytes(pdfFile, pdfBytes);
System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(pdfFile) { UseShellExecute = true });
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.ReadLine();
}
}
public static void ConvertExcelAsMemoryStream()
{
ExcelToPdf x = new ExcelToPdf();
x.OutputFormat = SautinSoft.ExcelToPdf.eOutputFormat.Pdf;
string excelFile = Path.GetFullPath(@"..\..\..\test.xlsx");
string pdfFile = Path.ChangeExtension(excelFile, ".pdf");
byte[] pdfBytes = null;
try
{
using (MemoryStream ms = new MemoryStream(File.ReadAllBytes(excelFile)))
{
pdfBytes = x.ConvertBytes(ms.ToArray());
}
File.WriteAllBytes(pdfFile, pdfBytes);
System.Diagnostics.Process.Start(new System.Diagnostics.ProcessStartInfo(pdfFile) { UseShellExecute = true });
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
Console.ReadLine();
}
}
}
}
Convert Excel to PDF in memory using VB.Net
Imports System
Imports System.IO
Imports SautinSoft
Module Sample
Sub Main()
ConvertExcelAsByteArray()
End Sub
Public Sub ConvertExcelAsByteArray()
Dim x As New ExcelToPdf()
x.OutputFormat = SautinSoft.ExcelToPdf.eOutputFormat.Pdf
Dim excelFile As String = Path.GetFullPath("..\..\..\test.xlsx")
Dim pdfFile As String = Path.ChangeExtension(excelFile, ".pdf")
Dim excelBytes() As Byte = File.ReadAllBytes(excelFile)
Dim pdfBytes() As Byte = Nothing
Try
pdfBytes = x.ConvertBytes(excelBytes)
File.WriteAllBytes(pdfFile, pdfBytes)
System.Diagnostics.Process.Start(New System.Diagnostics.ProcessStartInfo(pdfFile) With {.UseShellExecute = True})
Catch ex As Exception
Console.WriteLine(ex.Message)
Console.ReadLine()
End Try
End Sub
Public Sub ConvertExcelAsMemoryStream()
Dim x As New ExcelToPdf()
x.OutputFormat = SautinSoft.ExcelToPdf.eOutputFormat.Pdf
Dim excelFile As String = Path.GetFullPath("..\..\..\test.xlsx")
Dim pdfFile As String = Path.ChangeExtension(excelFile, ".pdf")
Dim pdfBytes() As Byte = Nothing
Try
Using ms As New MemoryStream(File.ReadAllBytes(excelFile))
pdfBytes = x.ConvertBytes(ms.ToArray())
End Using
File.WriteAllBytes(pdfFile, pdfBytes)
System.Diagnostics.Process.Start(New System.Diagnostics.ProcessStartInfo(pdfFile) With {.UseShellExecute = True})
Catch ex As Exception
Console.WriteLine(ex.Message)
Console.ReadLine()
End Try
End Sub
End Module
See Also