Categories > OpenTBS with XLSX >

Export data to excel

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: suneel
Date: 2011-06-14
Time: 10:07

Export data to excel

Hello,

I am a newbie to tbs and after some study i was able to integrate TBS for my site.

I have a page which will fetch the data from Database and display using TBS. I need to provide an option to export to excel. Could you please help me in suggesting a link or a code.

i have referred http://www.tinybutstrong.com/plugins/excel/tbs_plugin_excel.htm link but for this we need to have an XML page and fetches the data.

Can i have a better solution than this.

Thanks in advance!!!
By: Skrol29
Date: 2011-06-14
Time: 11:48

Re: Export data to excel

Hello,

I suggest that you use OpenTBS, it works with TinyButStrong.
See documentation and examples at:
  http://www.tinybutstrong.com/tools.php
By: suneel
Date: 2011-06-14
Time: 11:58

Re: Export data to excel

Thanks for the quick response. It looks great will try it.


By: suneel
Date: 2011-06-14
Time: 12:50

Re: Export data to excel

I am trying to export excel using TBS then i get the below warnings in excel.

Warning: Parameter 4 to clsTbsExcel::BeforeMergeBlock() expected to be a reference, value given in C:\xampp\htdocs\adm\lib\tbs_class_php5.php on line 2736

Notice: Undefined property: clsTbsExcel::$ssIndex in C:\xampp\htdocs\adm\tbs_plugin_excel.php on line 105

Do any one know the fix which need to be applied.

Thanks!!!
By: Skrol29
Date: 2011-06-15
Time: 00:17

Re: Export data to excel

What is your version of TBS and which version of the Excel plug-in ??
By: suneel
Date: 2011-06-15
Time: 15:29

Re: Export data to excel

I am using TBS - Version  : 3.6.1 and  plug-in: Excel Worksheets Version 1.0.5.
By: Skrol29
Date: 2011-06-15
Time: 23:14

Re: Export data to excel

Hi,

The bug you have seems to be fixed in the last version of the Excel plug-in (version 1.1.0).
http://www.tinybutstrong.com/plugins/excel/tbs_plugin_excel.htm#changelog

Note: Excel plug-in version 1.1.0 works with TBS version 3.6.2 or higher
By: Suneel
Date: 2014-10-20
Time: 14:41

Re: Export data to excel

Please suggest.