Reading Values from Excel

Posted by .Netlearner under C# on 11/23/2012 | Points: 10 | Views : 1987 | Status : [Member] | Replies : 5

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hello All,

Am Currently Converting a project from vb to C# in .NET.

I Got Struck With the Following Code while trying to read values of cell from the excel file.Can Anyone please shed some light on this issue .

sheet.Cells[i, 1].ToString()

where i has incremented value .

But Its not working.It returns just the Sys_Object value.

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Nkkppp on: 11/23/2012 [Member] Starter | Points: 25

0	Hi, I am not aware of Vb though, below is a code translator. Try below link http://www.carlosag.net/Tools/CodeTranslator/ ---Prathap .Netlearner, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Krv on: 11/23/2012 [Member] Starter | Points: 25

0	You can try the below one sheet.Cells[i, 1].Value2 http://www.dotnetfunda.com/forums/thread5897-how-to-get-single-value-from-excel-sheet-using-csharp.aspx Thanks, R.Vasanth MCTS(SQL Server & BI) http://bigdatatech.blogspot.com .Netlearner, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: .Netlearner on: 11/24/2012 [Member] Starter | Points: 25

0	do { string value = ""; Range r = (Range)sheet.Cells[vExlTRow, 1]; value = r.Value2.ToString(); Range r1 = (Range)sheet.Cells[vExlTRow, 2]; string value1 = r1.Value.ToString(); if ((value != "") \|\| (value1 != "")) { vExlTRow = vExlTRow + 1; } else { break; } } while (true); I Want to Count the Total Number of rows in my excel file. I Have writtern the above code. If i have 5 rows in my excel its executing properly for the 5 times and when its becomes 6 Instead of return null value Its returning Sys_Object There by causes the error object reference.Kindly Guide me through this .Netlearner, if this helps please login to Mark As Answer. \| Alert Moderator


        do

        {

            string value = "";

            Range r = (Range)sheet.Cells[vExlTRow, 1];

             value = r.Value2.ToString();

           Range r1 = (Range)sheet.Cells[vExlTRow, 2];

            string value1 = r1.Value.ToString();

            if ((value != "") || (value1 != ""))

            {               

         

                vExlTRow = vExlTRow + 1;

            }

            else

            {

                break;

            }

        } while (true);

I Want to Count the Total Number of rows in my excel file. I Have writtern the above code. If i have 5 rows in my excel its executing properly for the 5 times and when its becomes 6 Instead of return null value Its returning Sys_Object There by causes the error object reference.Kindly Guide me through this

.Netlearner, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: .Netlearner on: 11/24/2012 [Member] Starter | Points: 25

0	Range rvCou = (Range)sheet.Cells[vExlRow, vCou]; Its not reading the NULL value.It causes the error can anyone please guide me.How to include null values while reading the excel file .Netlearner, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: perfectchourasia-9163 on: 11/30/2012 [Member] Starter | Points: 25

0	http://sandeep-chourasia.blogspot.in/2012/04/read-excel.html ER sandeep chourasia sandeepchrs@yahoo.com (on facebook) http://www.aspnetcodes.com/ .Netlearner, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts