Categories > [old] TbsOoo & TinyDoc >

DB to XLS: Office 2007

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Dynamic
Date: 2007-12-01
Time: 14:58

DB to XLS: Office 2007

Hello,
I have modified the XLS example to suit my problem to display database entries in spredsheet. But strangely it does not open in Office 2003. Is there a way out of this problem? :(
By: Skrol29
Date: 2007-12-02
Time: 23:40

Re: DB to XLS: Office 2007

You probably mean Office  2007, not Office 2003.
I've tested that yet. I know Office 2007 has a new file format that is based on zipped XML.


By: Dynamic
Date: 2007-12-04
Time: 05:50

Re: DB to XLS: Office 2007

Sorry, I tried it on other system and Office 2003 works like magic. But Office 2000 does not. :(
By: Dynamic
Date: 2007-12-04
Time: 05:51

Re: DB to XLS: Office 2007

Sorry, I should have clarified that I use Office 2007 and it works in Office 2003 as well. Office 2000 does not appear to work with the XLS... That's the problem.
By: Skrol29
Date: 2007-12-04
Time: 10:50

Re: DB to XLS: Office 2007

Hi,

The XML Spreadsheet format is support since Excel 2002 only.
This is specified in the plug-in manual.

http://www.tinybutstrong.com/plugins/excel/tbs_plugin_excel.htm
By: Dynamic
Date: 2007-12-04
Time: 17:50

Re: DB to XLS: Office 2007

Oops! I am sorry to have missed it. But Skrol29, I must really thank you for the wonderful plugin. The normal PHP has been a nuisance and has been failing if there were new lines in the fields but the plugin seems to work like magic in those rare cases (at least in my experience)!

Thanks again,
:)