Solved

Insert an Image into CSV file

Posted on 2010-11-11
16
937 Views
Last Modified: 2012-05-10
I want to write a Java Program to insert an image into CSV file.

Image is stored locally. Any experts able to provide some sample code?
0
Comment
Question by:rolandmy
  • 8
  • 4
  • 4
16 Comments
 
LVL 86

Expert Comment

by:CEHJ
ID: 34110884
You need to store the path to the image or base64 encode the binary form
0
 
LVL 2

Author Comment

by:rolandmy
ID: 34110929
As stated in the question, I need a sample code as reference.
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 34110938
What csv are you starting with?
0
 
LVL 2

Author Comment

by:rolandmy
ID: 34110998
How do I insert an image into sample.csv?

Code is like below:

java.io.FileOutputStream os = new java.io.FileOutputStream(new java.io.File("C:\\work\\sample.csv"));
    java.io.PrintWriter pw = new java.io.PrintWriter(os, true);    
    String separator = ",";
    String [] content = new String [2];
 
    content[0]= "content 0"+separator+ (
        ("data 01 ")+separator+
        ("data 02 ")+separator+
        ("data 03 ")+separator+
        ("data 04 ")+separator+
        ("data 05 ")+separator
        );
   
    content[1]= "content 1"+separator+ (
        ("rdata 01 ")+separator+
        ("rdata 02 ")+separator+
        ("rdata 03 ")+separator+
        ("rdata 04 ")+separator+
        ("rdata 05 ")+separator
        );
 
    for(int i=0;i<content.length;i++){
     pw.println( content[i]);
     pw.flush();
    }
0
 
LVL 86

Accepted Solution

by:
CEHJ earned 250 total points
ID: 34111126
I would strongly advise you to use available csv writers such as ostermiller or open csv
0
 
LVL 10

Assisted Solution

by:Hegemon
Hegemon earned 250 total points
ID: 34111262
Just open the file, read its content into byte[] array and output it into a "field" of your CSV between separators, taking care of all characters CSV might not like. This is best done by following CEHJ's advice above.
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 34111296
>>read its content into byte[] array

Ooh no. It needs to be base64-encoded if you want to embed it. csv files are text files
0
 
LVL 10

Expert Comment

by:Hegemon
ID: 34111353
This article http://creativyst.com/Doc/Articles/CSV/CSV01.htm (see the 1st paragrpah in the CSV & Unicode section) suggests that any ASCII character can be used in CSV. The encoding will be needed only to transfer such a file.
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 86

Expert Comment

by:CEHJ
ID: 34111364
Yes, but a byte[] will contain many unprintable characters, and, ahem ... the csv separator ;)
0
 
LVL 10

Expert Comment

by:Hegemon
ID: 34111441
There is no requirement for the characters to be printable, it will do if the processing application knows how to handle the raw byte data.
If the fields are enclosed into double quotes, then the content can be anything, including commas, double quotes and new lines - that's where the 3rd party tools you recommended come handy.
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 34111543
>>There is no requirement for the characters to be printable

Yes, but why on earth would you want your csv file to be messed up, with line feeds and other  'garbage'?
0
 
LVL 10

Expert Comment

by:Hegemon
ID: 34112983
I wouldn't even store an image in it !
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 34113454
No - nor would i - that's why i recommended storing a path to the image, but of course rolandmy might not want to be dependent on a particular file system
0
 
LVL 2

Author Comment

by:rolandmy
ID: 34170731
Abandoning this question, haven't found a 100% solution for this question yet. Will split points between Hegemon and CEHJ.
0
 
LVL 2

Author Closing Comment

by:rolandmy
ID: 34170735
Not a 100% solution.
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 34171570
:)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
thymeleaf natural templating vs JSP 2 68
GUI builder for Eclipse? 8 27
Java Options in Zimbra Server 2 46
table example 4 24
Are you developing a Java application and want to create Excel Spreadsheets? You have come to the right place, this article will describe how you can create Excel Spreadsheets from a Java Application. For the purposes of this article, I will be u…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now