Microsoft Excel

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.

Integrate the Microsoft Excel API with the Filter API

Setup the Microsoft Excel API trigger to run a workflow which integrates with the Filter API. Pipedream's integration platform allows you to integrate Microsoft Excel and Filter remarkably fast. Free for developers.

Continue execution if a condition Is met with Filter API on New Item Updated (Instant) from Microsoft Excel API
Microsoft Excel + Filter
 
Try it
End execution if a condition is met with Filter API on New Item Updated (Instant) from Microsoft Excel API
Microsoft Excel + Filter
 
Try it
New Item Updated (Instant) from the Microsoft Excel API

Emit new event when an item is updated.

 
Try it
Add A Worksheet Tablerow with the Microsoft Excel API

Adds rows to the end of specific table. See the documentation

 
Try it
Continue execution if a condition Is met with the Filter API

Continue workflow execution only if a condition is met

 
Try it
End execution if a condition is met with the Filter API

End workflow execution if a condition is met

 
Try it
Update Worksheet Tablerow with the Microsoft Excel API

Update the properties of tablerow object. (Only for work or school account) See the documentation

 
Try it

Overview of Microsoft Excel

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.

Connect Microsoft Excel

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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}`,
      },
    })
  },
})

Overview of Filter

The Filter API is a great way to build powerful workflows that can manipulate
and transform data. Here are some examples of what you can build using the
Filter API:

  • A workflow that transforms data from one format to another
  • A workflow that filters out data that does not meet certain criteria
  • A workflow that sorts data in a specific order
  • A workflow that calculates statistics or aggregates data
  • A workflow that combines data from multiple sources

Connect Filter

1
2
3
4
5
6
7
8
9
10
export default defineComponent({
  async run({ steps, $ }) {
    let condition = false
    if (condition == false) {
      $.flow.exit("Ending workflow early because the condition is false")
    } else {
        $.export("$summary", "Continuing workflow, since condition for ending was not met.")
    }
  },
})