How to read Excel (.xls) file in OScript?

Please tell me the procedure to read an excel file using OScript.

In excel file, each row will have a file name and attribute values.

Find more posts tagged with

Comments

If it is a CSV file oscript can directly read the file using the File Object.If it truly is xls or xlsx you might need some kind of a bridge.

Are you familar with calling a java object from oscript which we call the Oscript Java Bridge. Please do not confuse it with Java Development.There probably is something of a excel driver for java.Then I would do oscript->POJO->Excel

OT has code (probably not for free) but will allow reaching out to MS Office.You may have to ask their Prof Svcs