You need to sign in to do that
Don't have an account?
How to implement excel's macro in visualforce ??
Hi all,
I want to implement macro and formula in visualforce that can handle the auto deletion of blank rows of excel and auto calculation of cell values. i know macro but i dont know how to implement it.
my macro code is ::
Public Sub RemoveEmptyRows()
Dim LastRow As Long, CurrentRow As Long
Dim EntireRow As Range
LastRow = Cells.Find("*", SearchDirection:=xlPrevious, SearchOrder:=xlByRows).Row
For CurrentRow = LastRow To 1 Step -1
Set EntireRow = Cells(CurrentRow, 1).EntireRow
If Application.WorksheetFunction.CountA(EntireRow) = 0 Then EntireRow.Delete
Next CurrentRow
End Sub
Is there any idea to implement excel formula or macro during download an excel file to visualforce page?
Thanks in advance
R.K