Skip to main content

[archive] Add line in excell

  • November 15, 2007
  • 16 replies
  • 0 views
D

[Migrated content. Thread originally posted on 13 November 2007]

Hello,
I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.

    16 replies

    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    If you inquire the Worksheet object for its Rows (returning a range object), the returned range object can be inquired for its Count property I guess.
    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    If you inquire the Worksheet object for its Rows (returning a range object), the returned range object can be inquired for its Count property I guess.
    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    With the following line I can put the cursor to the last cell.

    MODIFY haExcel ActiveCell::SpecialCells(xlCellTypeLastCell)::Select()

    Can you tell me how to get the rowvalue for this cell ?
    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    With the following line I can put the cursor to the last cell.

    MODIFY haExcel ActiveCell::SpecialCells(xlCellTypeLastCell)::Select()

    Can you tell me how to get the rowvalue for this cell ?
    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    I don't think this will work, because it is returning you a cell object. I am not sure, but I suspect this will not tell anything about the position in the spreadsheet.
    Have you tried my suggestion above?
    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    I don't think this will work, because it is returning you a cell object. I am not sure, but I suspect this will not tell anything about the position in the spreadsheet.
    Have you tried my suggestion above?
    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    I don't think this will work, because it is returning you a cell object. I am not sure, but I suspect this will not tell anything about the position in the spreadsheet.
    Have you tried my suggestion above?
    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    only found this sample, but no cobol :(

    http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb06/hey0215.mspx
    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    only found this sample, but no cobol :(

    http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb06/hey0215.mspx
    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    Frosti,
    This is indeed the code I need. But I can't get it translated to Cobol.
    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    Frosti,
    This is indeed the code I need. But I can't get it translated to Cobol.
    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    Frosti,
    thank you very much for the link; very interesting.

    Ronny,
    you could use somethink like this:

    inquire HExcelWks
    @usedrange in HRange.

    modify HRange @select()
    modify HRange @specialcells(xlCellTypeLastCell)::activate()

    inquire HExcelAPP @activecell::row() = TmpN

    of course HRange is a handle of range and TmpN is a pic 9() that contains the rowvalue you're looking for.

    Please, let me know if it works.

    Ciao,
    Drox
    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    Frosti,
    thank you very much for the link; very interesting.

    Ronny,
    you could use somethink like this:

    inquire HExcelWks
    @usedrange in HRange.

    modify HRange @select()
    modify HRange @specialcells(xlCellTypeLastCell)::activate()

    inquire HExcelAPP @activecell::row() = TmpN

    of course HRange is a handle of range and TmpN is a pic 9() that contains the rowvalue you're looking for.

    Please, let me know if it works.

    Ciao,
    Drox
    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    Frosti,
    thank you very much for the link; very interesting.

    Ronny,
    you could use somethink like this:

    inquire HExcelWks
    @usedrange in HRange.

    modify HRange @select()
    modify HRange @specialcells(xlCellTypeLastCell)::activate()

    inquire HExcelAPP @activecell::row() = TmpN

    of course HRange is a handle of range and TmpN is a pic 9() that contains the rowvalue you're looking for.

    Please, let me know if it works.

    Ciao,
    Drox
    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    Drox,
    Thank you very much, ik works fine.

    :)
    D

    [Migrated content. Thread originally posted on 13 November 2007]

    Hello,
    I need to add lines in a existing excelfile. Can anybody tell me how i can determine the last line or range in the file.
    Drox,
    Thank you very much, ik works fine.

    :)

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement