Search results for query: *

Unfortunately I still get errors like: "Sheet2.ChartObjects is not a function clientRequestId". Anyway you have been really helpful even if I was totally offtopic. thanks a lot!

I tried this way: function main(workbook: ExcelScript.Workbook) { declare function require(name: string); const fs = require('fs'); let Sheet2 = workbook.getWorksheet("Sheet2"); var rang = Sheet2.Range("J2: Q16"); var ch = Sheet2.ChartObjects().Add(rang.Left + rang.Width, rang.Top...

thanks for the clarifications, but it gives me an error on line 2 could be changed to: const fs = require('fs');

Ok I didn't mean to create confusion, however if it helps I am using office script from excel online.

sorry unfortunately I don't have much familiarity with vbscript, but I'm trying to do it. I stopped here: function main(workbook: ExcelScript.Workbook) { let Sheet2 = workbook.getWorksheet("Sheet2"); var rang = Sheet2.Range("J2:Q15"); var ch = Sheet2.ChartObjects().Add(rang.Left +...

thanks for the answer but I get the following error: ';' expected. Workbook.Sheets("Sheet2").Shapes("Chart2").Chart.Export

I would like to simply export chart 2 from sheet 2 by converting it to an image format and save it in the same sharepoint directory.

same problem using "Dim

hello everyone. I am trying to create a script that extracts the chart (in jpg) from excel in sheet 2. I need this to create a flow via power automate to populate a word document in sharepoint with the extracted chart. I'm currently using this script but without results: // Get chart 1 from...