| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 105344 | 2009-11-28 07:28:00 | Calling any XLS experts please... | DazzaMc (15463) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 834371 | 2009-11-28 07:28:00 | Ok - first up - I'm no expert in XL, I know how to create forms, add in a few 'this column + that column' bits here and there and a few other basic's like automating their creation, population and reading by server side code, but anything beyond that is currently over my head... Basically - I have an XLS file which has some formulas in it - I would like to convert or view those formulas into/in VB/C++/C# or any other so I can then convert them again into VB.NET to be used as a class in a project. Does anyone know how I go about viewing or exporting these formulas in VB? I'm using Office 2007 for my XLS file and Visual Studio 2008 for my development environment. Any help with me very muchly appreciated! Thanking you! :thanks |
DazzaMc (15463) | ||
| 834372 | 2009-11-28 20:12:00 | Not doable? :-) |
DazzaMc (15463) | ||
| 834373 | 2009-11-28 20:57:00 | Do you want your VB.NET app to manipulate an XLS file, or do you want the VB.NET to implement the same features using winforms? There really isn't any sensible way to "export" the formulae - you would need to just replicate the business logic in your VB.NET or C# winforms or webforms app. |
somebody (208) | ||
| 834374 | 2009-11-29 22:25:00 | Yer - thanks for the reply 'somebody'. I decided it was taking too long trying to do it the 'short cut' way and have just rewritten the formula in JavaScript instead. Sometimes it pays to just dive into it instead of looking for shortcuts.... Thanks for your response/time anyway 'somebody'! :-) |
DazzaMc (15463) | ||
| 1 | |||||