Stack Overflow
Stack Overflow

Questions tagged [supercsv]

Super CSV is a fast and free open-source CSV API for Java.

Super CSV is a fast and free open-source CSV API for Java, written by Kasper Graversen.

The developers of Super CSV follow this tag, so you can receive expert advice on your Super CSV problems by using this tag.

Before asking a question, check the documentation and examples on the project website.

Please note that you can also receive help at the project's GitHub site, as well as report any issues you have encountered.

Related Links:

202 questions
0
votes
1 answer

Sanitize cell values with SuperCSV

What is the best way to sanitize fields from a csv in supercsv? For example the First_Name column: trim the field, capitalize the first letter, remove various characters (quotes, commas, asterisks etc). Is it to write a custom CellProcessor like…
xref
  • 1,707
  • 5
  • 19
  • 41
0
votes
1 answer

How do I get CsvDozerBeanWriter to pull column headers from Dozer XML mapping files

I'm writing a feature to produce CSV snapshots of screen data. I need this to be data-driven. Thus I need to avoid hard-coding each snapshot in Java, but rather load it from a data source such as an XML file or a database. The data is…
DaBlick
  • 898
  • 9
  • 21
0
votes
3 answers

How to write a list to CSV with Super CSV

Exception in thread "main" org.supercsv.exception.SuperCsvException: The number of columns to be processed (229326) must match the number of CellProcessors (8): I believe i may have to redo what im doing using supercsv as it may be easier in the…
j bel
  • 153
  • 6
  • 18
0
votes
2 answers

Write file with SuperCsv preserving leading zeros while opening in excel

I was wondering if there is a way to keep the leading 0 while using SuperCsv. My problem is that I have a few columns which have numbers with leading 0. I want to keep the 0, but excel keeps stripping it, I've also tried to append a few characters…
StefanAlexandru
  • 33
  • 6
0
votes
1 answer

Super-CSV: how to do a "CSV Normalization"?

I would like to do a CSV normalization with the help of the Super-CSV-Dozer API. I have a CSV file in the form…
user2463924
  • 3
  • 2
0
votes
0 answers

supercsv is working too slow on linux machine

I am using supercsv for downloading data as csv. This is working too slow for me is takes 20 30 minutes to download data on Linux machine. CPU usage exceeded to 109% is there any solution to increase performance. The code is given below i am using…
shitanshu
  • 222
  • 2
  • 6
  • 18
0
votes
1 answer

Writing Excel file with SuperCsv including font formatting

I use SuperCSV to write Excel files. How can I add font formatting to some of the cells - strikethrough etc.? Thanks!
user2408245
  • 1
  • 1
0
votes
1 answer

Limit CsvListReader to one line

I am working on application which processes large CSV files (several hundreds of MB's). Recently I faced a problem which at first looked as a memory leak in application, but after some investigation, it appears that it is combination of bad…
dstefanox
  • 2,222
  • 3
  • 19
  • 21
0
votes
1 answer

SuperCSV Dozer deep-mapping map with enum and subclasses?

I'm trying to see if this is even possible with SuperCSV and Dozer, or if I should just revert to Map parsing. I have a POJO that has a member field of Map. Thankfully, during CSV parsing, I know what specific subclass of MyInterface should be…
Scott Balmos
  • 331
  • 4
  • 15
0
votes
1 answer

Writing CSV file with SuperCSV in Linux platform

I am using SuperCSV for reading and writing csv files. The problem i am facing is, under Unix/Linux systems, I am getting "^M" character appending to end of each line, which is quite annoying. How do I handle/fix that. beanWriter = new…
RaceBase
  • 18,428
  • 47
  • 141
  • 202
0
votes
3 answers

how to fill class from partial csv file

I have class in Java: class data { private String id; private String name; private String phone; } and I need to fill data from CSV file. But not all columns in CSV file are mandatory, or could be in different order. CSV Example1: id,…
user1700214
  • 1,375
  • 2
  • 9
  • 6
0
votes
1 answer

Issue while working with SuperCSV parser

I have created a web application module to import CSV file to DB. After the import process the user will be displayed the summary like, the total number of records in input file, the total number of good records that got imported to db and the total…
Leejoy
  • 1,356
  • 5
  • 23
  • 36
0
votes
3 answers

Is there any way to change value of a particular cell in a csv file in java?

I have gone through other questions regarding this on StackOverflow but libraries mentioned there only allow to read or write. Some of them do allow partial read or write like SuperCSV but no library can be used for updating value of a particular…
rishiag
  • 2,248
  • 9
  • 32
  • 57
-1
votes
1 answer

Parsing tab delimited files with Super CSV

I am trying to parse a CSV file using Super CSV containing two fields (tab separated) with a unquoted string. occugroup_code occugroup_name 110000 Management Occupations 130000 Business and Financial Operations…
fellahst
  • 641
  • 1
  • 7
  • 16
-1
votes
1 answer

How to use a custom separator in generating csv file

I am trying to generated a CSV where i can use custom separator other than comma which is colon(:), which means while generating the csv if a string contains colon(:) then it should be appending double quotes around them.I have used apache commons…
Mandrek
  • 1,159
  • 6
  • 25
  • 55
1 2 3
…
13
14