The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
59 views

Import of data from ODS

With SetDirectory["~/Downloads"]; ifile = "test.xls"; TimeConstrained[idata = Import[ifile, {"Data", 1}], 5]; I can achieve the desired result of importing the ...
5
votes
0answers
134 views

Can Apple's Numbers spreadsheet link to a Mathematica function?

I use Apple's Numbers spreadsheet for a single thing, a double entry accounting model to understand complicated financial transactions. A current model depends on the value of a single initialization ...
4
votes
0answers
98 views

Import Excel data forcing links (ie workbooks) to be updated

We have noticed importing data from an Excel spreadsheet doesn’t update links. The problem with this is if you import a spreadsheet that comprises of linked workbooks data and those workbooks have ...
3
votes
0answers
41 views

Is there a way to create named ranges for spreadsheet exports?

I am trying to figure out whether I can tell Mathematica to name ranges for data that I am exporting? I want to use this data in CPLEX, which unfortunately doesn't allow the use of the R1C1 notation, ...