Can I save an EXCEL worksheet as CSV via ClosedXML?

.net, c#, closedxml, excel

Solution

No, it is not possible directly in ClosedXML. You have to use loops or LINQ to build your own CSV file.

For example:

System.IO.File.WriteAllLines(csvFileName,
    worksheet.RowsUsed().Select(row =>
        string.Join(";", row.Cells(1, row.LastCellUsed(false).Address.ColumnNumber)
                            .Select(cell => cell.GetValue<string>()))
 ));

Problem

Is it possible to save a worksheet of a workbook as CSV via ClosedXML? For example: ``` var workbook = new XLWorkbook(fileName); IXLWorksheet worksheet; workbook.Worksheets.TryGetWorksheet(sheetName, out worksheet); ``` How to Save it as CSV?

Original source