Archives

Java Code: Salesforce Export into Excel

Export Salesforce records into Excel. In my example I read records from Excel and also from Salesforce. Reuse my code by providing your own username and password to your Salesforce org to create more advanced SFDC to Excel integrations. You will need to download or add jxl to your maven project: http://mvnrepository.com/artifact/net.sourceforge.jexcelapi/jxl

Rate this:

Read More

Excel Programming – VBScript Advanced

Creating a VBScript to update tables from a spreadsheet: For RowCount = 2 To Worksheets(“Data”).UsedRange.Rows.Count() + 1 If Worksheets(“Data”).Cells(RowCount, 1) = cmbYear.Text Then For tables = 0 To 2 If Worksheets(“Data”).Cells(RowCount, 6) = servicetypes(tables) Then For brands = 0 To 4 If Worksheets(“Data”).Cells(RowCount, 5) = arrbrands(brands) Then For salestage = 0 To 2 If CInt(Left(Worksheets(“Data”).Cells(RowCount, […]

Rate this:

Read More