Best PeopleCode Examples | PeopleCode Hacks | Learn PeopleSoft Coding | How to PeopleCode | PeopleSoft Appdesigner Coding
Best PeopleCode Examples | PeopleCode Hacks | Learn PeopleSoft Coding | How to PeopleCode | PeopleSoft Appdesigner Coding Creating MSExcel with new sheets through peoplecode: Local object &oWorkApp, &oWorkBook; &sFilePath = "C:\temp\TEST_FL.xlsx"; &sFileDestPath = "C:\temp\Test.xlsx"; &oWorkApp = CreateObject("COM", "Excel.Application"); &oWorkApp.DisplayAlerts = "False"; ObjectSetProperty(&oWorkApp, "Visible", True); &oWorkBook = ObjectGetProperty(&oWorkApp, "Workbooks"); &oWorkBook.Open(&sFilePath); &oWorkSheet = &oWorkApp.Worksheets("Sheet1"); &oWorkSheet.Range("A1:C5").Font.Bold = True; &oWorkApp.WorkSheets.Add().Name = "Test"; &oWorkSheet = &oWorkApp.Worksheets("Test"); &oWorkSheet.Range("A1:C5").Font.Bold = True; &oWorkSheet.Cells(1, 1).Value = "I'm a...