Home > Ask the Domino Experts > Domino Development Questions & Answers > Accessing Excel file through LotusScript without MS Office installed
Ask The Domino Expert: Questions & Answers
EMAIL THIS

Accessing Excel file through LotusScript without MS Office installed

Andre Guirard EXPERT RESPONSE FROM: Andre Guirard

Pose a Question
Other Domino Categories
Meet all Domino Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 19 May 2005
I'm trying to access an Excel file through LotusScript. But since Microsoft Office was not installed in my computer, the code prompts an error because it is not possible to create the automation object. Do you know a solution for this problem (without having to install MS Office)?

>
It sounds like you're using OLE automation. The Notes client doesn't understand Excel format, so it has to communicate with intermediate software -- such as MS Office -- that does know how to read this file.

As I see it, your options are:

  • Use some other software that knows the Excel file format and has an OLE interface. Lotus 1-2-3 might do.
  • Use some other software that has a non-OLE API and understands Excel format -- I don't know of one offhand but such software might exist.
  • You might be able to create an ODBC connection to the file and use ODBCConnection or the LC LSX to read it. The problem here is that I'm not sure whether you can get the ODBC driver for that except as part of Office.
  • Learn the Excel file format and write an agent in Notes that uses the NotesStream class to read in the file. Admittedly, this is a lot of work.


    Do you have comments on this Ask the Expert question and response? Let us know.


  • Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



    RELATED CONTENT
    Domino Development
    Can I create and copy Microsoft Excel spreadsheets with LotusScript?
    'Illegal circular use: Audit Trail' error when opening Lotus Notes docs
    How to make computed fields recalculate
    Sending and logging faxes from Lotus Notes and Domino
    Accessing documents in a Lotus Notes database
    Adding an action to the Lotus Notes right-click menu
    Writing temporary text files that email as attachments
    Trapping the on-click event of a radio button
    Copying a form object using LotusScript
    Connecting to a remote DB2 server with LEI

    LotusScript
    LotusScript agent parses ACL to Microsoft Notepad
    LotusScript finds the first occurrence of a string from the right
    Clear Recent Contacts view and prevent repopulation in Lotus Notes 8.x
    Search Microsoft Active Directory with LotusScript
    Three steps to trap and handle save conflicts with LotusScript
    Troubleshoot agents by displaying LotusScript variables online
    LotusScript sorts lists alphabetically
    Run or restart Notes/Domino agents via text messages
    LotusScript code rebuilds corrupted busytime.nsf file
    Soft-code item names to facilitate LotusScript management

    Lotus Notes Domino Coding and Development
    Tutorial: 30 LotusScript tips
    A bevy of Notes/Domino development tips
    A Formula language for Lotus Notes introduction -- 7 tips in 7 minutes
    Top 10 Notes/Domino developer tips of 2006
    Sending and logging faxes from Lotus Notes and Domino
    Accessing documents in a Lotus Notes database
    A smorgasbord of Notes/Domino development tips
    Creating a Lotus Notes view column categorized by month
    A project-tracking application for Lotus Notes Domino
    What the new Office means for developers

    RELATED RESOURCES
    2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
    Search Bitpipe.com for the latest white papers and business webcasts
    Whatis.com, the online computer dictionary



    Search and Browse the Expert Answer Center
    Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
    Browse our Expert Advice



    Lotus Notes Domino on Blackberry and mobile devices
    HomeTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersDomino IT Downloads
    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Site Map




    All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
      TechTarget - The IT Media ROI Experts