Dec. 8, 2014
2:39 p.m.
On 2014-12-08 15:22, Blondeau Vincent wrote:
Does someone know if there is a mean to access Excel sheets from Pharo to get data?
I don't want to use .csv files but .xls/.xlsx files.
If you're just going to use .xlsx files, it might be possible to unzip the file and peek the xml representation of that table (not that I've done it though). If you're going to support .xls / Excel < 2003 files, you will probably need a COM-bridge. I remember that I've seen it for Squeak in the past, I don't recall having seen it for Pharo. Another kind of hackish solution could be setting up an ODBC driver for Excel files and then using DBXTalk/ODBC or the ConfigurationOfODBC-based package.