adding data to MS Excel in C#.net
-
i have a C# windows application form with various controls such as textbox ,combo box,date time picker etc. i want that on clicking a button PRINT the data entered by the user in the controls should be added to particular cells of an existing Excel sheet (for e.g. i have to add the data in textBox1 to a particular cell of sheet1.xls saved on desktop)and then the sheet should be printed..i don't want the data to be saved on the sheet as i want that the next time i click the PRINT button the new data should be entered to the same cell. ...plz help and thanks in advance
-
i have a C# windows application form with various controls such as textbox ,combo box,date time picker etc. i want that on clicking a button PRINT the data entered by the user in the controls should be added to particular cells of an existing Excel sheet (for e.g. i have to add the data in textBox1 to a particular cell of sheet1.xls saved on desktop)and then the sheet should be printed..i don't want the data to be saved on the sheet as i want that the next time i click the PRINT button the new data should be entered to the same cell. ...plz help and thanks in advance
You should read up on using the Office Interop Library.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
-
i have a C# windows application form with various controls such as textbox ,combo box,date time picker etc. i want that on clicking a button PRINT the data entered by the user in the controls should be added to particular cells of an existing Excel sheet (for e.g. i have to add the data in textBox1 to a particular cell of sheet1.xls saved on desktop)and then the sheet should be printed..i don't want the data to be saved on the sheet as i want that the next time i click the PRINT button the new data should be entered to the same cell. ...plz help and thanks in advance
Hi, Download the VSTO(Visual Studio Tools for Office)addins, which and specifically meant for Office applications learn them, from the following location: http://www.microsoft.com/downloads/details.aspx?familyid=F5539A90-DC41-4792-8EF8-F4DE62FF1E81&displaylang=en[^] Hope this helps . Regards, John Adams ComponentOne LLC
Regards, John Adams ComponentOne LLC
-
You should read up on using the Office Interop Library.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
thanks for the reply Paul ...it would be great if you could explain the technique to me as i am a novice in the field of C#.Net programming :sigh:
-
thanks for the reply Paul ...it would be great if you could explain the technique to me as i am a novice in the field of C#.Net programming :sigh:
Do a basic google search for Office Interop Library, also, check out the link John just posted.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
-
Hi, Download the VSTO(Visual Studio Tools for Office)addins, which and specifically meant for Office applications learn them, from the following location: http://www.microsoft.com/downloads/details.aspx?familyid=F5539A90-DC41-4792-8EF8-F4DE62FF1E81&displaylang=en[^] Hope this helps . Regards, John Adams ComponentOne LLC
Regards, John Adams ComponentOne LLC
I don't know what happened, your post should have gone to the OP, and for some reason came up in my email :suss: Good link, and I directed the OP to your post.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
-
i have a C# windows application form with various controls such as textbox ,combo box,date time picker etc. i want that on clicking a button PRINT the data entered by the user in the controls should be added to particular cells of an existing Excel sheet (for e.g. i have to add the data in textBox1 to a particular cell of sheet1.xls saved on desktop)and then the sheet should be printed..i don't want the data to be saved on the sheet as i want that the next time i click the PRINT button the new data should be entered to the same cell. ...plz help and thanks in advance