Cannot implicitly convert type 'string' to 'int'

Question

0.00/5 (No votes)

See more:

i have been trying to upload an xls file and save them in a path and receive a view on success showing the xls file up this throws up

[HttpPost]
       public ActionResult Import(HttpPostedFileBase excelfile)
       {
           if (excelfile == null || excelfile.ContentLength == 0)
           {
               ViewBag.Error = "Please select the updated file<br>";
               return View("About");
           }
           else
           {
               if(excelfile.FileName.EndsWith("xls") || excelfile.FileName.EndsWith
                   ("xlsx"))
               {
                   string path = Server.MapPath("~/Excel/" + excelfile.FileName);
                   if (System.IO.File.Exists(path))
                       System.IO.File.Delete(path);
                   excelfile.SaveAs(path);
                   //Read data from excel file
                   Excel.Application application = new Excel.Application();
                   Excel.Workbook workbook = application.Workbooks.Open(path);
                   Excel.Worksheet worksheet = workbook.ActiveSheet;
                   Excel.Range range = worksheet.UsedRange;
                   List<Details> listExcels = new List<Details>();
                   for(int row = 3; row <= range.Rows.Count; row++)
                   {
                       Details d = new Details();
                       d.UserID = ((Excel.Range)range.Cells[row, 1]).Text;
                       //where error comes
                       d.Name = ((Excel.Range)range.Cells[row, 2]).Text;
                       d.Enroll_ID = ((Excel.Range)range.Cells[row, 3]).Text;
                       d.Place = ((Excel.Range)range.Cells[row, 4]).Text;
                       d.Date = ((Excel.Range)range.Cells[row, 5]).Text;
                       d.Time = ((Excel.Range)range.Cells[row, 6]).Text;
                       d.Att_Type = ((Excel.Range)range.Cells[row, 7]).Text;
                       listExcels.Add(d);
                   }
                   ViewBag.ListExcels = listExcels;
                   return View("Success");
               }
               else
               {
                   ViewBag.Error = "File type is incorrect<br>";
                   return View("About");
               }
           }
       }

What I have tried:

its says i m trying to change a string to int which i m not doing kinda newbie to coding so do help
this is the exact error on chrome

Server Error in '/' Application.
Cannot implicitly convert type 'string' to 'int'
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: Microsoft.CSharp.RuntimeBinder.RuntimeBinderException: Cannot implicitly convert type 'string' to 'int'

Source Error: 


Line 53:                     {
Line 54:                         Details d = new Details();
Line 55:                         d.UserID = ((Excel.Range)range.Cells[row, 1]).Text;
Line 56:                         d.Name = ((Excel.Range)range.Cells[row, 2]).Text;
Line 57:                         d.Enroll_ID = ((Excel.Range)range.Cells[row, 3]).Text;

Posted 27-Dec-17 19:06pm

Athfan

Updated 27-Dec-17 19:32pm

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Accepted Answer · 2017-12-27T19:32:00

Solution 2

use Int32.TryParse Method [^] to convert string values to integer

 int userId;
 bool isValid = int.TryParse( ((Excel.Range)range.Cells[row, 1]).Text , out userId);
if(isValid){
 d.UserID = userId
}
else
{
  // invalid Numeric Text present in the cell, notify it to the user.
}

Posted 27-Dec-17 19:32pm

Karthik_Mahalingam

Comments

Athfan 28-Dec-17 2:00am

thanks a lot guys as u said tryparse method helped

Athfan 28-Dec-17 2:03am

will that work the same for enroll_id

Karthik_Mahalingam 28-Dec-17 2:31am

if enroll_id is an integer type then it will work
it applies for all integer types.

Member 13587529 · Accepted Answer · 2017-12-27T19:26:00

The following looks suspicious (although I'm not a web development expert):

return View("About")

The return type of the method is an ActionResult.

Are you sure that the View function accepts a string (i.e., "About"), and that it yields an ActionResult?

Alternatively, cosider the following:

d.Enroll_ID = ((Excel.Range)range.Cells[row, 3]).Text;

The Text property will return a string. Is the Enroll_ID an int? Perhaps that is what is causing the problem. And are you sure that that particular Excel cell can't contain anything other than a numeric string?

The same is true for other properties on the 'd' object, like Date and Time.