Group Abstract Group Abstract

Message Boards Message Boards

0
|
8.3K Views
|
2 Replies
|
0 Total Likes
View groups...
Share
Share this post:

ExcelLink "ToFileName"

Eric Spahr, Work
Posted 11 years ago

Getting files: 

In[2]:=  f = ToFileName[{ExcelDirectory["Link"], "Examples"}, "Stocks.xls"]
Out[2]= C:\Documents and Settings\Anton\Application Data\Mathematica\Applications\ExcelLink\Examples\Stocks.xls

My file on my computer is "This PC\Documents\FRB Forms\14A\2015 Params"

This workbook has 6 spreadsheets. Do i need to include one?
POSTED BY: Eric Spahr
2 Replies
Sort By:
Eric Spahr
Eric Spahr, Work
Posted 11 years ago

Yes, to import workbook and work with spreadsheets it contains. The workbook has 6 sheets with about 1100 cells per sheet. I am planning to make a template which work on all of the cells with a specific model to each..
POSTED BY: Eric Spahr

What is the goal? Importing from these files? Performing arithmetic with the resulting matrix?

POSTED BY: Bruce Miller
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Tag limit exceeded
Note: Only the first five people you tag will receive an email notification; the other tagged names will appear as links to their profiles.
Reply Preview
Attachments
Remove
or Discard