Export to Excel from a lotus notes database

Posted on 2008-11-19
Last Modified: 2013-12-18
Hi all,


1. Is there a way to get users to select the Columns/Fields that they need to export from a view as opposed to preset columns?

Reason, we have 100s of fields which not every user uses, those who only require to look/export five of those want to be able to select those 5 prior to the export so that theyre not lumped to endless/usless spreadsheet.

2. Also, is there a way that when a view is exported to Excel, those columns that are blank in the spreadsheet can then be hidden automatically.

For example, I have a view with 20 columns/displaying 20 fields values. Some users may have data in all of those fields and other have data in 5 of those view columns/fields only.  For those that have the 20 fields full, their exported spreadsheet will display 20 columns with their data, but for those who have 5 completed fields and the rest is blank, the spreadsheet should display only those 5 columns with their data and hide the rest of the columns.

By the way, I have already a few Export to Excel routines which Exports a Notes View as is to Excel.

Any help in this matter will be much appreciated.
Question by:varvoura
    LVL 46

    Accepted Solution

    Hi Varvoura,

    Almost anything "presentation" that goes beyond the point of "here's the data, do whatever you want with it" is not part of Lotus Notes. On other words, AFAIK there's no standard options in Notes or in Excel to do what you want.

    But you could write your own application to do that. Create an agent that first presents a DialogBox that asks for the user's options (remove empty columns, check data, whatever) and then exports directly to Excel. Seems very doable to me.
    LVL 63

    Assisted Solution

    1) Consider creating private views, or views for each specific need.

    I hope this helps !

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
    For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now