Open password protected Excel file?

Support for DataSlave

Moderators: Tom, ian

Open password protected Excel file?

Postby sims » Tue Oct 12, 2010 4:45 pm

Is there a way for Dataslave to issue a password when reading a MS Excel file that is password protected?

Thanks,
Jim
sims
 
Posts: 1
Joined: Tue Oct 05, 2010 5:59 pm

Re: Open password protected Excel file?

Postby ian » Tue Oct 12, 2010 4:53 pm

We do not currently support this in the Excel Object. We could potentially add it.

The one possibility now might be to use OLE DB Read object rather than the Excel Read object. OLE DB supports reading and writing From/To Excel so it might well support password protected spreadsheets.

There are some posts on this forum for using OLE DB to write to Excel so these will show the format.
ian
 
Posts: 364
Joined: Sat Dec 18, 2004 8:13 am
Location: UK


Return to Support

Who is online

Users browsing this forum: No registered users and 1 guest

cron