XLSX.jl

XLSX.jl copied to clipboard

AssertionError when opening some (but not all) files in "rw" mode in openxlsx (no formulas present in any file)

5

When opening a file with ```Julia XLSX.openxlsx(results_path, mode="rw") do xf sheet = xf[sheet_name] # more reading functions end ``` I get ``` ERROR: AssertionError: Some internal files were not loaded...

Boxylmer

Recommended way to clear an area in an existing Excel sheet

1

What is the recommended way to clear an area in an existing Excel sheet?

Mastomaki

Multiple DataFrames in one sheet

2

I am not able to find a way to write multiple dataframes in one excel sheet. Is there any existing method that I can use for doing this?

vishalhedgevantage

Some formulas get overwritten with values when editing existing workbook

7

So formulas are lost and in their place static values remain. How to recreate: 1. In Excel, create a new workbook, enter e.g. `=SECOND(NOW())` in each cell in A1:T20, save...

bolleywall

This feels a bit verbose / hard to remember for reading a DataFrame, especially in an interactive context ``` df = DataFrame(XLSX.readtable(f, 1, infer_eltypes=true)...) ``` First, defaults that I would...

chris-b1

When the length of a sheetname is larger than 20 and it is a multibyte string, `XLSX.readxlsx` raises `StringIndexError`. ```julia julia> using XLSX f = "sample.xlsx" XLSX.readxlsx(f) XLSXFile("sample.xlsx") containing 18...

junpei-n

When reading an excel with phonetic hints (ruby) (see [sample](https://docs.microsoft.com/en-us/dotnet/api/documentformat.openxml.spreadsheet.phoneticproperties?view=openxml-2.8.1#remarks)), each `cell.value` contains a text and its phonetic text. You can check it, following ```julia # Employment Status Survey /...

junpei-n

I get a permission denied error if the excel file is open on my computer. I can only read it if I close the file. It would be nice not...

hdavid16

Support for large datasets

2

Hello! Thank you for this tool! I would like to write large datasets into Excel. Now I have a DataFrame of 5 cols and 600,000 rows and I get an...

Mastomaki

Promote mixed int/float columns to float

1

In Excel files which have decimal and round numbers in them, the round numbers are often displayed as integers unless the user deliberately adds decimal places. When these columns are...

nilshg