Re: Import and Export between Excel and Oracle using PL/SQL

"a" <dbadba62_at_hotmail.com> wrote in message news:<hkn28.5022$At4.4489_at_nwrddc02.gnilink.net>...

> But can I get the xls file with Chart in it or I have to manually convert
> the excel data to chart every time?

Unfortunately, you cannot add charts with Spreadsheet::WriteExcel although you can add images.

Also, it should be noted that there is currently a 255 char limit on strings which means it won't be suitable for many applications. However, this will change when the underlying file format moves from Excel 5 to Excel 97+.

See: http://freshmeat.net/projects/writeexcel/

John.

--