Convert Excel file using Spire.XLS

using Spire.Xls;  
using Spire.Pdf;  
using Spire.Xls.Converter;

private void button1_Click(object sender, EventArgs e)  
{  
   // load Excel file  
   Workbook workbook = new Workbook();  
   workbook.LoadFromFile("D:\\MyExcel.xlsx");  
   // Set PDF template  
   PdfDocument pdfDocument = new PdfDocument();  
   pdfDocument.PageSettings.Orientation = PdfPageOrientation.Landscape;  
   pdfDocument.PageSettings.Width = 970;  
   pdfDocument.PageSettings.Height = 850;  
   //Convert Excel to PDF using the template above  
   PdfConverter pdfConverter = new PdfConverter(workbook);  
   PdfConverterSettings settings = new PdfConverterSettings();  
   settings.TemplateDocument = pdfDocument;  
   pdfDocument = pdfConverter.Convert(settings);  
   // Save and preview PDF  
   pdfDocument.SaveToFile("MyPDF.pdf");  
   System.Diagnostics.Process.Start("MyPDF.pdf");  
}

VB.NET Code

'load Excel file  
Dim workbook As New Workbook()  
workbook.LoadFromFile("D:\MyExcel.xlsx")  
' Set PDF template  
Dim pdfDocument As New PdfDocument()  
pdfDocument.PageSettings.Orientation = PdfPageOrientation.Landscape  
pdfDocument.PageSettings.Width = 970  
pdfDocument.PageSettings.Height = 850  
'Convert Excel to PDF using the template above  
Dim pdfConverter As New PdfConverter(workbook)  
Dim settings As New PdfConverterSettings()  
settings.TemplateDocument = pdfDocument  
pdfDocument = pdfConverter.Convert(settings)  
' Save and preview PDF  
pdfDocument.SaveToFile("MyPdf.pdf")  
System.Diagnostics.Process.Start("MyPdf.pdf") 

In the preceding code, we are loading an Excel file MyExcel.xlsx from my drive. The following is the contents of the Excel file.

Now if you run your project and click our button, you will get a PDF file as follows.

Cool! Very simple, right? Now we will go to other conversions as well.

Excel to HTML

To convert our Excel file to HTML, you need to create a button in our form and paste the following code to the button click event.

C# Code ​​​​​​

private void button2_Click(object sender, EventArgs e)  
{  
   //load Excel file  
   Workbook workbook = new Workbook();  
   workbook.LoadFromFile("D:\\MyExcel.xlsx");  
   //convert Excel to HTML  
   Worksheet sheet = workbook.Worksheets[0];  
   sheet.SaveToHtml("MyHTML.html");  
   //Preview HTML  
   System.Diagnostics.Process.Start("MyHTML.html");  
}

VB.NET Code

Private Shared Sub Main(args As String())  
'load Excel file  
Dim workbook As New Workbook()  
workbook.LoadFromFile("D:\\MyExcel.xlsx")  
'convert Excel to HTML  
Dim sheet As Worksheet = workbook.Worksheets(0)  
sheet.SaveToHtml("MyHTML.html")  
'Preview HTML  
System.Diagnostics.Process.Start("MyHTML.html")  
End Sub  

Now if you run the code, you can see an HTML file as follows.

Excel To Image

To convert our Excel file to an image, you need to create a button in our form and paste the following code to the button click event.

C# Code

private void button3_Click(object sender, EventArgs e)  
{  
   Workbook workbook = new Workbook();  
   workbook.LoadFromFile("D:\\MyExcel.xlsx");  
   Worksheet sheet = workbook.Worksheets[0];  
   sheet.SaveToImage("MyImage.jpg");  
}

VB.NET Code ​​​​

Shared Sub Main(ByVal args() As String)  
Dim workbook As New Workbook()  
workbook.LoadFromFile("D:\\MyExcel.xlsx")  
Dim sheet As Worksheet = workbook.Worksheets(0)  
sheet.SaveToImage("MyImage.jpg")  
End Sub 

Now if you run the code, you can see an image as follows.

Excel to CSV

To convert our Excel file to an image, you need to create a button in our form and paste the following code to the button click event.

C# Code​​​​​

private void button3_Click(object sender, EventArgs e)  
{  
   Workbook workbook = new Workbook();  
   workbook.LoadFromFile("D:\\MyExcel.xlsx");  
   Worksheet sheet = workbook.Worksheets[0];  
   sheet.SaveToFile("MyCSV.csv", ",", Encoding.UTF8);  
}

VB.NET Code​​​​​​​

Shared Sub Main(ByVal args() As String)  
Dim workbook As New Workbook()  
workbook.LoadFromFile("D:\\MyExcel.xlsx")  
Dim sheet As Worksheet = workbook.Worksheets(0)  
sheet.SaveToFile("MyCSV.csv", ",", Encoding.UTF8)  
End Sub

Now if you run the code, you can see a CSV file as follows.

Please note that you can convert your Excel data to any other file format, there are plenty of options available. Please try that too. I have given only three options that I use always.

Conclusion

Did I miss anything that you may think which is needed? Could you find this post as useful? I hope you liked this article. Please share me your valuable suggestions and feedback.

Your turn. What do you think?

A blog isn’t a blog without comments, but do try to stay on topic. If you have a question unrelated to this post, you’re better off posting it on C# Corner, Code Project, Stack Overflow, Asp.Net Forum instead of commenting here. Tweet or email me a link to your question there and I’ll definitely try to help if I can.