Tagged Questions
1
vote
0answers
51 views
Exporting Specific Cells of Many Workbooks into One using Mathematica
I currently have a large number of detailed files from which I would like to extract certain cells' information to make an Archive spreadsheet.
There are approximately 9 parameters of each ...
2
votes
1answer
56 views
Using NetLink to Import Excel File
I can import an Excel file into Mathematica easily:
But when I try from .Net it fails:
These are the commands and errors I am getting:
...
2
votes
5answers
110 views
Creating ordered triplets from an Excel sheet
I have an Excel sheet of the form:
" " a b c
1 R S T
2 U V W
3 X Y Z
Where every entry is a number (except the blank quotes, ...
5
votes
1answer
337 views
Exporting data from Excel into Mathematica using clipboard
I know that it's possible to import Excel data into Mathematica using the Import command, as we can see in this post. But some times, I need just to do some fast ...
0
votes
1answer
226 views
How to specify DataRange in a ListPlot with an imported set of data
So I've been trying to import a large set of data (6900 point pairs) from an excel (.xls) file. The Exel file has 2 columns of numeric data. I've also been trying to plot this data, but when I do, it ...
8
votes
3answers
865 views
Excel Headers --> Mathematica
I have a large Excel .xls file. Miniature version shown below:
(formatting should appear as two columns...)
...
2
votes
2answers
344 views
Converting numbers to integers
I've read the available documentation but I still haven't found an NumberForm -> Integer function yet. No result in this site's search, either.
Does it exist?
...
3
votes
2answers
2k views
Importing from Excel
I'm trying to import a matrix from Excel to Mathematica. My code is:
Import["desktop/stproj.xls", "xls", data, 1]
The output is some weird stuff about population ...
3
votes
2answers
808 views
Importing .txt or .csv financial data
I am trying to import some financial data exported from Excel. You can find the relevant file here : Text File or CSV File
This is what the data looks like in Excel :
Using the following code to ...
