python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - office-scripts

connection to SQL database with Office script

is it possible to make a connection between Office 365 to SQL database using Office scripts? something simillar to ADODB.Connection in Excel VBA
test-img

Hamtash

excel

office-scripts

Votes: 0

Answers: 1

Latest Answer

You can't connect directly to a database using Office Scripts. You can still get data from a database but the process would need to be a bit different: Instead of querying a database directly, the da...
test-img

Brian Gonzalez

TypeScript: Code to sum values in one column based on the value in another column in Excel

I am new to TypeScript and my goal today, would be to sum up all the cell values in a column in an Excel file, based on the cell values in an another column. In my Excel file I have the calendar weeks...
test-img

Mateusz Woś

typescript

onedrive

office-scripts

excel-online

Votes: 0

Answers: 1

Latest Answer

You can give the code below a try. It starts by getting the ranges for column U and column R for a specific sheet. Once it has the ranges, it gets the values associated with those ranges. After we hav...
test-img

Brian Gonzalez

Excel script run from Power Automate. Formula doesn't update

Power Automate runs the script every day (08:00). In this script I compare the current date with another date (column C). This check is done by the formula. The result is placed in column D. The final...
test-img

Ferdinando

excel

excel-formula

auto-update

power-automate

office-scripts

Votes: 0

Answers: 0

Office Scripts - AutoFill

I am trying to make the column next to another one filled with zeroes when there are values in the column next to it. They become endless though and just go on to infinity. Does anyone know how to mak...
test-img

Rosenz5

office-scripts

Votes: 0

Answers: 1

Latest Answer

Here's a script that does this using autofill: function main(workbook: ExcelScript.Workbook) { let selectedSheet: ExcelScript.Worksheet = workbook.getActiveWorksheet(); selectedShe...
test-img

Brian Gonzalez

Posts

Questions

Blogs

Jobs