Export to Excel via the Web

View member feedback to this tip.

I found this to be the fastest and best way to export a view's data to Excel. It keeps the formatting specified in the view as well as columns such as total and categories. The best part is that it is super fast.

Code

Put this code into a agent to be run manually from action menu. You can then copy it into any database from which you want to export a view. The replacesubstring function was copied from Ultimate Replacesubstring Function on SearchDomino.com. Thanks to its developer, Scott Bockelman.

MEMBER FEEDBACK TO THIS TIP

This agent does not work as advertised. When run from the Web, it does nothing. When run from the Notes client, it creates a spreadsheet, but the spreadsheet only includes the view column headings. It does not include the view data.

-- Tony G.

********************************************************

It has potential to be a great tip, but unfortunately has these problems:

1. Says "via Web" but appears to be a LotusScript agent to be run from Notes client (am I missing something)?
2. Does not work as-is: for example, it has "Exit Function" statement without a beginning Function statement.
3. Generates error "WEBREDIRECT not valid" and I'm using Excel 2000. Excel version (required, or at least what the author uses) should be indicated.

-- ...

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT LotusScript 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 LotusScript code rebuilds corrupted busytime.nsf file Soft-code item names to facilitate LotusScript management LotusScript agent automates selective mail file replication LotusScript filters and attaches files to a Notes form LotusScript 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 LotusScript agent automates selective mail file replication

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

Samir

********************************************************

Unless I'm missing something, I don't understand how this agent can work via the Web. The UI classes are not supported there, not to mention that there is no view context when running an agent from the Web. It does look like it would work fine run from the Notes client. Perhaps the title of the article is just incorrect.

-- Scott D.

********************************************************

Looking at my tip again, I found out that I forgot to mention that the database needs to be on server that has an HTTP task running on it. Also, "via the Web" in the name doesn't mean it is a Web agent -- sorry for the confusion! It is a Notes-based agent that uses an HTTP task to export data to Excel.

Sorry for the trouble.

-- Amit Kamat

********************************************************

Not as useful as the Export to Excel code I found elsewhere. (Most likely the Sandbox), which can export any view to any Excel spreadsheet three different ways. All by view, selected in the view and custom by fields on the form. I put this code into every custom database I create because it never fails, the user wants to sort it their own way.

Program was developed by Greg Vandeligt. -- Leslie M.

Do you have comments of your own? Let us know.