CsvHelper.Excel
CsvHelper.Excel copied to clipboard
youngcm2
Using the following code snippet to write an excel file to a memory stream. ``` csharp using var ms = new MemoryStream(); var operators = _operatorRepository.Table.Where(p=> p.ForsApiProviderId == id ).ToList();...
**Describe the bug** CsvHelper.Excel v27.2.1 is incompatable with CSVHelper v30.0.0. Specifically, some of the breaking changes in that version add: `bool LeaveOpen { get; }` to `IWriterConfiguration` and `IParserConfiguration`. This...
Hi, I would like to know if it's possible to parse a Range as it was done in Chris Rodgers parser. ExcelParser(IXLRangeBase range, CsvConfiguration configuration) It's useful in case the...
**Describe the bug** The file has 34 columns and only return 33 columns **To Reproduce** Steps to reproduce the behavior: 1. Read this file, tab "Collaterals" [Project Atlas II -...
https://github.com/youngcm2/CsvHelper.Excel/blob/0e3b33308ba72563f090e9a9b7d1036469169422/src/CsvHelper.Excel/ExcelParser.cs#L109 Would be possible to have the workbook as a property to access to their properties or methods? For example I want to get all the worksheets names or other...
Trying to use ExcelWriter.WriteRecords and I get: System.MissingMethodException: Method not found: 'Void CsvHelper.Configuration.CsvConfiguration.set_LeaveOpen(Boolean)'. at CsvHelper.Excel.ExcelWriter..ctor(Stream stream, String sheetName, CultureInfo culture, Boolean leaveOpen) **Versions (please complete the following information):** - CSVHelper:...
This was possible with original library: ``` using (var workbook = new XLWorkbook(XLEventTracking.Disabled)) { var report = workbook.AddWorksheet("Report"); using (var csv = new CsvWriter(new ExcelSerializer(report))) { csv.Configuration.RegisterClassMap(); csv.WriteRecords(output); } workbook.SaveAs(office.ReportFolder...
ExcelParser seems to support CsvConfiguration but I don't see a method to do that for writing?
So that consumers can implement progression while reading an Excel file --- This change is [](https://reviewable.io/reviews/youngcm2/csvhelper.excel/29)
Decimal numbers turn into dates if current culture uses comma (,) as decimal separator. The reason is ClosedXML and the fact that every type is converted to string before writing...
