I use Spreadsheet Streaming to Export large Kendo MVC Grid Data - it works great except the Format of the CSV - how to Change the Delimiter, Quote or Encoding of the CSV Export?
robert
2 Answers, 1 is accepted
0
Peshito
Telerik team
answered on 31 May 2017, 07:21 AM
Hi Robert,
Currently the RadSpreadStreamProcessing does not provide this features. There is a feature request logged in our feedback portal regarding the ability for changing the delimiter and quote symbols.
As for changing the encoding I have logged a new featured request. In order to raise its priority and track its progress please use this link.
The CSV file format is not fully standardized. The basic idea of separating fields with a comma is clear, but that idea gets complicated when the field data may also contain commas or even embedded line-breaks. CSV implementations may not handle such field data, or they may use quotation marks to surround the field. Quotation does not solve everything: some fields may need embedded quotation marks, so a CSV implementation may include escape characters or escape sequences.