Integrate the Microsoft Excel API with the Formatting API

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

Popular Ways to Connect Microsoft Excel with Formatting#

[Data] Convert JSON to String with Formatting API on New Item Updated (Instant) from Microsoft Excel API

Microsoft Excel + Formatting

Try it

[Data] Parse JSON with Formatting API on New Item Updated (Instant) from Microsoft Excel API

Microsoft Excel + Formatting

Try it

[Date/Time] Add/Subtract Time with Formatting API on New Item Updated (Instant) from Microsoft Excel API

Microsoft Excel + Formatting

Try it

[Date/Time] Compare Dates with Formatting API on New Item Updated (Instant) from Microsoft Excel API

Microsoft Excel + Formatting

Try it

[Date/Time] Format with Formatting API on New Item Updated (Instant) from Microsoft Excel API

Microsoft Excel + Formatting

Try it

Popular Microsoft Excel and Formatting Triggers#

New Item Updated (Instant) from the Microsoft Excel API

Emit new event when an item is updated.

Try it

Popular Microsoft Excel and Formatting Actions#

Add A Worksheet Tablerow with the Microsoft Excel API

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

Try it

[Data] Convert JSON to String with the Formatting API

Convert an object to a JSON format string

Try it

[Data] Parse JSON with the Formatting API

Parse a JSON string

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

[Date/Time] Add/Subtract Time with the Formatting API

Add or subtract time from a given input

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#

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}`,
      },
    })
  },
})

Connect Formatting#

export default defineComponent({
  async run({ steps, $ }) {
    const text = ' Hello world! ';
    return text.trim()
  },
})