pgs62 / juliaexcel.jl Goto Github PK

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.

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

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":

• Launch Windows Terminal from the start menu.
• Ctrl, (Control plus comma) to see the Settings screen.
• In the "Startup" section select "Windows Console Host" as the "Default terminal application".
• Click "Save".
• Test thatJuliaLaunch 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

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 :)

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\

for use Polynomials need run julia as admin
ex:
using Polynomials
roots(Polynomial([-217278611278.223,216881804.392203,-32054.2403628118,1]))