XLSX.jl

XLSX.jl copied to clipboard

it would be nice to be able to index into `TableRow`s and `SheetRow`s with a range or vector of integers, like one can do with normal Vectors. ``` julia> mydata...

bjarthur

Hi, I would like to suggest, as an improvement for the future, to add a way to delete a sheet from an already existing Excel file. Thank you in advance!

ale111111

writetable should be able to write to IO. Use case: Create XLSX using HTTP and download the file not saving to disk.

AntonioLoureiro

support reading from IO as well as a file path

2

If I have an an excel document in an IO Buffer (e.g. `Downloads.download` to an IOBuffer, not a file) it would be good to be to open this directly, and...

tecosaur

add colon indexing

2

fix #215

BeastyBlacksmith

I don't think it is currently possible to use the colon to extract rows/ columns from a worksheet. We,d need ```julia getdata(::XLSX.Worksheet, ::Colon, ::Integer) getdata(::XLSX.Worksheet, ::Integer, ::Colon) ``` for that.

BeastyBlacksmith

Document CellRef

1

Users have to create `CellRef` objects to pass an `anchor_cell`, but the convenient integer and macro constructors are fairly hidden. Most of the documentation was already there as a comment,...

nathanrboyer

Hey, excellent package you have here. I was experimenting with it and using this example from the docs. ``` julia> using Dates julia> import DataFrames, XLSX julia> df = DataFrames.DataFrame(integers=[1,...

drizk1

Delete Worksheet from xlsx File

1

As workaround for this issue ` https://github.com/felipenoris/XLSX.jl/issues/80`. Two functions were created that operate based on either the sheet's name or its ID. These functions will generate a new file while...

KamalJourieh

Hi, I am currently using this library to read an Excel sheet. Now, I would like to read a password-protected Excel file, is there any way to do this? Currently...

darrencl