Wednesday, March 7, 2012

How to read a cell of Excel in Script task?

BTW, I cannot use Office automation because MS office is not installed on the machine.

Thanks,
Without using office automation, you are quite limited to what you can get out.
Either use Excel Source, which is like a flat table of rows and columns, or a 3rd party product like Data Defractor which allows you to "drill" into the document and return specific areas.

No comments:

Post a Comment