How to import data from excel in R?

Answered

Barbora Krajníková

April 12, 2021 16:56

• 
• 

Hello, 

I am solving some models using R and I have data written in excel as matrices. How can I import them into the model? Is there any function in the Gurobi package I can use or should I use other packages for that? 

Thank you for any response.

0

• Official comment

  

  Simranjit Kaur

  • Gurobi Staff

  June 23, 2025 02:56 Edited

  This post is more than three years old. Some information may not be up to date. For current information, please check the Gurobi Documentation or Knowledge Base. If you need more help, please create a new post in the community forum. Or why not try our AI Gurobot?.
• 

  Matthias Miltenberger

  • Gurobi Staff

  April 13, 2021 09:29

  Hi Barbora,

  There is no function for this specific use-case, mainly because there is no standard format for data in Excel tables. You would need to export your data into some other form and then construct your model. You can do this in R or any of the other APIs that Gurobi offers.

  Here you can find more information on how to do it with R: The model argument (gurobi.com)

  I hope that helps.

  Cheers,
  Matthias

  0

Post is closed for comments.