How to copy files from Excel to JTable?please help

Asked By Jose K Vincent 60 points N/A Posted on - 09/14/2014

Hi guys,

I want to know how to copy data from Excel to JTable (Netbeans).I have a lot of rows in fact more than 100 which I need to copy from Excel and transfer to JTable but the problem is I don't know how to do it. Please hep me any body who knows the answer here please help me.

• Status: Open
• Question Views: 712
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: General

Answered By Njeri Susan 0 points N/A #191350

How to copy files from Excel to JTable?please help

Hello Jose

To accomplish this task, you need to do some programming. Use the following steps.

(a) Download the Excel adapter code from here.

(b) Compile it.

(c) Add this line to your application

ExcelAdapter myAd = new ExcelAdapter(jTable1)  (Basically we are making sure you application is finding Exceladapter.class file)

This line enables the clipboard functionality between Jtables and Excel

Hope you were able to achieve your goal.

About Njeri Susan

Questions
0

Answers
100

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 10/12/2014
• Question Category: General