Insert data of Excel into Document or PowerPoint at particular Page or Slide

Docs API
,
2

Hello @qwert12345
I believe you can achieve desired scenario with DocBuilder. I have recorded my test, please take a look at it:Monosnap

Sample of my docbuilder script:

builder.OpenFile("path_to_file\file.xlsx");
var oWorksheet = Api.GetActiveSheet();
var oRange = oWorksheet.GetRange("A1:C4");
var text = oRange.GetText();
GlobalVariable["1"] = text
builder.CloseFile();

builder.CreateFile("docx");
var text = GlobalVariable["1"];
var oDocument = Api.GetDocument();
var oParagraph = oDocument.GetElement(0);
oParagraph.AddText("Data from xlsx file: " + text);
builder.SaveFile("docx", "path_to_file\newfile.docx");
builder.CloseFile();

Links for reference:
https://api.onlyoffice.com/docbuilder/howitworks/globalvariable
https://api.onlyoffice.com/docbuilder/spreadsheetapi/apirange/gettext
https://api.onlyoffice.com/docbuilder/textdocumentapi/apirange/addtext

1 Like