Having problems working with C# and Excel

Question

Hi everyone! I am Warren a student in engineering now. I am given a project to do using C# but I am stucked with my project for 5weeks already. My project scope was to import data from Excel into datagridview in C# and it must be able to save back as the same filename if edited. Another part of the project is to plot multi-line graphs with data from the Excel file in C#. Excel files that I have is saved in a folderit contains about 6 columns of data. I have completed the importing part through OLEDB and I have somehow done the exporting(save) part. But I was unable to automatically save after editing it prompts me twice where to save. (The code contains savefiledialog and workbook.saveas. I think that is the problem why it prompts me twice. But I have no idea how to edit the code.) My project deadline is 1 and a half weeks time I have been trying really hard to get it done for this passed few weeks. But sad to say I am stucked. I really hope someone out there can help me out! You can email me at : warrenhuang@live.com.sg Sorry for any inconvenience made. Thank you in advance! Appreciated! Best Regards Warren Wee

warren wee · Answer

Hi Sir Thank you for your reply. I have posted a new thread for my subject :) Best Regards Warren Wee

Sam Hobbs · Answer

I do not know how to plot a graph. So since this is a new question you might need to create a new thread with a subject that indicates you need help plotting a graph. I hope you get help that way at least.

warren wee · Answer

Hi Sir I am able to find similar codes to import and export Excel files previously. But the biggest issue about my project now is about plotting graph as I could not find any similar examples. Attached folder is my project it includes: GUI and Raw data folder where Excel files are saved. I am suppose to click on the view graph on the menustrip and then it will allow user to choose which Excel file data to plot graph in C#. I could not handle this part and this is where I face my problem. I really hope you can help me out but if is not possible it will be fine. Sorry for any inconvenience made. Thank you very much for your reply appreciated :) Best Regards Warren Wee

Sam Hobbs · Answer

Welcome to C# Corner. There are many articles in this web site about Excel. It would help if you provided the code that is the problem but you are less likley to get help if there is a lot of code. It would be better to provide a small program; the smallest possible program that duplicates the problem. That is more likely to get you help. The best way to get help is to find an article in this web site that explains how to do what you need help with and then if you have questions about that then ask specific questions.