Skip to main content

Questions tagged [spreadsheets]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
2 answers
70 views

Make a tabbed Workbook of Spreadsheets with TabView (and TableView) [closed]

I'd like to display a 3D table as a tabbed group of 2D tables. As a bonus incorporate TableView to enable editing. Here is my attempt:
pdmclean's user avatar
  • 1,398
0 votes
0 answers
109 views

How to select with multiple conditions effectively?

I have a spreadsheet with 100 columns and 5000 rows, which I imported into Mathematica as a list named data. First, I select all rows whose 47th element is 2021: ...
Jogn Bunda's user avatar
2 votes
1 answer
105 views

Convert a specific column to Dateobjects

I have searched around but haven't found an answer to the following problem. I have a spreadsheet with a large number of rows and 4 columns. Column 3 contains dates not in a right format. So I want to ...
Jogn Bunda's user avatar
4 votes
1 answer
204 views

How to import actual data rather than formatted data from google sheets?

I have data in my google sheets which is extracted using: ...
user13892's user avatar
  • 9,443
1 vote
0 answers
122 views

Mathematica won't show imported excel spreadsheet data [closed]

I have a problem with Mathematica 12.1 Student edition since every time i try to import data from excel with the command ...
Guillermo Pons's user avatar
2 votes
1 answer
186 views

Exporting Data to Excel, (specific sheet, and specific starting cell)

I have this code, which works properly: (I know you do not have the excess to my file mydata.xlsx, but that is not a problem, I believe. ...
Hussain-Alqatari's user avatar
4 votes
2 answers
287 views

Importing a Google Sheet including blank cells (default is ragged array)

I'm able to import data from Google Sheets using e.g. ...
Greg Colbourn's user avatar
1 vote
1 answer
206 views

Import and Export DateObject

I'm trying to import a spreadsheet with dates and export it again. But the cell reads ### in the exported file. It's shown in the screenshots. This is my code. ...
tukan's user avatar
  • 407
2 votes
0 answers
400 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 ...
user avatar
6 votes
2 answers
209 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,...
Foad's user avatar
  • 605
0 votes
1 answer
553 views

Import CSV spreadsheet slow

...
el psy Congroo's user avatar
7 votes
2 answers
1k 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 ...
Tyler Durden's user avatar
  • 4,102
2 votes
1 answer
649 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 ...
Niki's user avatar
  • 960
3 votes
0 answers
49 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, ...
F. E.'s user avatar
  • 45
6 votes
1 answer
295 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 ...
dwa's user avatar
  • 1,939
0 votes
1 answer
134 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 ...
PisA12's user avatar
  • 1
4 votes
0 answers
247 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 ...
WolframFan's user avatar
  • 1,412
5 votes
0 answers
229 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 ...
Jagra's user avatar
  • 14.4k
6 votes
2 answers
5k 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 ...
ConvexMartian's user avatar
1 vote
2 answers
3k 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, ...
WolframFan's user avatar
  • 1,412
34 votes
6 answers
11k 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: ...
Lucy Brennan's user avatar