I wanted to ask how can I view an Excel file from a Mathematica notebook and modify it.
I have seen a similar question, Open Excel file with Mathematica, but the answer involves .NET. Is there any other way to open an Excel file and modify it?
|show 5 more comments|
Amending the file directly would indeed require something like .Net. If you were willing to consider an import-export roundtrip but with a spreadsheet like interface in Mathematica, then something like this might work:
Now, change the data cells you want to change and then type Shift-Enter when the cursor is in that
Then in another cell, evaluate:
This will give you an expression with the list of changed data, stripped of the enclosing
You can then
I have made two