Is there any way to import a .txt file in Excel using java?

Question

i want to know if it's possible to import a text file in excel through java code. I know that we can use directly Excel and open a text file. But for me i want to do it with java because i have a java program that create a text file everyday and after i want to open it with excel automatically.

I don't want to loose my time to open Excel, then click import , then choose file, then... is it possible to do fastly with java?

Thank you

score 1 · Accepted Answer · answered Feb 28 '11 at 21:48

1

I think the easiest solution here would be to have your Java code create a Comma Seperated Value (CSV) file. They are easy to create and easy for Excel to open (no extra clicks required).

answered Feb 28 '11 at 21:48

Justin Niessner

242,243
40
408
536

score 1 · Answer 2 · answered Feb 28 '11 at 21:52

1

import java.io.IOException;

class ExcelStarter {
    public static void main(String args[]) throws IOException
   {
      Runtime.getRuntime().exec("cmd /c start excel.exe _pathtoexcelfile_");
   }
}

answered Feb 28 '11 at 21:52

Ritch Melton

11,498
4
41
54

I don't want to open an excel file but import a text file with excel using java – user618111 Feb 28 '11 at 22:52
Replace with _pathtoexcelfile_ with your text file location. As long as its a type supported by excel (text, csv, etc..) then you can open it. There's no difference. Try this. It works. – Ritch Melton Feb 28 '11 at 23:30
It's simple with Ritch Melton tips Thank you – user618111 Mar 01 '11 at 11:24

score 0 · Answer 3 · answered Feb 28 '11 at 22:02

0

Yes, it is possible. You can parse your text file and put the data in a worksheet using the Apache XSSF library for xlsx. And then save it. 10 minutes of research should be sufficient to find what you need.

answered Feb 28 '11 at 22:02

Martijn Courteaux

67,591
47
198
287

i'm beginner i really don't know what and how to do with Apaxhe XSSF library for xlsx – user618111 Feb 28 '11 at 22:53

score 0 · Answer 4 · edited May 23 '17 at 11:47

0

I have used Apache POI and their HSSF. It has a Java API with which to read Excel files.

If it is a CSV (Comma Separate Value) file, you may also want to see this question Can you recommend a java library for reading and possibly writing csv files

edited May 23 '17 at 11:47

Community

1
1

answered Feb 28 '11 at 22:12

rajah9

11,645
5
44
57

I have corrected the second link. The first link, HSSF, might be a good place to start. – rajah9 Mar 01 '11 at 14:08

Is there any way to import a .txt file in Excel using java?

4 Answers4