Open a .XLS file

HCL Domino Domino Forum
1

hi all, i have a .xls file,that i have saved in the server with proper cell format.Now i want to open the .xls sheet through my application.how can i do this??

2

Subject: open a .XLS file

You can do an import like:uidoc.Import(“Microsoft Excel”, “your file.xls”)

but I an not sure what you will get here.

Alternatively you can create in LS an object of th MSExcel application and do you manipulation there.

Like:

Set xlapp = CreateObject(“Excel.Application”)

Set xlsheet = xlapp.Workbooks(1).Worksheets(1)

your_field = xlsheet.Cells(row, col).Value

3

Subject: RE: open a .XLS file

actually i dont want to manipulate excel sheet every time.i have a formatted excel sheet that i have to open only.

4

Subject: RE: open a .XLS file

pathToExcelBook := “c:\path\file.xls”;@Command( [Execute] ; pathToExcelBook ; pathToExcelBook )

or, in LotusScript, use

pathToExcelBook = “c:\path\file.xls”

intReturn = Shell({“C:\Path to Office\excel.exe” “} & pathToExcelBook {”}, 3)

5

Subject: open a .XLS file