XLSX.jl
XLSX.jl copied to clipboard
Excel file reader and writer for the Julia language.
When a time of “2023-07-11 0:00” is read it returns a type of Date instead of DateTime. Please see the [link ](https://discourse.julialang.org/t/xlsx-parsing-datetime/103071/1)for more information.
Some formulas appear as empty strings. This is the case when Excel saves a worksheet using shared formulas. Example: ``` 1020 100D4+E3110 E4+F3130 200 D5+E4310 440 ```
I know how to create number formats as in: ``` currencyfmt = XLSX.styles_add_numFmt(wb, "\$#,0.00;(\$#,0.00)") currencystyle = XLSX.styles_add_cell_xf( wb, Dict("applyNumberFormat" => "2", "numFmtId" => "$currencyfmt") ) ``` After using something like...
In my Excel file is one cell in column "C" with the following value: -5,01085245571595E-09 And this results in the error message: ERROR: Styles not found for this workbook. [foo.xlsx](https://github.com/felipenoris/XLSX.jl/files/11849555/foo.xlsx)
```julia using XLSX using DataFrames XLSX.writetable("foo.xlsx", "TABLE" => DataFrame(A=rand(3), B=["foo","bar","baz"])) xlsx = XLSX.readxlsx("foo.xlsx") XLSX.eachtablerow(xlsx["TABLE"]) |> DataFrame ``` ```julia 3×2 DataFrame Row │ A B │ Any Any ─────┼─────────────── 1 │...
I'd like to propose a simplified way to setting a cell formula. I see that in #120 the proposed way to set a cell formula is to do ```julia sheet["A1"]...
Hi I am trying to extract the formula form a cell which links to an external file. Is there any way that I can get the link of [1] in...
In this Excel file from https://journals.plos.org/ploscompbiol/article?id=10.1371/journal.pcbi.1005697#sec020, all sheets are shown as 1x1, even though they are 17x16: [MUestimates_all_locations_1.xlsx](https://github.com/felipenoris/XLSX.jl/files/10539284/MUestimates_all_locations_1.xlsx)
Float (currency) is returned as DateTime value by `getdata` see attached file ``` using XLSX fi = raw"C:\temp\currency.xlsx" xf = XLSX.readxlsx(fi); sheetname = XLSX.sheetnames(xf)[1] sheet = xf[sheetname] cells = XLSX.getcellrange(sheet,"A1:A1")...
I tried different approaches to specify a numerical format with 4 decimal places of all the cells in an Excel sheet generated using XLSX. None of them worked. Any suggestions?