sending sms to 1s t column of excel data

Question

Hello everyone I have 1 excel sheet in which 2 columns are there>In first column mobile number is inserted and in second column messages are inserted.I want to send sms to all the numbers in excel file with there corresponding messages by uploading the excel file .I uploaded the excel file and getting the 2 columns (i have done this by showing the contents of excelsheet in gridview)but no idea about sending the messages to the numbers by uploading the excel.I have sms gateway. Plz.help. Thanks in advance

Jolly Priya · Answer

The messages will be send only after clicking the button..The complete scenario is like this: Two radiobutton: 1 -for Enter the contact nounder this we have to enter the contact no and msg and send the msg by clicking on send button. 2- radio button is like for uploading the excel file where a user will upload excel file then clicking on send button the msg will be sent to the no. Plz help...

Jolly Priya · Answer

i am doing one web application programming where each and every user can upload its excel file with the numbers and messages..so if i will use ribbon designerthen how is that possible..and its totally depends on user in which format he uploads the excel file

Kunal Vaishya · Answer

Hi  You can also use AddIns of Microsoft Visual Studio for Excel In this no need to transaction with Excel just Open Excel and Select and Send with help Context Menu Must see Link http://visualstudiomagazine.com/articles/2011/06/20/wcovb_automate-excel.aspx Reference Link http://msdn.microsoft.com/en-us/library/vstudio/cc668205(v=vs.100).aspx http://stackoverflow.com/questions/5550726/create-excel-add-in-get-cell-value

Sanjeeb Lenka · Answer

you can access the moble no by this code: for(int i = 0 ;i { //here you have to write your sms sending code. } to access the mobile no. within the loop GridView1.Rows[i].Cells[1].Text; to access the msg within the loop GridView1.Rows[i].Cells[2].Text; if it helps you mark it as answered