matthidinger / DoddleReport

Generate custom reports (PDF, Excel, etc) from any IEnumerable datasource.
MIT License
130 stars 40 forks source link

Update DoddleReport from ClosedXML 0.68.1 to ClosedXML 0.93.1 #13

Open jzabroski opened 6 years ago

jzabroski commented 6 years ago

https://github.com/matthidinger/DoddleReport/blob/d68c344d1b012937c7ff5b9c6e9233d421d1995e/src/DoddleReport.OpenXml/packages.config#L3

jzabroski commented 6 years ago

This is really bizarre. It appears @linusNoren tried to integrate a pull request for this, but it failed in TravisCI. See: https://github.com/matthidinger/DoddleReport/pull/10#pullrequestreview-117511074

What's lame is I can't even trivially work around this by including ClosedXML after-the-fact and editing the feature I want in #14 , because I'll have two separate versions of ClosedXML in the same project:

            using (var excel = SpreadsheetDocument.Open(excelFileName, true))
            {
                var workbookPart = excel.WorkbookPart;
                workbookPart.Workbook.Sheets.FirstChild.Append(new AutoFilter()
                {
                    Reference = "C3:J" + (3 + objects.Count)
                });
                excel.Save();
            }