How to link an excel file with the 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
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
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
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
How to run java swing application from jar files .
How to run
java swing application from jar files . Hello Sir,
I developed a
java swing application .Now i want to execute it as .exe setup
file .As per my knowledge i have to run .jar
file from dist folder
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