// Old import (deprecated):
from spire.doc.charts import ChartType

// New import (use this):
from spire.doc.charts.ChartType import ChartType

doc = Document()
doc.LoadFromFile(inputFile)
firstColumn = doc.Bookmarks["t_insert"].FirstColumn
lastColumn = doc.Bookmarks["t_insert"].LastColumn

doc = Document()
tableStyle = doc.Styles.Add(StyleType.TableStyle, "TestTableStyle3")
tableStyle.LeftIndent = 55
tableStyle.Borders.Color = Color.get_Green()
tableStyle.HorizontalAlignment = RowAlignment.Right
tableStyle.Borders.BorderType = BorderStyle.Single

section = doc.AddSection()
table = section.AddTable()
table.ResetCells(3, 3)
table.Rows[0].Cells[0].AddParagraph().AppendText("Aligned according to left indent")
table.PreferredWidth = PreferredWidth.FromPoints(300)
table.Format.StyleName = "TestTableStyle3"

style = doc.Styles.FindByName("TestTableStyle3")
if (style is not None) and isinstance(style, TableStyle):
tableStyle = style
tableStyle.Borders.Color = Color.get_Black()
tableStyle.Borders.BorderType = BorderStyle.Double
tableStyle.RowStripe = 3
    tableStyle.ConditionalStyles[TableConditionalStyleType.OddRowStripe].Shading.BackgroundPatternColor = Color.get_LightBlue()
           tableStyle.ConditionalStyles[TableConditionalStyleType.EvenRowStripe].Shading.BackgroundPatternColor = Color.get_LightCyan()
tableStyle.ColumnStripe = 1
            tableStyle.ConditionalStyles[TableConditionalStyleType.EvenColumnStripe].Shading.BackgroundPatternColor = Color.get_LightPink()
table.ApplyStyle(tableStyle)
table.Format.StyleOptions = table.Format.StyleOptions | TableStyleOptions.ColumnStripe

doc.SaveToFile(outputFile, FileFormat.Docx)

style = doc.Styles.FindByName("TestTableStyle3")
style.RemoveSelf()

document = Document()
document.LoadFromFile(“input.mhtml”)
document.SaveToFile(“output.pdf”, FileFormat.PDF)
document.Close()

HtmlExportOptions options = doc.HtmlExportOptions;
 options.OfficeMathOutputMode = HtmlOfficeMathOutputMode.MathML; 

document = Document()
document.LoadFromFile(“input.docx”)
document.SaveToFile(“output.xlsx”, FileFormat.XLSX)
document.Close()

workbook.HidePivotFieldList = true;

workbook = Workbook()
workbook.LoadFromFile(inputFile)
markdownOptions = MarkdownOptions()
markdownOptions.SavePicInRelativePath = False
markdownOptions.SaveHyperlinkAsRef = False
workbook.SaveToMarkdown(outputFile, markdownOptions)
workbook.Dispose()

workbook = Workbook()
workbook.LoadFromFile(inputFile)
wb.SaveToFile("out.xlsx", ExcelVersion.Version2010);

class MyPdfCustomAppearance(IPdfSignatureAppearance):
    def __init__(self):
        pass

    def Generate(self, g: PdfCanvas):
        x = 0.0
        y = 0.0
        fontSize = 10.0
        font = PdfTrueTypeFont("SimSun", fontSize, PdfFontStyle.Regular, True)
        lineHeight = fontSize
        image = PdfImage.FromFile(inputImage)
        g.DrawImage(image, x, y)
        x = float(image.Width)
        g.DrawString("Signer: Gary", font, PdfBrushes.get_Red(), PointF(x, y))
        y += lineHeight + 5
        g.DrawString("Phone: +86 12345678", font, PdfBrushes.get_Black(), PointF(x, y))
        y += lineHeight + 5
        g.DrawString("Address: Sichuan Province, China", font, PdfBrushes.get_Black(), PointF(x, y))

doc = PdfDocument()
doc.LoadFromFile(inputFile)
signatureMaker = PdfOrdinarySignatureMaker(doc, inputFile_pfx, "e-iceblue")
my_appearance = MyPdfCustomAppearance()
customAppearance = PdfCustomAppearance(my_appearance)
signatureMaker.MakeSignature("Signer", doc.Pages.get_Item(0), 90.0, 550.0, 270.0, 640.0, customAppearance)
doc.SaveToFile(outputFile)

PdfDocument doc = new PdfDocument();
doc.LoadFromFile(inputFile);
// Define a rectangle
RectangleF rctg = new RectangleF(0, 0, 200, 300);
var page = doc.Pages[0];
PdfTextFinder finder = new PdfTextFinder(page);
finder.Options.Parameter = TextFindParameter.None;
finder.Options.Area = rctg;
// Find text within the rectangle
List<PdfTextFragment> findouts = finder.FindAllText();            
StringBuilder sb = new StringBuilder();
foreach (PdfTextFragment find in findouts)
{
    sb.AppendLine(find.Text);
    sb.AppendLine(find.TextStates[0].FontName);
    sb.AppendLine(find.TextStates[0].FontSize.ToString("F2"));
}
File.WriteAllText(outputFile, sb.ToString());

textReplacer.ReplaceText("Text", "Replace", Color.get_Blue())

def _run_ai_test(self):
    filename = "1.png"
    output_file = "scan.txt"
    file_path = r"F:\3.3.0AI\AI\ocr.xml"
    model = "AIModel"
    api_key = "ApiKey"
    api_url = "ApiUrl"
    self._update_ocr_config(file_path, model, api_key, api_url)
    self._scan_img(filename, output_file)


def _scan_img(self, filename, output_file):
    scanner = OcrScanner()
    configure_options = ConfigureOptions()
    configure_options.ModelPath = r"F:\3.3.0AI\AI"
    configure_options.Language = "Japanese"
    scanner.ConfigureDependencies(configure_options)
    scanner.Scan(filename)

    text = scanner.Text.ToString()
    with open(output_file, "w", encoding="utf-8") as f:
        f.write(text)


def _update_ocr_config(self, file_path, model, api_key, api_url):
    tree = ET.parse(file_path)
    root = tree.getroot()

    model_node = root.find('./configs/model')
    api_key_node = root.find('./configs/apiKey')
    api_url_node = root.find('./configs/apiUrl')

    if model_node is not None:
        model_node.text = model
    if api_key_node is not None:
        api_key_node.text = api_key
    if api_url_node is not None:
        api_url_node.text = api_url

    tree.write(file_path, encoding='utf-8', xml_declaration=True)
    print("XML updated successfully！")

class CustomProgressNotifier implements IProgressNotifier {
    StringBuilder str = new StringBuilder();
    private String outputFile;

    public CustomProgressNotifier(String outputFile) {
        this.outputFile = outputFile;
    }

    @Override
    public void notify(float progress) {
        str.append("==============Progress: ").append(progress).append("%==============\n");
        try {
            Files.writeString(Paths.get(outputFile), str.toString());
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

//using 
PdfDocument pdf=new PdfDocument();
pdf.loadFromFile("test.pdf");
pdf.registerProgressNotifier(new CustomProgressNotifier("Progress.txt"));
pdf.saveToFile("out.docx", FileFormat.DOCX);
pdf.dispose();

PdfDocument pdf = new PdfDocument();
pdf.LoadFromFile(inputFile);

X509Certificate2 cert = new X509Certificate2(inputFile_pfx, "e-iceblue");
IPdfSignatureFormatter formatter = new PdfPKCS7Formatter(cert, false);
PdfMDPSignatureMaker pdfMDPSignatureMaker = new PdfMDPSignatureMaker(pdf, formatter);
PdfSignature signature = pdfMDPSignatureMaker.Signature;
signature.Name = "e-iceblue";
signature.ContactInfo = "028-81705109";
signature.Location = "chengdu";
signature.Reason = " this document";

PdfSignatureAppearance appearance = new PdfSignatureAppearance(signature);
appearance.NameLabel = "Signer: ";
appearance.ContactInfoLabel = "ContactInfo: ";
appearance.LocationLabel = "Loaction: ";
appearance.ReasonLabel = "Reason: ";
pdfMDPSignatureMaker.MakeSignature("signName", pdf.Pages[0], 100, 100, 250, 200, appearance);
foreach (HashAlgorithmType hashAlgorithmType in Enum.GetValues(typeof(HashAlgorithmType)))
{
    if (string.Equals(hashAlgorithmType.ToString(), "SM3", StringComparison.OrdinalIgnoreCase))
    {
        continue;
    }
    //default value of HashAlgorithm is SHA256
    formatter.Properties.HashAlgorithm = hashAlgorithmType;
    try
    {
        pdf.SaveToFile( "out.pdf", FileFormat.PDF);
    }
    catch (Exception ex)
    {
        Console.WriteLine($"error：{ex.Message}");
    }
}
pdf.Dispose();

ToPdfParameterList.IsAtlast-->ToPdfParameterList.IsAtLeast

Document doc = new Document();
doc.LoadFromFile(inputFile);
int count = 1;
foreach (Section sec in doc.Sections)
{
    foreach (Spire.Doc.Documents.Paragraph paragraph in sec.Paragraphs)
    {
        foreach (DocumentObject obj in paragraph.ChildObjects)
        {
            if (obj is ShapeObject shape)
            {
                Chart chart = shape.Chart;
                if (chart == null)
                    continue;

                string fileName = Path.Combine(outputPath, $"{count}.crtx");
                chart.SaveAsTemplate(fileName);
                count++;
            }
        }
    }
}

string genName = "Testing For Set Producer";
 Document doc = new Document();
 doc.LoadFromFile(filename);
 ToPdfParameterList toPdf = new ToPdfParameterList();
 toPdf.GeneratorName = genName;
 doc.SaveToFile("result.pdf", toPdf);

Document doc = new Document();
doc.LoadFromFile(inputFile);
StringBuilder sb = new StringBuilder();
int number = 1;

foreach (Section sec in doc.Sections)
{
    foreach (Paragraph paragraph in sec.Paragraphs)
    {
        for (int i = 0; i < paragraph.ChildObjects.Count; i++)
        {
            DocumentObject obj = paragraph.ChildObjects[i];
            if (obj is ShapeObject)
            {
                ShapeObject shape = obj as ShapeObject;
                Chart chart = shape.Chart;
                sb.Append("\r\n\r\nPage " + number + ":\r\n" + "Get all X-axis data: ");
                for (int x = 0; x < chart.XValues.Count; x++)
                {
                    ChartValue xVal = chart.XValues[x];
                    // Get all X-axis data values
                    sb.Append(xVal.StringValue + " "); 
                }
                // Get the first series
                ChartSeries series = chart.Series[0]; 
                sb.Append("\r\nGet Y-axis data: ");
                foreach (ChartValue yVal in series.YValues)
                {
                    // Get all Y-axis data values of the first series
                    sb.Append(yVal.Value + " ");  
                }
            }
        }
    }
    number++;
}

Document doc = new Document();
foreach (ChartDataLabelPosition position in Enum.GetValues(typeof(ChartDataLabelPosition)))
{
    Section section = doc.AddSection();
    section.AddParagraph().AppendText(position.ToString());
    Spire.Doc.Documents.Paragraph newPara = section.AddParagraph();
    ShapeObject shape = newPara.AppendChart(ChartType.Pie, 500, 300);
    Chart chart = shape.Chart;
    chart.Series[0].HasDataLabels = true;
    chart.Series[0].DataLabels.ShowCategoryName = true;
    chart.Series[0].DataLabels.ShowValue = true;
    // Set position
    chart.Series[0].DataLabels.Position = position;

    ShapeObject shape2 = newPara.AppendChart(ChartType.Bubble, 500, 300);
    Chart chart2 = shape2.Chart;
    chart2.Series[0].HasDataLabels = true;
    chart2.Series[0].DataLabels.ShowCategoryName = true;
    chart2.Series[0].DataLabels.ShowValue = true;
    chart2.Series[0].DataLabels.Position = position;
}
doc.SaveToFile(outputFile, FileFormat.Docx);
doc.Dispose();

 Document doc1 = new Document();
            doc1.LoadFromFile(inputFile_1);
            Document doc2 = new Document();
            doc2.LoadFromFile(inputFile_2);

            CompareOptions options = new CompareOptions();
            options.CompareMoves = false;
            options.IgnoreCaseChanges = false;
            options.IgnoreComments = true;
            options.IgnoreFields = true;
            options.IgnoreFootnotes = true;
            options.IgnoreTables = true;
            options.IgnoreTextboxes = true;
            doc1.Compare(doc2, "user", new DateTime(), options);

            doc1.SaveToFile(outputFile, FileFormat.Docx2013);

Presentation ppt = new Presentation();
            ppt.LoadFromFile(inputFile);
            SaveToVideoOption saveOption = new SaveToVideoOption(ffmpegDir);
            ppt.SaveToVideoOption=saveOption;//Default: 5 seconds per slide.
            ppt.SaveToFile(outputFile_mp4, FileFormat.MP4);
            ppt.SaveToFile(outputFile_wmv, FileFormat.WMV);
            ppt.Dispose();

Document doc = new Document();
        doc.loadFromFile(inputFile);
        int count = 1;
        for (Section sec : (Iterable) doc.getSections()) {
            for (Paragraph paragraph : (Iterable) sec.getParagraphs()) {
                for (int i = 0; i < paragraph.getChildObjects().getCount(); i++) {
                    DocumentObject obj = paragraph.getChildObjects().get(i);
                    if (obj instanceof ShapeObject) {
                        ShapeObject shape = (ShapeObject) obj;
                        Chart chart = shape.getChart();
                        String fileName = outputFile + count + ".crtx";
                        chart.saveAsTemplate(fileName);
                        count++;
                    }
                }
            }
        }

Document doc = new Document();
doc.loadFromFile(inputFile);
StringBuilder sb = new StringBuilder();
int pageNumber = 1;
for (Section sec : (Iterable) doc.getSections()) {
    for (Paragraph paragraph : (Iterable) sec.getParagraphs()) {
        for (int i = 0; i < paragraph.getChildObjects().getCount(); i++) {
            DocumentObject obj = paragraph.getChildObjects().get(i);
            if (obj instanceof ShapeObject) {
                ShapeObject shape = (ShapeObject) obj;
                Chart chart = shape.getChart();
                sb.append("\r\n\r\nPage " + pageNumber + ":\r\n" + "All X-axis data: ");
                for(int x = 0; x < chart.getXValues().getCount(); x++){
                    // Print all X-axis data values
                    ChartValue xVal = chart.getXValues().get(x);
                    sb.append(xVal.getStringValue() + " ");
                }
                ChartSeries series = chart.getSeries().get(0);
                sb.append("\r\nY-axis data: ");
                // Print all Y-axis data values of the first series
                for(ChartValue yVal : (Iterable<ChartValue>)series.getYValues()){
                    sb.append(yVal.getValue() + " ");
                }
            }
        }
    }
    pageNumber++;
}

Document doc = new Document();
for (ChartDataLabelPosition position : ChartDataLabelPosition.values()) {
    Section section = doc.addSection();
    section.addParagraph().appendText(position.name());
    Paragraph newPara = section.addParagraph();
    ShapeObject shape = newPara.appendChart(ChartType.Pie, 500, 300);
    Chart chart = shape.getChart();
    chart.getSeries().get(0).hasDataLabels(true);
    chart.getSeries().get(0).getDataLabels().setShowCategoryName(true);
    chart.getSeries().get(0).getDataLabels().setShowValue(true);
    chart.getSeries().get(0).getDataLabels().setPosition(position);
    ShapeObject shape2 = newPara.appendChart(ChartType.Bubble, 500, 300);
    Chart chart2 = shape2.getChart();
    chart2.getSeries().get(0).hasDataLabels(true);
    chart2.getSeries().get(0).getDataLabels().setShowCategoryName(true);
    chart2.getSeries().get(0).getDataLabels().setShowValue(true);
    chart2.getSeries().get(0).getDataLabels().setPosition(position);
}
doc.saveToFile(outputFile, FileFormat.Docx);

Document doc = new Document();
        doc.loadFromFile(inputFile);
        int count = 1;
        for (Section sec : (Iterable) doc.getSections()) {
            for (Paragraph paragraph : (Iterable) sec.getParagraphs()) {
                for (int i = 0; i < paragraph.getChildObjects().getCount(); i++) {
                    DocumentObject obj = paragraph.getChildObjects().get(i);
                    if (obj instanceof ShapeObject) {
                        ShapeObject shape = (ShapeObject) obj;
                        Chart chart = shape.getChart();
                        String fileName = outputFile + count + ".crtx";
                        chart.saveAsTemplate(fileName);
                        count++;
                    }
                }
            }
        }

Document doc = new Document();
doc.loadFromFile(inputFile);
StringBuilder sb = new StringBuilder();
int pageNumber = 1;
for (Section sec : (Iterable) doc.getSections()) {
    for (Paragraph paragraph : (Iterable) sec.getParagraphs()) {
        for (int i = 0; i < paragraph.getChildObjects().getCount(); i++) {
            DocumentObject obj = paragraph.getChildObjects().get(i);
            if (obj instanceof ShapeObject) {
                ShapeObject shape = (ShapeObject) obj;
                Chart chart = shape.getChart();
                sb.append("\r\n\r\nPage " + pageNumber + ":\r\n" + "All X-axis data: ");
                for(int x = 0; x < chart.getXValues().getCount(); x++){
                    // Print all X-axis data values
                    ChartValue xVal = chart.getXValues().get(x);
                    sb.append(xVal.getStringValue() + " ");
                }
                ChartSeries series = chart.getSeries().get(0);
                sb.append("\r\nY-axis data: ");
                // Print all Y-axis data values of the first series
                for(ChartValue yVal : (Iterable<ChartValue>)series.getYValues()){
                    sb.append(yVal.getValue() + " ");
                }
            }
        }
    }
    pageNumber++;
}

Document doc = new Document();
for (ChartDataLabelPosition position : ChartDataLabelPosition.values()) {
    Section section = doc.addSection();
    section.addParagraph().appendText(position.name());
    Paragraph newPara = section.addParagraph();
    ShapeObject shape = newPara.appendChart(ChartType.Pie, 500, 300);
    Chart chart = shape.getChart();
    chart.getSeries().get(0).hasDataLabels(true);
    chart.getSeries().get(0).getDataLabels().setShowCategoryName(true);
    chart.getSeries().get(0).getDataLabels().setShowValue(true);
    chart.getSeries().get(0).getDataLabels().setPosition(position);
    ShapeObject shape2 = newPara.appendChart(ChartType.Bubble, 500, 300);
    Chart chart2 = shape2.getChart();
    chart2.getSeries().get(0).hasDataLabels(true);
    chart2.getSeries().get(0).getDataLabels().setShowCategoryName(true);
    chart2.getSeries().get(0).getDataLabels().setShowValue(true);
    chart2.getSeries().get(0).getDataLabels().setPosition(position);
}
doc.saveToFile(outputFile, FileFormat.Docx);