How To do Export To Excel In Browser

HCL Domino Domino Forum
1

Hi All of u ,any one can u tell me how to do export to excel in browser,in client it is working fine but in browser this code not working pls send me code for export to excel in web.

Thanks,

amar

2

Subject: Notes/Domino Export Utility

If you’d like to consider an export application specifically for Lotus Notes / Domino written totally in standard LotusScript (which fully supports web browsers) we have one which enables you to export Lotus Notes/Domino data from any database/view in the following formats:* CSV (comma)

  • Fixed Width

  • Tab Delimited

  • MS-Access

  • MS-Excel

  • MS-Word (rtf)

  • PDF

  • HTML

  • XML

Features include:

  • Full support for web browsers to create exports and navigate around databases & design elements just like a Notes client.

  • Databases which may be exported from can be controlled.

  • Wizard for selecting the Database, views & documents to export.

  • Exports can be scheduled to be run on a once-off basis or periodically - regularly, hourly, daily or weekly.

  • Exports can be run as a background agent thread on a Notes R6.x client.

  • Filtering of unwanted characters from exported data.

  • Data in view columns can be exported or you can select specific fields in documents.

  • File attachments and OLE objects in documents can be exported.

  • Selection criteria can be used to specify which documents to export - this can be a Notes selection formula, based on values of document fields or based on view column values.

  • Exported files can be saved to the filesystem or in the database. Filenames can be specified or determined from a Notes formula or document field value.

  • Exported files can be automatically emailed at the completion of an export.

  • View column formatting such as font, alignment, color, data type, etc can be exported.

  • You can supply your own customised pre-export and post-export LotusScript code which will be automatically executed before/after the export.

  • Unique design cache engine to speed up navigation and selection of design elements in databases

  • Additional special document information can also be exported - attachment names, document size, responses, note id, universal id, created, last modified, last updated by.

  • Full help documentation

  • Full logging and online debugging to help with troubleshooting of problems. Error logs can be easily sent to AGE Computer support at the click of a button.

  • Intuitive user interface

  • Full update history

  • And much more…

Single user license costs less than hour of a developer’s time.

For more information or to try a copy of the current version, please click the following link:

Regards,

Alex

3

Subject: How To do Export To Excel In Browser

I use a link on webpage that calls a LS Agent, I then use HTML to format the report (Excel formats incoming HTML pretty well), see extract below

'Sets the download to use Excel

Print |Content-Type:application/vnd.ms-excel|

'Triggers the save/open prompt instead of embedding the spreadsheet in the browser

Print |Content-Disposition:Attachment; filename="filenname.xls"|

On Error Goto errorHandler

 



Print |<Table border=0>|

Print | test|

etc,

4

Subject: RE: How To do Export To Excel In Browser

Here’s one I use (the basis of which I must have found in this forum)…

Dim s As New NotesSession

Dim db As NotesDatabase

Dim view As NotesView

Dim nv As NotesViewNavigator

Dim ne As NotesViewEntry

Dim doc As notesdocument



Set db=s.CurrentDatabase

Set view = db.GetView("ExportFN")

Set nv = view.CreateViewNav

Set ne = nv.GetFirst

'x=-1

Print |Content-Type:application/vnd.ms-excel|

’ Print {Hello Excel}

Print |Content-Disposition:Attachment; filename="ContactExport.xls"|



Print |<table border="1"><tr>|

Forall c In view.Columns		

	Print |<td width="225"><font face='Arial' color='0000CC' size=2><b>|+c.Title+|</b></td>|

'	x=x+1

End Forall

Print |</tr>|

x=Ubound(view.Columns)





While Not(ne Is Nothing)

'	Print |<tr><td>| +ne.ColumnValues(0)+ |</td></tr>|		

	

	Print |<tr>|

	For p=0 To x			

		Print |<td>| 

		Print(ne.ColumnValues(p))	

		Print |</td>|

	Next

	Print |</tr>|	

	Set ne = nv.GetNext( ne )

Wend
5

Subject: RE: How To do Export To Excel In Browser

Many Many thanx for your reply.Now one question is thatwhether excel is required in the client side ???

How to convert this excel to a pdf file/Is that any way to protect the excel sheet also so that no one can modify it???

6

Subject: How To do Export To Excel In Browser

I assume your code relies on having Excel installed on the client. The typical way to do this on the client is to directly manipulate the Excel objects.

Since your server probably doesn’t have Excel installed, that won’t work (and you’d still have to get to generated Excel file to the browser).

To to this for a browser client, I generally use this method to generate the Excel from an agent:

Make sure the agent executes the following print statement first:

Print “Content-Disposition:Attachment; filename=Report.xls” & chr$(13) & chr$(10) & chr$(13) & chr$(10)

This will tell your browser that the following data should be treated as a file to be downloaded.

Then, have the agent output an HTML table containing your data:

print “

”

for each document, create one table row containing the columns you need:

print “

”

print “

” & doc.field1(0) & “” & doc.field2(0) & “
”

I hope I haven’t forgotten anything important. This should get you started.