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; }

Aporvi Ji · Answer

Awesome! Ketan Thanks you very much :-)

Aporvi Ji · 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 :)