Group Abstract Group Abstract

Message Boards Message Boards

0
|
6.4K Views
|
4 Replies
|
0 Total Likes
View groups...
Share
Share this post:

Importing the formulas from an Excel Workbook 

array=Import[workbookname.xlsx];

Is there any way to also import the formulas which relate Excel cells to other cells other cells in the same Worksheet including cross references between Worksheets in the same Workbook or Worksheets in other Workbooks?

Thanks,

MIlt Benjamin Self 856 3547692 C
POSTED BY: Milton K Benjamin
4 Replies
Sort By:

Hi Ian, I constructed another approach to managing busy code. I abstract the problem one level up and develop a sctipt to tell Mathematica what to do in much fewer lines.

This requires me to deal with very busy code just once. The busy code parses the script and constructs Wolfram Programming Language code which solves any problem which fits in the Framework of the Script.

Thanks Milt
POSTED BY: Milton K Benjamin
POSTED BY: Ian Williams

Hi Ian, Found the problem! I left the s off "Formulas" as the 2nd argument to Import[]. After adding the "s", it works like a champ. I must remember to put each Wolfram Language Statement on its own line so its readable!.

Thanks, Milt
POSTED BY: Milton K Benjamin

I believe there’s an optional argument “Formulas” that enables you to import a workbook’s formulae as text. I’ve never tried this, but it sounds like you may have to translate the text form of the imported formulae to WL expressions if you want to use them in your notebook. I’d be interested to know if you have any success with this.
POSTED BY: Ian Williams
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