Excel .Net

• Charts.
• Comments.
• Headers and Footers.
• Hyperlinks.
• Images.
• Pivot Tables.
Formulas.
• Tables.
• TextBoxes

Let us say, to convert a spreadsheet from Excel document to PDF within C# application:

// Set a path to our Document
 string outFile = @"..\..\..\Result.xlsx";

 // Create a new document
 ExcelDocument excelDocument = new ExcelDocument();

 // Add firstr worksheet
 excelDocument.Worksheets.Add("The main worksheet");

 // Create a variable to address
 var worksheet = excelDocument.Worksheets["The main worksheet"];

 // Add plain text
 worksheet.Cells["A1"].Value = "This is common string";
 worksheet.Cells["B1"].Value = "Hello, World! 12345";

 // Add the result of  the expression
 worksheet.Cells["A2"].Value = "This is the result of a mathematical expression in C#";
 worksheet.Cells["B2"].Value = 5 + 5;

 // Add the formula
 worksheet.Cells["A3"].Value = "This is the formula";
 worksheet.Cells["B3"].Formula = "=RAND()";

 // Add external and internal links
 worksheet.Cells["A4"].Value = "These are hyperlinks";
 worksheet.Cells["B4"].Value = "External link";
 worksheet.Cells["B4"].Hyperlink = new ExcelHyperlink { Location = "https://sautinsoft.com" };

 // Add a large composite text with formatting
 // Create a container of strings
 RichText text = new RichText();
 var part = new RichTextString("This is a very long string... ", new RichTextFormat { Italic = true, Bold = true, FontColor = SKColors.Blue });
 // Add the following lines to the container
 text.Add(part);

 // Save the document
 excelDocument.Save(outFile, new XlsxSaveOptions());