QUESTION: Read from Stream

[stugorf]

I want to read an Excel file from an AWS S3 bucket without downloading it. This is how I normally read a file from a stream. Can ExcelReaders.jl read from a stream?

file_content = S3.get_object(aws, get_config);
load(file_content, "Sheet1") |> DataFrame

Thank you.

[davidanthoff]

I'm afraid not. I don't think the underlying Python xlrd library that we use supports it...

We are working on a new package that uses the libxls library to read legacy excel files, and I think that package actually supports parsing from in-memory buffers...

I'm pretty sure we won't add this ability to ExcelReaders.jl, so I'm just going go move this issue over to LibXls.jl, and maybe we can sort it out there eventually.

[stugorf]

Thank you. I'll keep an out out for a release of LibXls.jl

[stugorf]

Being able to do something like this would be great when working with Excel from AWS S3:

Read from AWS S3 file stream
df = load(IOBuffer(file_content)) |> DataFrame;