Another option is to use Excel Web Services<http://msdn.microsoft.com/en-us/library/office/ms546696(v=office.14).aspx> to expose cells (and ranges) as inputs and outputs. Means you can leave the calculation stuff in Excel (which can be updated by the domain expert without needing a coder to interpret/translate). Requires SharePoint though.
Andrew Coates, ME, MCPD, MCSD MCTS, Developer Evangelist, Microsoft, 1 Epping Road, NORTH RYDE NSW 2113 Ph: +61 (2) 9870 2719 * Mob +61 (416) 134 993 * Fax: +61 (2) 9870 2400 * http://blogs.msdn.com/acoat Sent from the new Office<http://office.com/preview> From: [email protected] [mailto:[email protected]] On Behalf Of Stephen Price Sent: Friday, 28 March 2014 6:03 PM To: ozDotNet Subject: Spreadsheets and data Hey all, Wondering if anyone has taken a spreadsheet and turned it into an app before? This spreadsheet has lots of data that used the previous row to calculate the new row's data (as spreadsheets often do). Was wondering how the best way to duplicate that functionality in a .Net app with classes/database. Possible ways I've thought of; 1. Class that calculates on the fly the desired row/year of data each time it needs it. 2. The spreadsheet takes some starting values and the applies a formula to each row, could do the same thing in memory in a lookup dictionary or similar so it only needs to be done once. 3. Alternatively put that data into tables in database... downside, if the initial value is changed it would have to find and modify the appropriate rows in the database. other ways? cheers, Stephen
