Skip to content

Instantly share code, notes, and snippets.

@conholdate-gists
conholdate-gists / MergeMultipleWorksheetsIntoOne.cs
Last active January 13, 2021 09:54
Copy data from several worksheets into one worksheet.
// Open an Excel file that contains the worksheets:
// Products1, Products2 and Products3
Workbook workbook = new Workbook("Products.xlsx");
// Add a worksheet named Summary_sheet
Worksheet summarySheet = workbook.Worksheets.Add("Summary_sheet");
// Iterate over source worksheets whose data you want to copy to the
// summary worksheet
string[] nameOfSourceWorksheets = { "Products1", "Products2", "Products3" };
@conholdate-gists
conholdate-gists / CombineExcelFiles.cs
Created January 14, 2021 05:57
Combine Multiple Excel Files into One using C#
// Open the first excel file.
Workbook SourceBook1 = new Workbook("Excel A.xlsx");
// Open the second excel file.
Workbook SourceBook2 = new Workbook("Excel B.xlsx");
// Open the third excel file.
Workbook SourceBook3 = new Workbook("Excel C.xlsx");
// Copy worksheets of second Excel file to the first workbook.
@conholdate-gists
conholdate-gists / combineSpecificWorksheetsOfExcelFiles.cs
Created January 14, 2021 06:05
Combine Specific Worksheets of Excel Files using C#
// Open Excel A file.
Workbook excelA = new Workbook("Excel A.xlsx");
// Open Excel B file.
Workbook excelB = new Workbook("Excel B.xlsx");
// Create destination Workbook.
Workbook destWorkbook = new Workbook();
// First worksheet is added by default to the Workbook. Add the second worksheet.
destWorkbook.Worksheets.Add();
@conholdate-gists
conholdate-gists / ConvertPDFtoXLSX.cs
Last active March 31, 2021 08:07
Convert PDF to XLS or XLSX using GroupDocs.Conversion for .NET API
// PDF Load Options
GroupDocs.Conversion.Contracts.Func<LoadOptions> getLoadOptions = () => new PdfLoadOptions
{
FlattenAllFields = true, // all fields in the source document will be flatten during conversion
Password = "123" // provide password if document is password protected
};
// Excel Convert Options
SpreadsheetConvertOptions options = new SpreadsheetConvertOptions
{
@conholdate-gists
conholdate-gists / RenderVisioFiles_Java
Last active April 7, 2021 05:41
Render Visio supported VSSD, VSDX and VSTX files in HTML, PDF and Image formats using GroupDocs.Viewer for Java API
Render Visio Files in other formats using Java
1. Render Visio (.vsdx) to JPG
2. Render Visio (.vsdx) to PNG
3. Render Visio (.vstx) to PDF
4. Render Visio (.vssx) to HTML
@conholdate-gists
conholdate-gists / Convert HTML to PDF and PDF to HTML
Last active April 10, 2021 09:00
Convert HTML to PDF and PDF to HTML using C# .NET API
Convert HTML to PDF and PDF to HTML using C# .NET API
@conholdate-gists
conholdate-gists / Examples-DotNET-CSsharp-JPEG-to-PDF-1.cs
Last active April 12, 2021 10:19
This Gist repository contains code snippet related to Conholdate.Total for .NET
// For complete examples and data files, please go to https://github.com/aspose-words/Aspose.Words-for-.NET
Document doc = new Document();
DocumentBuilder builder = new DocumentBuilder(doc);
builder.InsertImage(dataDir + "Watermark.png");
dataDir = dataDir + "DocumentBuilderInsertInlineImage_out.doc";
doc.Save(dataDir);
@conholdate-gists
conholdate-gists / ComparePDFFiles_CSharp
Created April 13, 2021 19:57
Compare PDF Files and Highlight Differences using GroupDocs.Comparison for C# API
Compare PDF Files using C#
1. Compare Two PDF Files using C#
2. Compare Password Protected PDF Files using C#
@conholdate-gists
conholdate-gists / Convert JPG to PNG and PDF in CSharp
Last active April 17, 2021 00:59
This Gist contains the code snippet for JPG image to PNG conversion and also, JPEG to PDF conversion using C# .NET
This Gist contains the code snippet for JPG image to PNG conversion and also, JPEG to PDF conversion using C# .NET
@conholdate-gists
conholdate-gists / SignWithDigitalSignatures_Java
Last active April 22, 2021 16:55
Sign Documents with Digital Signatures using GroupDocs.Signatures for Java
Sign Documents with Digital Signatures using Java
1. Sign PDF Documents using Java
2. Sign Word Documents using Java