converting a VBA code in C#

Question

I would like to convert this VBA code in C#

Can anyone please help.

Dim Lrow,LColumn as Long 
Sheet1.Activate 
If WorksheetFunction.CountA(Cells) > 0 Then 
LRow = Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row 
LColumn = Cells.Find(What:="*", After:=[A1], SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column 
End If

ketan borsdiya · Answer

Hi Aporvi, Replace your code snippet with my code and enjoy, long Lrow = 0, LColumn = 0; //Sheet1.Activate(); int dataCount = (int)excel.WorksheetFunction.CountA(ws.Cells); if (dataCount > 0) { Lrow = ws.Cells.Find("1", ws.get_Range("A1"), Type.Missing, Type.Missing, XlSearchOrder.xlByRows, XlSearchDirection.xlPrevious).Row; LColumn = ws.Cells.Find("1", ws.get_Range("A1"), Type.Missing, Type.Missing, XlSearchOrder.xlByRows, XlSearchDirection.xlPrevious).Column; }

Guest User · Answer

Awesome! Ketan, Thanks you very much :-)

Guest User · Answer

Thanks, With your help I reached with this code but: long Lrow = 0; long LColumn = 0; xlWorkSheet.Activate(); int dataCount = (int)xlApp.WorksheetFunction.CountA(xlWorkSheet.Cells); if (dataCount == 0) { // All cells on the worksheet are empty. } else { // There is at least one cell on the worksheet that has non-empty contents. { Lrow = xlWorkSheet.Cells.Find(What: "*", After: xlWorkSheet.Cells[1, 1], SearchOrder: xlByRows, SearchDirection: xlPrevious).Row; LColumn = xlWorkSheet.Cells.Find(What: "*", After: xlWorkSheet.Cells[1, 1], SearchOrder: xlByColumns, SearchDirection: xlPrevious).Column; } } This Keywords: xlByRows & xlByColumns This Keyword: xlPrevious shows Error in the above code.

Francis · Answer

We can't help on this much. Just try with C# and let us know the "specific" error, if you receive any.

Suvendu Shekhar Giri · Answer

long Lrow = 0; long LColumn = 0; Sheet1.Activate(); if (WorksheetFunction.CountA(Cells) > 0) { Lrow = Cells.Find(What: "*", After: A1, SearchOrder: xlByRows, SearchDirection: xlPrevious).Row; LColumn = Cells.Find(What: "*", After: A1, SearchOrder: xlByColumns, SearchDirection: xlPrevious).Column; } I have converted this using a free online tool from Telerik. Check following link- http://converter.telerik.com/ Hope, it helps :)

converting a VBA code in C#

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (5)