•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Using R / Python / Julia functions directly inside Excel (working prototype)
Our take
Introducing an innovative Excel add-in that empowers users to seamlessly integrate R, Python, or Julia functions directly within their spreadsheets. With this prototype, you can pass Excel ranges into your chosen programming language, execute code, and return results—whether values, arrays, or plots. For instance, use `=REval("mean(c(1,2,3,4))")` for statistical calculations or `=RPlot("plot(c(1,2,3,4))", "test", 800, 600)` to create visualizations. This tool expands Excel's capabilities, making
I’ve been working on an Excel add-in that lets you call R, Python, or Julia functions directly from Excel cells.
Basic idea:
- Pass Excel ranges into the function
- Run code in R / Python / Julia
- Return results (values, arrays, or plots)
A few examples:
Run R code
=REval("mean(c(1,2,3,4))")
Create a plot
=RPlot("plot(c(1,2,3,4))", "test", 800, 600)
It also works with multiple data series and more complex code (e.g., ggplot).
You can always copy/paste between tools — the goal here is just to extend Excel a bit and make it easier to test or plug in new functionality.
Repo:
https://github.com/amoynahan/ExcelBridgeSuite
If anyone tries it, I’d be interested in what works, what breaks, or what’s confusing.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#no-code spreadsheet solutions#rows.com#data visualization tools#data analysis tools#big data management in spreadsheets#self-service analytics tools#generative AI for data analysis#conversational data analysis#business intelligence tools#collaborative spreadsheet tools#real-time data collaboration#financial modeling with spreadsheets#intelligent data visualization#enterprise data management#big data performance#data cleaning solutions#Excel