Create program to read excel file and paste it into form fields

[lajkonik86]

Hey,

Ok so this is the problem: I have an excel file full of variables and i want to get these variables into an application running on my pc.
how do i create a script/program/macro to get 1 row in excel take all variables and paste them into the program?

Any suggestions,
I dont know how it is easiest to approach this. A macro would be really easy but im not sure it allows for pasting outside of excel.

Thanks,
Thierry

[foid025]

Well, one easy way would be to take your Excel file and save it as a CSV file (comma separated values). That way, each line would represent one row, and each comma would separate two variables.

You can then take in all that data, even through PHP, and using the explode command or similar you can cut out individual variables and save them to your db or whatever you need.

[lajkonik86]

the problem is that it will need to be an offline app.
and i need to paste something into another program.
i've only ever written online apps, so i have no idea how to approach this.