reaper-datasource

reaper-datasource is a REAPER extension for script developers. It reads spreadsheets and delimited files natively and hands the contents to Lua, EEL, or Python as ordinary ReaScript API functions — no backend service, no temp files, no polling.

It reads .xlsx, .xlsm, .xlsb, .xls, .ods, .csv, and .tsv. Everything arrives as sheets of rows of string cells; a CSV is simply a workbook with one sheet, named after the file.

Using it

Parse a whole file in one call:

local ok, result = reaper.DataSource_Parse("/path/to/book.xlsx", "")
if not ok then
  reaper.ShowConsoleMsg("parse failed: " .. result .. "\n")
  return
end
-- result is JSON: every sheet, with its dimensions, hidden rows, and cells

Or open a file once and ask for only what you need — useful for previews, single columns, and reactive UIs. Sheets load lazily and stay cached on the handle:

local src = reaper.DataSource_Open("/path/to/book.xlsx")
local ok, rows = reaper.DataSource_GetRows(src, "Sheet1", 1, 20)
local ok, cell = reaper.DataSource_GetCell(src, "Sheet1", 2, 3)
reaper.DataSource_Close(src)

Rows and columns are 1-based. Hidden rows are reported for .xlsx and .xlsm workbooks, so a script can respect what the spreadsheet’s author chose to hide. Handles aren’t garbage-collected — close them when you’re done.

The full API reference is in the README, and reaper.DataSource_OpenDocs() opens the copy that ships with the extension.

Installing

  1. In REAPER, open Extensions → ReaPack → Import repositories…
  2. Paste https://github.com/TeamAudio/reascripts/raw/main/index.xml
  3. Find reaper-datasource in the package browser, install it, and restart REAPER.

Builds are also attached to the GitHub releases if you’d rather copy the library into REAPER’s UserPlugins folder yourself.