Skip to content

Tag: opencsv

Clickable Email Link in Csv File created through Java Application

I am facing issue’s while Creating clickable email link in csv through Java. While I am using simple FileWriter class To generate the csv file. The email is displaying as plain text, but after I double click the cell to edit and then I click out of the cell, then only its displaying as expected “underline blue colored hyperlink”. I

Using CSVWriter to write a string array – some with quotes and some without

I see some other questions about CSVWriter writing to files and quotes. But nothing as specific as my issue. I want to print something like: abc,def,ghi,”jkl”,mno,pqr When I just write: what gets printed out is: “abc”,”def”,”ghi”,”jkl”,”mno”,”pqr” So i tried: which gives me: abc,def,ghi,jkl,mno,pqr But I need the quotes on jkl. So I tried something like: which surprisingly gives me: abc,def,ghi,””jkl””,mno,pqr

What is Coder in String Value?

I am reading a CSV file, by using com.opencsv.CSVReader Like below Value for header is coming like below screen shot: What’s coder here (Highlighted in yellow)? Why the value is 1 for first index and 0 for all other? Answer The official response is “none of your business”, since it’s a private member 😛 Which means it can very well

Appending to CSV file without headers

I am using opencsv to write a Java bean to a CSV file with headers. The file name contains the current date. If the user runs it for a second time in the same day, it appends to the file but adds another header line. How do I append to the file but without the column headers. Answer Good one.

Open CSV to export resultset to string type

I want to export the result set of the SQL query to a CSV file. I am using opencsv to export to CSV file. I am using below code to achieve it. But the problem I face is, it automatically exports to the datatype of the database column which is from resultset. Example: if I a column with datatype as

opencsv in java ignores backslash in a field value

I am reading a csv file using opencsv. I am ignoring the first line of; the csv file is tab separated with some values enclosed in double quotes. The problem occurs when I read the values of a column that has the ” character, this is stripped out of the value. For example in original file: It becomes as: In