Options for Working with Excel Files

[Manoj Chaurasia]

Hello,

 

I recently installed Tibco BusinessWorks 5.1.3 on my system to study it.

 

Does Tibco offer any adaptors/methods for reading, parsing, and transforming data contained in a Microsoft Excel Spreadsheet (.xls) file

 

If not, what are some successful strategies people have used in the past to work with .xls files

 

My ultimate goal is to see if BW is capable of reading data from an .xls file and transforming it to other useful file types or sending it out over a service.

 

Thanks in advance,

Nathan

 

Message was edited by: nholst@deloitte.com

[Manoj Chaurasia]

Just as a followup to this issue, it turns out TIBCO does NOT offer any adapters or methods of working with MS Excel files.

 

I ended up creating Java classes which used the JExcelAPI. The API is great for manipulating, creating, copying Excel files. To learn more about the API see: http://www.andykhan.com/jexcelapi/

[Manoj Chaurasia]

To read data from Excel file u can create aODBC connection and can use JDBC activity to access Excel file. I have tried this and it works but in this SQL queries are to be changed a bit to work with Excel

[Manoj Chaurasia]

depending if it's also an option for you:

 

since the newer versions of excel can save and read sheets in xml format;I once built something in bw that generates an xml file that is read by excel.

[Satish Battula 2]

Hi Team,

Could you please tell me how did you used 'JExcelAPI' in Tibco BW and how to defined java classes.

Please provide any implementation steps on this.