Thursday, February 23, 2017

Add Random Data in Spreadsheet

To add random data in spreadsheet you can use macro code, advantage to use this no more manual work. Use below code to generate data.

Public Sub ran()
Dim b As Range
    For i = 1 To 800000
        Dim r As Double
        r = Int(Timer * Rnd())
        Cells(i, 20).Value = 0
        Cells(i, 21).Value = "USD"
        Cells(i, 22).Value = ""
        Cells(i, 23).Value = "A clever fox just jump over the lazy dog"
        Cells(i, 24).Value = r
    Next i
End Sub

Dynamic data generated in "r" variable and rest of data is static.

Friday, February 10, 2017

Talend Startup Error

I have installed java 1.7 and 1.8 both on my machine and JAVA_HOME environment variable set to 1.7.
Here i am trying to start talend but it throws error:

"The Studio does not support Java 8. Java 7 is the recommended JVM version to be used"

Now how to start Talend on machine if both java version is installed on your machine


  • Open Cmd
  • Move to installed directory of Talend and run below command
  • TOS_DI-win32-x86.exe -vm "C:\Program Files (x86)\Java\jdk1.7.0_65\bin"

web stats