try
    {
        String ProjId = (String) cmbProj.getSelectedItem();
        GlobalObjectManager elm = session.getGlobalObjectManager();
        String projWhereClause = "Id like " + "'" + ProjId + "'";
        String[] mSpreadFields = ResourceAssignment.getSpreadFields();
        System.out.println(projWhereClause);
        Project proj = elm.loadProjects(new String[]{"Id", "Name"}, projWhereClause, null).next();
        System.out.println(proj.getId());
        String whereClause = "ProjectId like " + "'" + proj.getId() + "'";
        BOIterator<Activity> boiA = proj.loadAllActivities(new String[]{"Id", "Name", "StartDate", "FinishDate"}, whereClause, "Id asc");
        while (boiA.hasNext())
        {
            Activity activity = boiA.next();
            //System.out.println(activity.getId() + "      " +activity.getStartDate()+ "      " +activity.getName() + "      " +activity.getFinishDate());

            System.out.println("STEP 1 In Activity loop");
            BOIterator<ResourceAssignment> act = proj.loadAllResourceAssignmentsWithLiveSpread(new String[]{"ResourceId", "ActivityId", "PlannedUnits", "ResourceName"}, null, null, mSpreadFields, SpreadPeriodType.MONTH,
                    activity.getStartDate(), activity.getFinishDate(), false);
            while (act.hasNext())
            {
                ResourceAssignment act2 = act.next();
                //System.out.println(act2.getActivityId() + "--" + act2.getResourceId());
                if (act2.getActivityId().matches(activity.getId()))
                {
                    System.out.println("STEP 2----" + "Resource- " + act2.getResourceName());
                    Iterator<com.primavera.common.value.spread.SpreadPeriod> spreadIterator = act2.getResourceAssignmentSpread().iterator();
                    while (spreadIterator.hasNext())
                    {
                        int PV;
                        String d;

                        com.primavera.common.value.spread.SpreadPeriod spr = spreadIterator.next();
                        //System.out.println("STEP 3----" + spr.getSpreadBucketTypeEnum() + "------" + spr.getUnits("PlannedUnits"));

                         String date = new SimpleDateFormat("MM/dd/yyyy").
                        format(new SimpleDateFormat("EEE MMM dd HH:mm:ss zzz yyyy").parse(spr.getSpreadPeriodStart().toString()));
                        d = date;
                        PV = ExcelFileReader.fileReader(ProjId, ProjId, act2.getResourceId(), activity.getId(), d);
                        com.primavera.common.value.Unit PVU = new com.primavera.common.value.Unit(PV);
                        spr.setUnits("PlannedUnits", PVU );

                        act2.setPlannedUnits(PVU);
                        System.out.println(activity.getId()+  "----" + act2.getResourceId()  + "----" + d + "----" + spr.getUnits("PlannedUnits") + "   ExcelFile PV    =   " + PV);



                    }

                }
                act2.update();

            }


        }
 } catch (Exception e) {
        e.printStackTrace();
    }

finally {
        // Delete the business objects that were added

        System.out.println("Logout");
        session.logout();
    }