Math Is Fun Forum

killer_1021

Member

Registered: 2013-12-13

Posts: 1

way to import data from excel to LPSolve IDE

hello, everyone. I'm new here. I just find this website and wonder if i could ask about the linear programming software here. my lecturer had gave me an assignment asking me to solve an OR model with 100 variables by using LPSolve IDE. all the data included in Microsoft Excel. may i ask is there any way to import the data to LPSolve IDE? because if i manually type the data it may become a tedious work. Thank you.

Bob

Administrator

Registered: 2010-06-20

Posts: 10,643

Re: way to import data from excel to LPSolve IDE

hi killer_1021

Welcome to the forum.

I'm not familiar with this software but it looks like it will accept data in a csv, comma separated variable, format.

http://lpsolve.sourceforge.net/5.5/

http://office.microsoft.com/en-gb/excel … 99725.aspx

Hope that helps,

Bob

Last edited by Bob (2013-12-13 20:37:28)

---

Children are not defined by school ...........The Fonz
You cannot teach a man anything;  you can only help him find it within himself..........Galileo Galilei
Sometimes I deliberately make mistakes, just to test you!  …………….Bob