How to link a excel file with a application software using java swing
I have to link an excel file with a application software which I am developing.The excel file will contain questionnaire for surveys.I have this code which is only able to open a Jpanel to select the file.After I select the file nothing is happening.I wanted to be able to generate a template based on the questions that are in the excel file (like extracting the questions from the excel file and creating a template from it) and which I have to upload on the web later.could you please help me with this?
import java.io.*;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.filechooser.*;
public class SelectFile extends JFrame{
public static void main(String[]args){
JFrame frame = new JFrame();
frame.setLayout(null);
frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
frame.setTitle("Select File for Linking");
frame.setSize(400, 100);
Container container = frame.getContentPane();
container.setLayout(new GridBagLayout());
final JTextField text=new JTextField(20);
JButton b=new JButton("Select File");
text.setBounds(20,20,120,20);
b.setBounds(150,20,80,20);
// b.setText("<html><font color='blue'><u>Select File</u></font></html>");
b.setHorizontalAlignment(SwingConstants.LEFT);
//b.setBorderPainted(false);
//b.setOpaque(false);
// b.setBackground(Color.lightGray);
b.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e){
JFileChooser fc = new JFileChooser();
fc.addChoosableFileFilter(new OnlyExt());
int returnval = fc.showOpenDialog(null);
if (returnval == JFileChooser.APPROVE_OPTION) {
File file = fc.getSelectedFile();
text.setText(file.getPath());
}
}
});
container.add(text);
container.add(b);
frame.setVisible(true);
}
}
class OnlyExt extends javax.swing.filechooser.FileFilter{
public boolean accept(File file) {
if (file.isDirectory()) return false;
String name = file.getName().toLowerCase();
return (name.endsWith(".xls"));
}
public String getDescription() { return "Excel ( *.xls)"; }
}
View Answers
Ads
Related Tutorials/Questions & Answers:
Advertisements
Linking excel file with a application tool using swing
Linking
excel file with a
application tool
using swing I have to
link an
excel file with my
application software using java swing.As soon as i click on the
link button a window should open for selecting the
excel file(just like
Import object in Excel using java swing
Import object in
Excel using java swing Hi sir,
I want to make a
swing application where I can import a object by clicking a button. I am
using....
The details of the
excel operation which i want to do by one click:
in
excel its
swing application to import a object in a excel
swing application to import a object in a excel Hi sir, I want to make a
swing application where I can import a object in a cell of a
excel... 'create from
file' window>browse (this browse path I want to give inside the
swing
excel file using JDBC java.?
excel file using JDBC
java.? hey, i am a telecomm. engineer , and i am try to develop a tool which reads from a
excel file and then appends the same... used JDBC ODBC to read from
excel file. i am not able to append it
using
Excel file wriring using java
Excel file wriring
using java i have one predefined bill format in
excel
i want to append values in it
using java apche POI or Jexcel
i tried it but it overwrites
file and lost previous contents what can i do
To read & write a excel file using the core java
To read & write a
excel file using the core java Hai,
I'm new to JavaProgram.But now i need
java program to read & write a
excel file so, can anyone help me to learn the above mentioned topic(
link for the portion
How to Hide Button using Java Swing
Programming
application how to hide the buttons
using Java Swing. Please Visit this below reference
link
http://www.roseindia.net/tutorial/
java/
swing...
How to Hide Button
using Java Swing Hi,
I just begin to learn
java
Linking an Excel File with the Application tool
Linking an
Excel File with the
Application tool I have to
link an
excel file with a
application software which I am developing.I have this code... on the questions that are in the
excel file like extracting the questions from the
excel file
How to Create New Excel Sheet Using JSP
How to create new
excel sheet
using jsp
 ... a new
excel
sheet
using
java .You can create any number of new
excel sheets in a
excel file.
To create a
excel sheet we can use third party APIs
Excel file Handling in Java
Excel file Handling in Java Hello Sir,
I am new to
Java, I have Started
Java Core by myself. I want to make a project which include 3-4
Excel file to handle.Please explain
how to read and write
Excel file in Java.Is it tough