Re: reverse engineering Excel spreadsheet

2007-04-02 Thread Paddy
On Apr 1, 4:59 pm, Duncan Smith [EMAIL PROTECTED] wrote: Hello, I am currently implementing (mainly in Python) 'models' that come to me as Excel spreadsheets, with little additional information. I am expected to use these models in a web application. Some contain many worksheets and

Re: reverse engineering Excel spreadsheet

2007-04-02 Thread Bart Willems
John Machin wrote: I'm a bit puzzled by your notion of creating a dependency graph *without* first extracting the relationships (functions) [which you could do only by parsing the formulas and macros]. Not really. The range object in the Excel object model has a Dependents attribute,

reverse engineering Excel spreadsheet

2007-04-01 Thread Duncan Smith
Hello, I am currently implementing (mainly in Python) 'models' that come to me as Excel spreadsheets, with little additional information. I am expected to use these models in a web application. Some contain many worksheets and various macros. What I'd like to do is extract the data and

Re: reverse engineering Excel spreadsheet

2007-04-01 Thread irstas
On Apr 1, 6:59 pm, Duncan Smith [EMAIL PROTECTED] wrote: Hello, I am currently implementing (mainly in Python) 'models' that come to me as Excel spreadsheets, with little additional information. I am expected to use these models in a web application. Some contain many worksheets and

Re: reverse engineering Excel spreadsheet

2007-04-01 Thread Laurent Pointal
Duncan Smith wrote: Hello, I am currently implementing (mainly in Python) 'models' that come to me as Excel spreadsheets, with little additional information. I am expected to use these models in a web application. Some contain many worksheets and various macros. What I'd like to do

Re: reverse engineering Excel spreadsheet

2007-04-01 Thread John Machin
On Apr 2, 1:59 am, Duncan Smith [EMAIL PROTECTED] wrote: Hello, I am currently implementing (mainly in Python) 'models' that come to me as Excel spreadsheets, with little additional information. I am expected to use these models in a web application. Some contain many worksheets and

Re: reverse engineering Excel spreadsheet

2007-04-01 Thread Duncan Smith
John Machin wrote: On Apr 2, 1:59 am, Duncan Smith [EMAIL PROTECTED] wrote: Hello, I am currently implementing (mainly in Python) 'models' that come to me as Excel spreadsheets, with little additional information. I am expected to use these models in a web application. Some contain many