CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2008
    Posts
    3

    Excel migration to C# application

    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....

  2. #2
    Join Date
    May 2009
    Location
    Bengaluru, India
    Posts
    460

    Re: Excel migration to C# application

    DataTable would be ideal as you have diff columns of various data types .
    You can use My SQL as it is available for free.

  3. #3
    Join Date
    Aug 2008
    Posts
    3

    Re: Excel migration to C# application

    So, for example.... I have a dataset_1 witch will hold original data in datatables A,B,C...and dataset_2 with the result tables A(1), B(1), C(1) - datatables?
    Since this is a strictly local application should I really move to server-based database MySQL, SQL Express ? should I prefer maybe XML or Access?

  4. #4
    Join Date
    May 2009
    Location
    Bengaluru, India
    Posts
    460

    Re: Excel migration to C# application

    As you are telling its a local application you can avoid server-based databases. You can go for access or XML which ever is convinient to you.

    I havent dealt with Datasets, hope some one answers your query abt that.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured