Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [spreadsheets]

The tag has no usage guidance.

2
votes
0answers
54 views

Import specific range of Google spreadsheet

I am trying to import only a specific range of a Google spreadsheet as data in Mathematica for further usage like plotting. So I tried to use the data = Import["https://...", "Data"] function, but ...
6
votes
2answers
113 views

Make a list of triplets from a table with empty cells

I have a Google spreadsheet where not all of the cells are filled. It looks like this: I want to import it as a list of lists like: $\left\{ \left\{34,1,3 \right\},\left\{45,1,4 \right\},\left\{45,2,...
0
votes
1answer
226 views
6
votes
2answers
585 views

Replacing Excel with Mathematica Using 2D Tables [closed]

Is there a methodology that would work well for replacing Excel with Mathematica? Typically I use Excel to make various lists of values with formulae that relate those values. Below is a very typical ...
2
votes
1answer
418 views

Convert spreadsheet (Excel) to *.csv during import

I have long lists of data in spreadsheets and have the problem that Mathematica crashes regularly during import of the .xlsx files. Is it possible within Mathematica to take a certain tab of a .xlsx ...
3
votes
0answers
45 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, ...
6
votes
1answer
151 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 ...
0
votes
1answer
114 views

Importing Selected Spreadsheets [duplicate]

Consider the PISA study report, which contains dozens separate spreadsheets in each respective excel files (see http://www.oecd.org/pisa/keyfindings/pisa-2012-results-volume-iv.htm) Is there any way ...
4
votes
0answers
152 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 ...
5
votes
0answers
209 views

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

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 ...
6
votes
2answers
2k views

How to import a “.numbers” spreadsheet?

Does Mathematica support importing a ".numbers" spreadsheet file (from the "Numbers" '09 (ver. 2.3 554) spreadsheet program in Apple's OS X iWork office suite)? A ".numbers" file is actually a zip ...
1
vote
2answers
2k views

Import Spreadsheet Data and DeleteCases of empty cells &/or choosing a Range to import

I am importing Excel spreadsheet data into Mathematica. Here is what the data looks like, notice the cell Q1 with "sdf": I import this data by specifying the Spreadsheet location, sheet name, top 9, ...
30
votes
6answers
8k views

Cut and paste data from a spreadsheet

I have a set of data points in two columns in a spreadsheet (OpenOffice Calc): I would like to get these into Mathematica in this format: ...