search

PydPiper / pylightxl

A light weight, zero dependency, minimal functionality excel read/writer python library
https://pylightxl.readthedocs.io
MIT License
290 stars 47 forks source link

Writing Excel to File Object #68

Open tbc399 opened 2 years ago

tbc399 commented 2 years ago

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.

PydPiper commented 1 year ago

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.

tbc399 commented 1 year ago

@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.