Tips&Tricks: Excel Automation

2»

Comments

  • bonsai
    bonsai Member Posts: 14
    Any idea how to edit existing excel?
  • geronimo
    geronimo Member Posts: 90
    bonsai wrote:
    Any idea how to edit existing excel?
    check the function Procedure OpenExistingXlsWorkbook in the first post of this topic. Here an existing excel is opened.
  • Sog
    Sog Member Posts: 1,023
    Another tip for importing trough the excel buffer.
    When importing textfields that may never be parsed as decimal you can check if the cel property is text with this "extension" for the Excel buffer:
    Function Readsheet

    Replace
    IF IsDecimal("Cell Value as Text") THEN
    with
    IF IsDecimal("Cell Value as Text") AND (FORMAT(XlWrkSht.Range(xlColID+xlRowID).NumberFormat) <> '@') THEN

    Numberformat has for the file I've imported the values Standard (for non-formatted cells), @ (for text cells) and (jj/mm/dd for datefields (depends on the dateformat used)).
    |Pressing F1 is so much faster than opening your browser|
    |To-Increase|

Categories