Oh - that reminds me, I was able to setup an excel sheet as an ODBC source (on a windows server). However no one could edit the excel file to update it since it was locked by the ODBC driver. Hence my move to COM. Scott -----Original Message----- From: J. Cameron Cooper [mailto:jccooper@jcameroncooper.com] Sent: Monday, October 20, 2003 4:06 PM To: Zope Users Subject: Re: [Zope] Zope Advice for Java Man
Can I convert an Excel sheet to read into Zope?
If you mean looking at live data from Zope in Excel through ODBC or something then probably not unless you store your data in an external relational database (though I'm really not familiar with all those MS things).
--jcc -- "My point and period will be throughly wrought, Or well or ill, as this day's battle's fought." _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) The information contained in this email message may be privileged and is confidential information intended only for the use of the recipient or any employee or agent responsible for delivering it to the intended recipient. Any unauthorized use, distribution or copying of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately and destroy the original message and all attachments from your electronic files.
On Tue, 2003-10-21 at 00:11, Meilicke, Scott wrote:
Can I convert an Excel sheet to read into Zope?
If you mean looking at live data from Zope in Excel through ODBC or something then probably not unless you store your data in an external relational database (though I'm really not familiar with all those MS things).
--jcc
I've used xlhtml on linux to publish Excel staff rotas on a zope intranet. Home page is http://chicago.sourceforge.net/xlhtml. It will convert the xls to html. The only problems are with complex layouts where cells are merged vertically. Sometimes there are lots of blank cells appended to the end of each row. I haven't had time to work out if this is xlhtml or crud in the xls file. david
participants (2)
-
David Little -
Meilicke, Scott