Tell me more ×
Mathematica Stack Exchange is a question and answer site for users of Mathematica. It's 100% free, no registration required.
up vote 5 down vote favorite
2

There is InputField in mma but how to make InputTable? In MathCAD it`s possible to insert Excel spreadsheet with input and output variables.Input variables I use for filling of header row and column and output variable for output. How to make the same functionality in mma? Thanks in advance

share|improve this question
Thanks for the accept, but there's no need for speed. It's better to give it a few hours or even days, so that more answers come in. – Sjoerd C. de Vries Sep 16 '12 at 15:15
This MathCAD feature is very good but nothing like it exists built in to Mma. The closest is TableView which @SjoerdC.deVries has shown below. It is undocumented and falls way short of the MathCAD implementation. Fingers crossed for a full documented and better version for V9. – Mike Honeychurch Sep 16 '12 at 22:46

1 Answer

up vote 6 down vote 
nrows = 3; ncols = 4;
t = ConstantArray[0, {nrows, ncols}];
it = Table[With[{i = i, j = j}, InputField[Dynamic[t[[i, j]]]]], {i,nrows}, {j, ncols}];

Dynamic[TableView[it]]

Mathematica graphics

Another dynamic view to show it works:

Transpose[t] // TableView // Dynamic

(the Transpose here just used to show it actively uses the input).

Mathematica graphics

Please note that I used the undocumented TableView to make it more Excel-like, but I noticed that cell selection is a bit sluggish and/or unpredictable. You may want to change to Grid instead, which seems to work better.

share|improve this answer
but I noticed that cell selection is a bit sluggish and/or unpredictable me too. I am having hard time entering numbers in the fields. I put the mouse in say cell (2,3), i.e. second row, 3rd column, and try to type in a number, but it is not being accepted. It seems the first column in the table accepts input? I tried TAB but that did not help. I am using V 8.04, windows 7 – Nasser Sep 16 '12 at 15:07
@NasserM.Abbasi As you can see in the figures it is quite possible to enter data in all the rows (I work on the same platform as you), but there is a good reason for my advice to use Grid. – Sjoerd C. de Vries Sep 16 '12 at 15:12
2  
Dangerous to rely upon undocumented (even unreliable) TableView. It would be really convenient if TableView were implemented reliably and with documentation in a future Mathematica version, but that's something we cannot count on, of course. So Grid is probably better to use for now. – murray Sep 16 '12 at 15:23
But inputed values dissapear after recalculation of notebook?! – SergeyFomin Sep 16 '12 at 16:27
@SergeyFomin Did you notice the line: t = ConstantArray[0, {nrows, ncols}]; in the code? What do you think it does? – Sjoerd C. de Vries Sep 16 '12 at 18:30
show 6 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.