Mit Lotusscript eine Excel-Tabelle erstellen und mit Daten aus dem Notes-Dokument füllen

In diesem Beispiel wird eine Excel-Tabelle erstellt, die Überschriften gesetzt und von einem Notes-Dokument die Felder als Spalte in die Excel-Tabelle übertragen.

 

    Dim xlApp As Variant     Dim xlSheet As Variant     Dim doc as notesdocument     set doc = "Hier wird das Notes-Dokument gesetzt!"     Set xlApp = CreateObject("Excel.Application")     xlApp.Visible = True     xlApp.Workbooks.Add     xlApp.ReferenceStyle = 2     xlApp.StatusBar = "Hier kommt deine Statusmeldung !"     Set xlSheet = xlApp.Workbooks(1).Worksheets(1)     ' Titelzeile     xlSheet.Cells(1,1) = "Überschrift Spalte 1"     xlSheet.Cells(1,2) = "Überschrift Spalte 2"     xlSheet.Cells(1,3) = "Überschrift Spalte 3"     xlSheet.Cells(1,4) = "Überschrift Spalte 4"     ' 2. Zeile     xlSheet.Cells(2,1) = doc.GetItemValue("DeinFeld1")(0)     xlSheet.Cells(2,2) = doc.GetItemValue("DeinFeld2")(0)     xlSheet.Cells(2,3) = doc.GetItemValue("DeinFeld3")(0)     xlSheet.Cells(2,4) = doc.GetItemValue("DeinFeld4")(0)

    xlApp.StatusBar = "Formatiere Zellen  !"     xlApp.Range(xlSheet.Cells(4,1), xlSheet.Cells(row,15)).Select     xlApp.Selection.Columns.AutoFit     xlApp.Range("A1").Select     xlApp.StatusBar = "Fertig  !"

 

 

Suche

Neueste Kommentare

  • 1 week 3 days ago
    Failed to authenticate on SMTP server with username gmail.com using the following authenticators: "LOGIN", "PLAIN", "XOAUTH2". Authenticator "LOGIN" returned "Expected response code "235" but got code "535",

    Update two fields (blob) in Table "config"!

    Search 'name': 

    1. smtp.settings 
    2. symfony_mailer.mailer_transport.smtp

     

     

  • 3 weeks 1 day ago
    The following embed button(s) are not using SVG icons and will not be compatible with CKEditor5

    Admin:

    • /admin/config/content/embed/button/manage/media
    • /admin/config/content/embed

     

    Convert PNG to SVG & Upload!

  • 3 weeks 5 days ago
    The following Apache modules are disabled on the destination server: security2.

    ModSecurity install & config & activate

  • 2 months 1 week ago
    TypeError: Cannot assign null to property Drupal \ views \ Plugin \ views \ argument \ ArgumentPluginBase::$operator of type string

    Das geht auch:

          $this->operator = $break->operator ?? '' ;
  • 2 months 3 weeks ago
    Bootstrap 5 subtheme is not properly configured. This may be caused by a problem with file or directory permissions.
  • 2 months 1 week ago
    TypeError: Cannot assign null to property Drupal \ views \ Plugin \ views \ argument \ ArgumentPluginBase::$operator of type string

    It works too:

    • web/core/modules/views/src/Plugin/views/argument/NumericArgument.php 

    Line 63, 96 :

  • 3 months ago
    Site URI : http://default (Drupal, how2 update config?)

    Add this line to drupalroot/vendor/drush/drush/drush.yml

  • 4 months 1 week ago
    Webserver CPU Performance Test mit PHP

    Time: 0,19 

    CPU: AMD Ryzen 7 PRO 3700 8-Core Processor

  • 5 months 3 weeks ago
    TypeError: Cannot assign null to property Drupal \ views \ Plugin \ views \ argument \ ArgumentPluginBase::$operator of type string

    Line 63, 99 :

  • 6 months 3 weeks ago
    Drupal + Basic_Auth Problem : You do not have permission to access this page (Sie haben keine Zugriffsberechtigung für diese Seite. )

    My problem was: