I would like to convert an Excel spreadsheet to a C # code component. To get this goin 'I like to get all sheet cells containing fomulars in C # via interop. In the C # module, I would like to solve certain functions with different values, replacing cell references in fomular. Is there an environment where I can, for example, convert "SUM ($ C3: $ C5)" from excel to "var sum = c3 + c4 + c5;" or incomplete forms?
examines gordon
Is this something you will do repeatedly or only once?
www.spreadsheetgear.com Excel #, . , API, , , , .
- .
, #.
Google , , , :
Excel. , F # Luca Bolognese, MSDN.
, , execl :
FormulaEngine - .NET, . , . Excel, .
: FormulaEngine
. python: pycel
, VBA excel , , ?
Give up ActiveMesa X2C , which does just that. (Disclaimer: I am the author of the specified product.)