You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Biza <am...@gmail.com> on 2011/02/09 12:50:47 UTC
Excel Solver
Hi,
I am interested to know if it is possible to use Excel Solver directly from
POI.
If yes how? If not, can anybody give me an alternative?
Thanks,
B
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-Solver-tp3377438p3377438.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Excel Solver
Posted by Biza <am...@gmail.com>.
Mark,
Thanks a lot!
Op 9-2-2011 19:13, Mark Beardsley [via Apache POI] schreef:
> From that then, I take it that you can only actually do anything with
> Solver when the file is open in Excel. If this is true then POI is of
> no use to you at all as the api can only be used to create and edit
> files; it cannot 'control' or 'manipulate' the Excel application. If
> this is what you need to do then look at OLE/COM or at coding using
> C#/Visual Basic/Visual C++ where there is an Excel control avaiable to
> you. The drawback is that these are all Windows based technologies and
> will not be of any use to you if you are running under Linux.
>
> Yours
>
> Mark B
>
> ------------------------------------------------------------------------
> If you reply to this email, your message will be added to the
> discussion below:
> http://apache-poi.1045710.n5.nabble.com/Excel-Solver-tp3377438p3378024.html
>
> To unsubscribe from Excel Solver, click here
> <http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=3377438&code=YW1idXRuYXJ1QGdtYWlsLmNvbXwzMzc3NDM4fC0xNzI4NzY1OTUy>.
>
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-Solver-tp3377438p3378034.html
Sent from the POI - User mailing list archive at Nabble.com.
Re: Excel Solver
Posted by Mark Beardsley <ma...@tiscali.co.uk>.
>From that then, I take it that you can only actually do anything with Solver
when the file is open in Excel. If this is true then POI is of no use to you
at all as the api can only be used to create and edit files; it cannot
'control' or 'manipulate' the Excel application. If this is what you need to
do then look at OLE/COM or at coding using C#/Visual Basic/Visual C++ where
there is an Excel control avaiable to you. The drawback is that these are
all Windows based technologies and will not be of any use to you if you are
running under Linux.
Yours
Mark B
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-Solver-tp3377438p3378024.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Excel Solver
Posted by Biza <am...@gmail.com>.
Mark,
I understand your question. I also just heard of it as I am not an excel
expert. Solver is an add-in for optimizing models.
Regards,
B
Op 9-2-2011 18:26, Mark Beardsley [via Apache POI] schreef:
> Sorry to sound stupid but what is Excel Solver?
>
> Yours
>
> Mark B
>
> ------------------------------------------------------------------------
> If you reply to this email, your message will be added to the
> discussion below:
> http://apache-poi.1045710.n5.nabble.com/Excel-Solver-tp3377438p3377958.html
>
> To unsubscribe from Excel Solver, click here
> <http://apache-poi.1045710.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=3377438&code=YW1idXRuYXJ1QGdtYWlsLmNvbXwzMzc3NDM4fC0xNzI4NzY1OTUy>.
>
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-Solver-tp3377438p3378015.html
Sent from the POI - User mailing list archive at Nabble.com.
Re: Excel Solver
Posted by Mark Beardsley <ma...@tiscali.co.uk>.
Sorry to sound stupid but what is Excel Solver?
Yours
Mark B
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Excel-Solver-tp3377438p3377958.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org