How to Use the Scripting API
Meet DataStripes
DataStripes is more than a spreadsheet—it's a platform for building, automating, and extending your data workflows. With the Scripting API, you can automate tasks, build custom widgets, and connect your sheets to the outside world using TypeScript or JavaScript. If you love to code (or want to learn), this is your playground!
Before you start, make sure you’re set up:
Overview
The Scripting API in DataStripes allows you to automate workflows, build custom widgets, and extend spreadsheet functionality using TypeScript/JavaScript. Access and manipulate data, trigger actions, and integrate external libraries.
Getting Started
- Open the script editor or create a new custom widget from the App Builder. +- Use the global appApi object to interact with your spreadsheet. Example:
+js +// Read a cell value +const value = await appApi.getCell('Sheet1', 'A1'); +// Write a value +await appApi.setCell('Sheet1', 'B2', 42); +// Get a range +const data = await appApi.getRange('Sheet1', 'A1:C10'); +
- Use CDN libraries (e.g., Chart.js, Leaflet) in custom widgets for advanced visualizations.
- Save and run your script or widget to see results in real time.
Tips & Best Practices
- Explore the scripting API documentation for all available methods.
- Use async/await for smooth data operations.
- Combine scripting with widgets for powerful custom dashboards.
- Test scripts on sample data before applying to production sheets.
The Scripting API unlocks advanced automation and customization—making DataStripes a true power tool for data-driven teams!
Ready to get started? Log in to DataStripes or visit our help center for more tips and support.