pgs62 / juliaexcel.jl Goto Github PK
View Code? Open in Web Editor NEWCall Julia from Microsoft Excel worksheets and from VBA
License: MIT License
Call Julia from Microsoft Excel worksheets and from VBA
License: MIT License
Hi Philip.
Thanks so much for creating this. Looks like a great tool.
My Julia is located at C:\Users\l123456\AppData\Local\Julia-1.7.2\bin and so I get the error that it cant be found in subfolders of AppData\Local\Programs.
Can it be changed to search subfolders of AppData\Local\ instead of AppData\Local\Programs ?
Also the install script that copies the the ExcelAddins to C:\Users\Public\JuliaExcel is blocked on my work machine. Though I'm able to copy them manually with Admin rights. Would it be easier just to point Excel at the original versions in
C:\Users\l139418.julia\packages\JuliaExcel\BZ7cp\
im using Clipper when entry push! line return error
using Clipper
polygon = IntPoint[]
push!(polygon, IntPoint(348,257))
โ Error: Result of type Vector{IntPoint} could not be encoded for return to Excel.
โ @ JuliaExcel C:\Users\reinaldo.julia\packages\JuliaExcel\Y1cgX\src\JuliaExcel.jl:148
would you consider replacing
encode_for_xl(x::Any) = throw("Cannot encode variable of type $(typeof(x))")
with
encode_for_xl(x::Any) = "$x"
As it is, if there is one cell in a table that isn't one of the 17 or so supported types (lines 277-296), the whole table fails.
With this change - the table will be written. Any cells not of the 17 supported types will use Julia's default string display.
For example, I have code to convert a Struct to tables with 2 columns (Field Name, Field Value) but some of the Struct fields are enum
types. This isn't a supported type so causes the table to fail in Excel. With the above change the enum is printed as a string.
If Windows Terminal is installed and is the "Default terminal application" then when Julia launches, rather than being in its own window its in a tab inside the Windows Terminal application. That breaks step 2 of How JuliaExcel works probably because the code to get the window handle of Julia is returning an incorrect handle (to the parent window perhaps?). So far I've not been able to fix this.
A work-around is to make the default terminal application be "Windows Console Host":
Ctrl,
(Control plus comma) to see the Settings screen.JuliaLaunch
called from a worksheet launches Julia in a "stand-alone" window and that =JuliaEval("1+1")
works correctly.Hello,
I was following the installation steps with Excel closed. After executing JuliaExcel.installme()
. I see a message that says the Installer script has been launched, please respond to the dialogs there
. However, I see what appears to be an error message show up.
When I open excel and type =Julia
in Excel it is not recognizing the command so I assume the installation did not occur correctly.
Am I missing a step? Any other ideas why the installation would have errored?
Thanks, Chris
for use Polynomials need run julia as admin
ex:
using Polynomials
roots(Polynomial([-217278611278.223,216881804.392203,-32054.2403628118,1]))
A common setup with Excel finance libraries is to have a cell hold an object output of a calculation.
Example:
An excel range (A10:B30) stores a yield curve par rates.
A1 points to this range and stores a Julia object of the bootstrapped curve.
Trade valuations then just point to A1 to value off the curve.
(Fantastic Package btw :)
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.