Hello

I am trying a write a code in Gurobi using Java interface. However, I couldn't read my data which are in Excel spreadsheets. How can I read data in Excel?

Thank You

asked 11 May '14, 16:15

helenM's gravatar image

helenM
112
accept rate: 0%


Easiest thing would be to use the simple csv format, but depending on situation it may not be what you need. You could also take a look at Apache POI, see here

link

answered 11 May '14, 16:21

Bo%20Jensen's gravatar image

Bo Jensen ♦
5.0k2919
accept rate: 14%

1

Or JExcelApi, but the newer POI versions support the OpenXML formats too, so POI is probably the better choice.

(12 May '14, 03:02) Geoffrey De ... ♦

Or you may use Gurobi with JSR-331 standard (http://jsr331.org) and Rule Solver that already includes an Excel-interface (POI-based)

link

answered 12 May '14, 08:14

jacobfeldman's gravatar image

jacobfeldman
212
accept rate: 0%

Hey Jacob. Does your Rule Solver's Excel-interface work for input data too? I thought it was like our OptaPlanner's Excel-interface: for defining constraints only.

(12 May '14, 08:19) Geoffrey De ... ♦

Yes, it does: you may use tables of the type "Data" directly in Excel. The structure of such tables can be defined in other Excel tables of the type "Datatype".

(12 May '14, 08:27) jacobfeldman
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×190
×79
×22
×6

Asked: 11 May '14, 16:15

Seen: 1,162 times

Last updated: 12 May '14, 11:59

OR-Exchange! Your site for questions, answers, and announcements about operations research.