Updating Existing Xcel Spreadsheet

HCL Domino Domino Forum
1

Has anyone has a script that updates an xcel spreadsheet based on an IDNumber, that is the script should first check for a matching IDNumber in Xcel and update the record (row) with the Matching notes document without opening the Xcel spread sheet (in the Backround).

I’ve tried doing this but even if I format ID number to be text in Xcel. my search or select statement returnan mismatch error or Spreadsheet is full error. even if there are few record in an excel spreadsheet.

Plz Help…

2

Subject: Updating Existing Xcel Spreadsheet

The basic workflow is:Find sheet

Open sheet

Read cell in row 1 that contains your key.

Compare value to what you’re trying to find.

If it matches, update the data

If not, read row next

Repeat until done

I think if you’ve defined the sheet as an odbc data source, you should be able to use sql-like commands and select data, but I’m not totally sure how you’d go at this.

HTH

Doug

ps- posting some code might help…