Search results

  1. P

    Using delimiter while creating excel sheet in progress 4gl

    DEFINE TEMP-TABLE tt-arq FIELD nomeArq AS CHAR. CREATE tt-arq. tt-arq.nomeArq = "C:\damgra\excel\Test1.txt". CREATE tt-arq. tt-arq.nomeArq = "C:\damgra\excel\Test2.txt". CREATE tt-arq. tt-arq.nomeArq = "C:\damgra\excel\Test3.txt". CREATE "excel.application" chExcel. iQtArq = 0. FOR EACH...
  2. P

    Using delimiter while creating excel sheet in progress 4gl

    I have 3 .txt files and I am using COM-Handle to create an Excel sheet. Can anyone help me how to set the delimiter? My Excel sheet is getting created but the columns are not comma separated.
  3. P

    Password protection for excel file using COM-Handle

    Hi All, I am creating an excel file using COM-Handle. In one of the worksheet I need to add few properties as below: Protect this sheet with password ‘123’. It should be allowed to Selected locked cells, Select unlocked cells, Format Cells, Format Columns, Format Rows and Sort. Can someone...
Top