pylightxl icon indicating copy to clipboard operation
pylightxl copied to clipboard

Writing Excel to File Object

Open tbc399 opened this issue 2 years ago • 2 comments

Pylightxl Version: 1.59 Python Version: 3.10.0

Summary of Feature: In light of my previous issue/request regarding reading a CSV from a file object, I noticed there doesn't appear to be a way currently to write an xl file to a file object via writexl(). I could see something like that being useful where you need to put a file out to cloud storage or even in unit testing (my current situation) where you'd need to write to something in memory.

As with my other issue, I'd be happy to take a run at this too.

tbc399 avatar Jun 01 '22 21:06 tbc399

Hey @tbc399 I was looking at this a bit more and i am not sure i understand the use-case. Writing to a memory is simply just the pylightxl database, writing a database to writexl binary is not downstream usable since its just a bunch of xml files zipped up.

PydPiper avatar Jan 01 '23 22:01 PydPiper

@PydPiper sorry for the delay. The use case I had in mind is similar to #67 where I build up a pylightxl database in memory and then I need to write it out to a FileField, for example, in order to save it out to an S3 bucket.

tbc399 avatar Feb 08 '23 16:02 tbc399