I have standalone application that export some data to a CSV file, for simplicity let's say: Student Name & Student ID. The list is long and I wish to provide the ability to the end-users to get more information about a particular student.
For example, from the standalone application, given the student ID, you can get a PDF of the student resume (Think about a jTable where you right click the student ID and you can export/view the student's PDF).
Question: since the list is now in CSV how can I allow end-users to export a PDF of the student resume? must I use VBA or is there a way to invoke a java code to export the PDF (obviously I'd like to invoke a java code as I already have a method:
David Newton wrote:What, *precisely*, are you trying to do? What's the environment?
If I had to take a wild guess, I would say that the Java application has an option to dump to a CSV file -- which is, of course, a datafile.
This data file is loaded into microsoft excel -- and somehow, the user want the excel spreadsheet, after loading the CSV file, to magically have some sort of scripting to talk to the original Java application that dumped the CSV file, to get more data. Is that right?
Adrian Burlington wrote:I'm looking for "magically have some sort of scripting to talk to the original Java application"
There is no such a thing as magic. I was being somewhat facetious.
1. The application needs to be a service. It can't just be a standalone GUI application that is to be operated by a user. It needs to be a service that can be called programmatically. Another option is to provide a command line version of the program to enable it to do particular tasks. In this case, the client will execute the command line version programmatically.
2. There is also no such a thing as scripting in CSV files. It is purely data. So, you will need to write some sort of VB script that will either call the service, or call the command line application (depending on what you did in part 1) based on the field data.
Regardless, something tells me that this is not what you want to do.