How we can write delimiter like sep=, using CsvHelper library?
user3473830
we're using CsvHelper library to export some information from our application, our clients normally use Excel to see the results
(sample of correctly opened data)
everything was working well until I tested my generated files in another machine with Format set on German(Austria) which I found out that excel would not parse it correctly anymore which is understandable because , has a different meaning in this format. 
adding sep=, in the first line seems to fix the issue, but I couldn't find in CsvHelper documents that How we can achieve this. so the question is
How we can write delimiter like sep=, or anything with similar effect using CsvHelper library?
xanatos
Inside the CsvWriter class there is an aptly named WriteExcelSeparator() that should do it.
Depending on how you use the library, you can even:
csv.Configuration.Delimiter = ",";
csv.Configuration.HasExcelSeparator = true;
If you use the WriteRecords, use the second way, while if you use WriteHeader/WriteRecord use the first one.
csv.WriteExcelSeparator();
csv.WriteHeader<Simple>();
csv.WriteRecord( record );
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Websphere MQ as a data source for Apache Spark Streaming
- Next: AngularJS ng-bind with a function
Related
TOP Ranking
- 1
pump.io port in URL
- 2
Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)
- 3
Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background
- 4
How to import an asset in swift using Bundle.main.path() in a react-native native module
- 5
Failed to listen on localhost:8000 (reason: Cannot assign requested address)
- 6
Spring Boot JPA PostgreSQL Web App - Internal Authentication Error
- 7
ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3
- 8
Using Response.Redirect with Friendly URLS in ASP.NET
- 9
Can a 32-bit antivirus program protect you from 64-bit threats
- 10
Double spacing in rmarkdown pdf
- 11
How to fix "pickle_module.load(f, **pickle_load_args) _pickle.UnpicklingError: invalid load key, '<'" using YOLOv3?
- 12
3D Touch Peek Swipe Like Mail
- 13
Bootstrap 5 Static Modal Still Closes when I Click Outside
- 14
Assembly definition can't resolve namespaces from external packages
- 15
Vector input in shiny R and then use it
- 16
Emulator wrong screen resolution in Android Studio 1.3
- 17
Svchost high CPU from Microsoft.BingWeather app errors
- 18
Graphics Context misaligned on first paint
- 19
Python connect to firebird docker database
- 20
Is this docker-for-mac password dialog legit?
- 21
How to save models trained locally in Amazon SageMaker?
Comments