Embed and manipulate Excel sheet
-
Hello everyone. I'm googling a lot of sites but none gives me a near answer to my requirements. I'm am about to work on a project which requires me to use excel sheet to handle the inputs and computation... and later all values inputed and computed will be stored in a database.... below are the steps... 1. store or embed an excel file as one(1) record in a database. Every record has different computations and inputs... in short, embeded excel sheet will serve as templates for future data entry 2. Data entry proper. a. embeded excel sheet will display only the columns "A and B". hidding the rest of colums which has the formulas in it. b. upon losing the focus, columns "A and B" will be computed based on the formulas from the hidden columns. c. Save the updated template in another table as new record. d. Read the inputed and computed values from embeded excel, then store it in a table as new record. Hope some can guide or can give me a sample of the above requirement... Thank you in advance...
xxx
-
Hello everyone. I'm googling a lot of sites but none gives me a near answer to my requirements. I'm am about to work on a project which requires me to use excel sheet to handle the inputs and computation... and later all values inputed and computed will be stored in a database.... below are the steps... 1. store or embed an excel file as one(1) record in a database. Every record has different computations and inputs... in short, embeded excel sheet will serve as templates for future data entry 2. Data entry proper. a. embeded excel sheet will display only the columns "A and B". hidding the rest of colums which has the formulas in it. b. upon losing the focus, columns "A and B" will be computed based on the formulas from the hidden columns. c. Save the updated template in another table as new record. d. Read the inputed and computed values from embeded excel, then store it in a table as new record. Hope some can guide or can give me a sample of the above requirement... Thank you in advance...
xxx
-
You can start with this one: Opening and Navigating Excel with C#[^]
thank you for your emmediate reply... how can i display only columns A and B... hidding the rest of the columns?
xxx