xlsx
xlsx copied to clipboard
qrilka
Simple and incomplete Excel file parser/writer
Hello, in my other PRs I've tried to run `stylish-haskell` but it did incur massive changes over all the sources. Would you like a PR for this?
Allow parsing and managing the visibility of sheets. I've tried to be as conservative as possible but perhaps `xlSheets` would benefit from having it's own ADT rather than expanding sheets...
The reason is that excell claims the worksheet "may contain a virus" if it detects this. Excell validator explain this: ``` File: xlsx/avy.xlsx Error: The attribute 'name' has invalid value...
This PR closes #142. `formatWorkbook` accumulates cell merge information (`_formattingMerges`) along with style information as it iterates over a list of worksheet data. Indeed, this is necessary for `formatCell` to...
My comment at verbatim: ``` To validate the result is correct xml: @ docker run -v $(pwd):/app/xlsx-validator/xlsx -it vindvaki/xlsx-validator xlsx-validator xlsx/yourfile.xlsx @ TODO: package that program for nix and make...
This will allow us to create [smart constructors](https://kowainik.github.io/posts/haskell-mini-patterns) that check for values < 1. These causes issues in excel (nasty warnings which give users the impression they're being hacked!) Furthermore...
When using [`Codec.Xlsx.Formatted.formatWorkbook`](https://hackage.haskell.org/package/xlsx-0.8.4/docs/Codec-Xlsx-Formatted.html#v:formatWorkbook), it seems that the merge information is accumulating as new worksheets are added. In the below example: 1. `fcm1` has a formatted cell at `(1,1)` with `colspan`...
Is it possible to make a cell a hyperlink either to an external link or to a worksheet in the same document?
We currently have to deal with massive excel files (100 000 to millions of rows). Reading all this data into memory isn't feasible. 100 000 rows for example takes up...
If I understand the ECMA standard correctly, then a Spreadsheet contains at least one worksheet. Could we express this with types like so: ~~~~ xlSheets :: Lens' Xlsx (NonEmpty (Text,...
