Feat: Better builder for spreadsheet - Githubissues

algoo / preview-generator

generates previews of files with cache management

https://pypi.org/project/preview-generator/

MIT License

235 stars 51 forks source link

Feat: Better builder for spreadsheet #258

Open inkhey opened 3 years ago

inkhey commented 3 years ago

Feature description and goals

Spreadsheet format (ods, xslx, etc...) and csv preview is complex as the table generated can be really big which cause:

issue with builder on too big file
issue to find a proper size for the pdf generated (there by default unlimited number of rows).

One solution may be have specific parameter for the libreoffice builder to :

refuse generate preview for too big files
force a better default format (A3 landscape) is possible ?

Another solution may be use some kind of lib to handle specific format (ods , xslx, csv are the most used):

get the number of row and column used (permit to get an idea
generate the preview from it.

A good solution may be done with:

getting information from the file with a lib
converting the file to html
convert html to pdf with a tool like weasyprint and specific treatment to get something readable.
use the pdf preview as base for image preview as we do now.