workbook = Workbook()
workbook.LoadFromFile(inputFile)
sheet = workbook.Worksheets[0]
sheet.RemoveDuplicates()
workbook.SaveToFile(outputFile, FileFormat.Version2013)
workbook.Dispose()

Document doc = new Document();
Paragraph paragraph = doc.addSection().addParagraph();
Chart chart = paragraph.appendChart(ChartType.Column, 450, 300).getChart();
chart.changeSeriesType("Series 3", ChartSeriesType.Line, true);
System.out.println(chart.getSeries().get(2).getChartType());
doc.saveToFile("ComboChart.docx"); 

PdfDocument doc = new PdfDocument();
doc.LoadFromFile("in.pdf");
doc.PrintSettings.PrintLogger= new DefaultPrintLogger("log.txt");
doc.PrintSettings.PaperSize =PdfPaperSize.A4;
doc.Print();

Document doc = new Document();
doc.LoadFromFile("sample.docx");
Document extractPage = doc.ExtractPages(0, 1);
extractPage.SaveToFile("result.docx");

Old:
AddDigitalSignature(X509Certificate2 certificate, string comments, DateTime signTime)

New: 
AddDigitalSignature(string certificatePath, string certificatePassword, string comments, DateTime signTime)

// New Append Audio
Presentation pres = new Presentation();
FileStream from_stream = File.OpenRead(inputFile);
RectangleF audioRect = new RectangleF(50, 50, 100, 100);
IAudio audio = pres.Slides[0].Shapes.AppendAudioMedia(from_stream, audioRect);
// Set the duration of the starting fade for 13s
audio.FadeInDuration = 13000f;
// Set the duration of the ending fade for 40s
audio.FadeOutDuration = 10000f;
pres.SaveToFile(outputFile, FileFormat.Pptx2013);

// Retrieve existing documents
FileStream from_stream = File.OpenRead(inputFile);
Presentation presentation = new Presentation();
presentation.LoadFromStream(from_stream, FileFormat.Auto);
foreach (IShape shape in presentation.Slides[0].Shapes)
{
    if (shape is IAudio)
    {
        IAudio audio = shape as IAudio;
        // Set the duration of the starting fade for 13s
        audio.FadeInDuration = 13000f;
        // Set the duration of the ending fade for 20s
        audio.FadeOutDuration = 20000f;
    }
}
presentation.SaveToFile(outputFile, FileFormat.Pptx2013);

// New Append Audio
Presentation pres = new Presentation();
FileStream from_stream = File.OpenRead(inputFile);
RectangleF audioRect = new RectangleF(50, 50, 100, 100);
IAudio audio = pres.Slides[0].Shapes.AppendAudioMedia(from_stream, audioRect);
// Set the start trimming time 8 seconds
audio.TrimFromStart = 8000f;
// Set the end trimming time 13 seconds
audio.TrimFromEnd = 13000f;
pres.SaveToFile(outputFile, FileFormat.Pptx2013);

// Retrieve existing documents			
FileStream from_stream = File.OpenRead(inputFile);
Presentation presentation = new Presentation();
presentation.LoadFromStream(from_stream, FileFormat.Auto);
foreach (IShape shape in presentation.Slides[0].Shapes)
{
    if (shape is IAudio)
    {
        IAudio audio = shape as IAudio;
        // Set the start trimming time 8 seconds
        audio.TrimFromStart = 8000f;
        // Set the end trimming time 13 seconds
        audio.TrimFromEnd = 13000f;
    }
}
presentation.SaveToFile(outputFile, FileFormat.Pptx2013);

table.Fill.Transparency = 0.5f; // Value range is 1-0, table default color is black
// Need to set specific table color, set color code as follows:
table[0, 0].FillFormat.FillType = Spire.Presentation.Drawing.FillFormatType.Solid;
table[0, 0].FillFormat.SolidColor.Color = Color.Orange;

Presentation ppt = new Presentation();
ppt.LoadFromFile("in.pptx");
//Add a digital signature,The parameters: string certificatePath, string certificatePassword, string comments, DateTime signTime
ppt.AddDigitalSignature("test.pfx", "e-iceblue", "111", DateTime.Now);
ppt.SaveToFile("result.pptx", Spire.Presentation.FileFormat.Pptx2016);
ppt.Dispose();

TSAHttpService timestampService = new TSAHttpService("http://time2.certum.pl");
TSAResponse response = timestampService.Check();
//if it is success to receive tsa token
if (response.Success)
  { formatter.TimestampService = timestampService; }

private void Form1_Load(object sender, EventArgs e)
{
    string pdfDoc = @"test.pdf";
    if (File.Exists(pdfDoc))
    {
        this.pdfDocumentViewer1.LoadFromFile(pdfDoc);
        this.pdfDocumentViewer1.Find("FindedText", Color.Empty);
    }
}
private void before_Click(object sender, EventArgs e)
{
    this.pdfDocumentViewer1.FindPrevious();
}

private void next_Click(object sender, EventArgs e)
{
    this.pdfDocumentViewer1.FindNext();
}

Workbook workbook = new Workbook();
// Get the first worksheet from the workbook
Worksheet sheet = workbook.getWorksheets().get(0);
// Set the value of cell range A1 to "&=Array"
sheet.getCellRange("A1").setValue("&=Array");
// Add a parameter named "Array" with an array of strings as its value
workbook.getMarkerDesigner().addArray("Array", new String[] { "Spire.Xls", "Spire.Doc", "Spire.PDF", "Spire.Presentation", "Spire.Email" });
// Apply the marker design to the workbook
workbook.getMarkerDesigner().apply();
// Calculate all the values in the workbook
workbook.calculateAllValue();
// Auto-fit the rows and columns in the allocated range of the worksheet
sheet.getAllocatedRange().autoFitRows();
sheet.getAllocatedRange().autoFitColumns();
// Save the workbook to the specified file path using Excel 2013 format
workbook.saveToFile(outputFile, ExcelVersion.Version2013);
// Clean up and release resources used by the workbook
workbook.dispose();

Document document = ConvertUtil.GetNewEngineDocument();
document.loadFromFile(inputFile);
RevisionInfoCollection revisionInfoCollection= document.getRevisionInfos();
for (RevisionInfo revisionInfo : (java.lang.Iterable)revisionInfoCollection) {
    if(revisionInfo.getRevisionType()==RevisionType.Format_Change){
        if(revisionInfo.getOwnerObject() instanceof TextRange){
            TextRange range = (TextRange)revisionInfo.getOwnerObject();
            TestUtil.writeAllText(outputFile,"TextRange:"+range.getText()+"\r\n");
            document.setRevisionsView(RevisionsView.Original);
            TestUtil.writeAllText(outputFile,"Original bold："+range.getCharacterFormat().getBold()+"\r\n");
            document.setRevisionsView(RevisionsView.Final);
            TestUtil.writeAllText(outputFile,"Final bold："+range.getCharacterFormat().getBold()+"\r\n");
        }
    }
}
document.close(); 

Document document = new Document();
document.loadFromFile("test.docx");
document.startTrackRevisions("e-iceblue");
for (int i=0; i<document.getSections().get(0).getParagraphs().get(0).getChildObjects().getCount();i++)
{
    if (document.getSections().get(0).getParagraphs().get(0).getChildObjects().get(i).getDocumentObjectType()== DocumentObjectType.Text_Range)
    {
        TextRange tr = (TextRange) document.getSections().get(0).getParagraphs().get(0).getChildObjects().get(i);
        tr.getCharacterFormat().setTextColor(Color.RED);
        tr.getCharacterFormat().setFontSize(28);
        tr.getCharacterFormat().setBold(true);


    }
}
document.getSections().get(0).getParagraphs().get(1).appendText("aaa");
document.stopTrackRevisions();
document.saveToFile("test-out.docx"); 

sec.getPageSetup().setGridType(GridPitchType.Chars_And_Line);
sec.getPageSetup().setCharactersPerLine(30);   

// Create PDF document
PdfDocument doc = new PdfDocument();
// Set margins
PdfUnitConvertor unitCvtr = new PdfUnitConvertor();
PdfMargins margin = new PdfMargins();
margin.setTop(unitCvtr.convertUnits(2.54f, PdfGraphicsUnit.Centimeter, PdfGraphicsUnit.Point));
margin.setBottom(margin.getTop());
margin.setLeft(unitCvtr.convertUnits(3.17f, PdfGraphicsUnit.Centimeter, PdfGraphicsUnit.Point));
margin.setRight(margin.getLeft());

// Add a page
PdfPageBase page = doc.getPages().add(PdfPageSize.A4, margin);

// Add table
PdfTable table = new PdfTable();
PdfSolidBrush brush = new PdfSolidBrush(new PdfRGBColor(Color.black));
table.getStyle().setBorderPen(new PdfPen(brush, 0.5f));
table.getStyle().getHeaderStyle().setStringFormat(new PdfStringFormat(PdfTextAlignment.Center));
table.getStyle().setHeaderSource(PdfHeaderSource.Rows);
table.getStyle().setHeaderRowCount(1);
table.getStyle().setShowHeader(true);
table.getStyle().setCellPadding(2);
table.getStyle().setHeaderSource(PdfHeaderSource.Rows);
table.getStyle().setHeaderRowCount(1);
table.getStyle().setShowHeader(true);

// Set header font and style
PdfTrueTypeFont font = new PdfTrueTypeFont(new Font("SimSun", Font.PLAIN, 12));
table.getStyle().getHeaderStyle().setFont(font);
table.getStyle().getHeaderStyle().setBackgroundBrush(PdfBrushes.getCadetBlue());
PdfTrueTypeFont fontBody = new PdfTrueTypeFont(new Font("SimSun", Font.PLAIN, 10));
// Set even row font
table.getStyle().getDefaultStyle().setFont(fontBody);
// Set odd row font
table.getStyle().getAlternateStyle().setFont(fontBody);
// false: distribute by total width proportion, true: use set column width
table.getStyle().isFixWidth(true);

// Define data
String[] data = {"1;2;3;4;5",
        "A1;B1;1,391,190,000;18.2%; ",
        "A1;B1;126,490,000;1.66%; ",
        "A1;B1;65,648,054;0.86%; ",
        "A1;B1;82,665,600;1.08%; ",
        "A1;B1;37,119,000;0.49%; ",
        "A1;B1;327,216,000;4.29%; "
};
String[][] dataSource = new String[data.length][];
for (int i = 0; i < data.length; i++) {
    dataSource[i] = data[i].split("[;]", -1);
}

table.setDataSource(dataSource);
for(int i = 0; i < table.getColumns().getCount(); i++)
{
    PdfColumn column = table.getColumns().get(i);
    column.setWidth(50);
    column.setStringFormat(new PdfStringFormat(PdfTextAlignment.Center, PdfVerticalAlignment.Middle));
}

// Add table to page
table.draw(page, new Point2D.Float(0, 50));

// Save document
doc.saveToFile("addTable.pdf", FileFormat.PDF); 

Presentation pt = new Presentation();
pt.loadFromFile("input.md", FileFormat.Markdown);
pt.saveToFile("output.pptx", FileFormat.PPTX_2013);
pt.dispose();

Presentation ppt = new Presentation();
ppt.loadFromFile("input.pptx");
for (int i = 0; i < ppt.getSlides().getCount(); i++)
{
ppt.getSlides().get(i).getShapes().addFromSVGAsShapes("in.svg");
            }
ppt.saveToFile("output.pptx", FileFormat.PPTX_2013);
ppt.dispose();