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, al

Re: reverse engineering Excel spreadsheet

2007-04-01 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

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 co

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

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

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

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 busi