Excel app to C# winform
-
I didn't know where to post this question, but this was as close as I could get. I have an excel application which I want to transfer to winform C#. Brief Description of Application 1) In my application I have several Sheets A,B,C etc (normally 40-50sheets) where I put my data. 2) After, I copy the data to A(1),B(1),C(1) (another 40-50sheets) and make my calculation via VBA, deleting, adding rows etc. until I get the required results. Sometimes, I create another copy of A eg. A(2) and start calculation again and after comparing the results of A(1) and A(2), I delete the unused version. 3) After I am satisfied with the result I make the reports of A(1),B(1),C(1) via Pivot tables. Questions 1) What is best way to simulate the Excel sheet in C# app eg. dataset, datatable, IList, since I have a lot of sheets (more than 100 per project)? 2) What database should I use (Access, XML, SQL) to store the data sheets of A,B,C and A(1),B(1),C(1) the application will be used Locally only? 3) My main question is, how should I solve this problem in theory, a pattern or perhaps a process description from experts would be really helpful :). I hope this makes sense....
-
I didn't know where to post this question, but this was as close as I could get. I have an excel application which I want to transfer to winform C#. Brief Description of Application 1) In my application I have several Sheets A,B,C etc (normally 40-50sheets) where I put my data. 2) After, I copy the data to A(1),B(1),C(1) (another 40-50sheets) and make my calculation via VBA, deleting, adding rows etc. until I get the required results. Sometimes, I create another copy of A eg. A(2) and start calculation again and after comparing the results of A(1) and A(2), I delete the unused version. 3) After I am satisfied with the result I make the reports of A(1),B(1),C(1) via Pivot tables. Questions 1) What is best way to simulate the Excel sheet in C# app eg. dataset, datatable, IList, since I have a lot of sheets (more than 100 per project)? 2) What database should I use (Access, XML, SQL) to store the data sheets of A,B,C and A(1),B(1),C(1) the application will be used Locally only? 3) My main question is, how should I solve this problem in theory, a pattern or perhaps a process description from experts would be really helpful :). I hope this makes sense....
-
Will this application only be used locally? Or are you wanting to connect to a remote database on the net somewhere?
This app will be running only locally...I am still using the excel sheets but they are not user friendly and also I can't share my app with others due to codesecurity