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

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.

Cannot implicitly convert type 'string' to 'int'

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Cannot implicitly convert type 'string' to 'int'

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us