I don't know how you're building sb so I can't really help with that. If you already have it in one string, you'll have to first split by line breaks (possibly using csvItem.Split(Environment.NewLine)). There's no need to build the StringBuilder string if you're going to do this. But if you really need to, what I use to create Excel Sheets is EP Plus. We can use the following code to export this dataset to a CSV file called data.csv: /export dataset/ proc export data mydata outfile '/home/u13181/data. Saves only the active sheet.First of all, Excel can open CSV files natively so you really don't have to convert the file to Excel. Some versions of Excel for Mac do not recognise csv file. Saves only the active sheet.ĭata Interchange Format. When files are exported from ResRequest, the standard csv (comma separate value) export format is used. Saves a workbook as a comma-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves a workbook as a comma-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves a workbook as a comma-delimited text file for use on another Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly.

Saves a workbook as Unicode text, a character encoding standard that was developed by the Unicode Consortium. Saves a workbook as a tab-delimited text file for use on the MS-DOS operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. Saves a workbook as a tab-delimited text file for use on the Macintosh operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly.

Saves a workbook as a tab-delimited text file for use on another Microsoft Windows operating system, and ensures that tab characters, line breaks, and other characters are interpreted correctly. In the File name box, accept the suggested name or type a new name for the workbook. Note: The file formats you’ll see vary, depending on what type of sheet is active in your workbook (a worksheet, chart sheet, or other type of sheet).

Convert csv file to excel