You can use Microsoft Graph to allow web and mobile applications to read and modify Excel workbooks stored in OneDrive for Business, SharePoint site or Group drive.
Adds rows to the end of specific table. See the documentation
Write custom Node.js code and use any of the 400k+ npm packages available. Refer to the Pipedream Node docs to learn more.
Update the properties of tablerow object. (Only for work or school account)
See the documentation
The Microsoft Excel API on Pipedream allows you to automate spreadsheet tasks, manipulate data, and integrate Excel with other apps and services. Through Pipedream, you can create serverless workflows that react to events, perform operations on Excel files like reading, writing, updating cells, and managing worksheets. This API turns Excel into a powerful tool for data analysis, report generation, and task automation without manual intervention.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
microsoft_excel: {
type: "app",
app: "microsoft_excel",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://graph.microsoft.com/v1.0/me`,
headers: {
Authorization: `Bearer ${this.microsoft_excel.$auth.oauth_access_token}`,
},
})
},
})
Develop, run and deploy your Node.js code in Pipedream workflows, using it between no-code steps, with connected accounts, or integrate Data Stores and File Stores.
This includes installing NPM packages, within your code without having to manage a package.json
file or running npm install
.
Below is an example of installing the axios
package in a Pipedream Node.js code step. Pipedream imports the axios
package, performs the API request, and shares the response with subsequent workflow steps:
// To use previous step data, pass the `steps` object to the run() function
export default defineComponent({
async run({ steps, $ }) {
// Return data to use it in future steps
return steps.trigger.event
},
})