Stack Overflow
Stack Overflow

Questions tagged [opentbs]

OpenTBS is a PHP tool that enables you to create MS Office, LibreOffice, and OpenOffice documents using templates. It natively supports docx, xlsx, pptx, odt, ods, and odp.

OpenTBS is a PHP tool that enables you to create MS Office, LibreOffice, and OpenOffice documents using templates. It natively supports docx, xlsx, pptx, odt, ods, and odp.

You can just create a document using MS Office, LibreOffice, or OpenOffice; you can then use this document as a template for OpenTBS, which helps you to merge data, change parts, and get the result as direct download, a saved file, or a binary string in a variable.

Some supported features :

  • Merges data items, records, blocks, conditionals blocks;
  • Change pictures in documents;
  • Change Charts in DOCX, XLSX;
  • Hide/show sheets in XLSX and ODS;
  • Delete comments;
  • Support native connectivity with MySQL, PostgreSQL, or SQLite, PDO;
  • All features of the TinyButStrong Template Engine

Links :

195 questions
0
votes
0 answers

How to make more than one page with OpenTbs?

I want to make a report receipt, if more than one then the data will be displayed on the next page, the following code that I have made : [dataJmn;block=begin] [onshow.~tablename.DetilProduct;noerr] [dataJmn;block=end] Thanks Edited : So, the above…
KuliCoding
  • 3
  • 1
  • 4
0
votes
1 answer

How to merge multiple labels on one page with openTBS?

I am wondering what is best approach in handling multiple merges on one page. Something like such an official avery address label template: My goal is to create a docx template for address labels and than process it with openTBS so that every db…
pauel
  • 908
  • 10
  • 26
0
votes
2 answers

Changepic and keep original image size with adjust parameter

I have a template in which I'm attempting to change the source of a picture from Image 1, to Image 2 - yet I want Image 2 to keep the original size it was uploaded to the server in. (I want it in the position of Image 1, but its own dimensions.) To…
Chris
  • 5,882
  • 2
  • 32
  • 57
0
votes
2 answers

Change Text Colour of Part of a string in OpenTBS

I'm building a large word document, and need to change the text colour of 'part' of a string, only. I've found similar questions in a few places here, here and here, but where my problem seems to differ, is that I only wish to colour part of a…
Chris
  • 5,882
  • 2
  • 32
  • 57
0
votes
1 answer

merge 2 file docx use tbszip

I' using OpenTBS to merge 2 file docx. include_once('tbszip.php'); $zip = new clsTbsZip(); // Open the first document $zip->Open('file-1.docx'); $content1 = $zip->FileRead('word/document.xml'); $zip->Close(); // Extract the content of the first…
riddlevn
  • 1
  • 1
  • 2
0
votes
1 answer

OpenTBS exceeding maximum execution time

I've this massive array which, unfortunately, has to be processed by the OpenTBS class. I'd rather a smaller array and apparently so does OpenTBS as it is exceeding its maximum execution time. It can't be my query as I timed that at 2.3 seconds when…
PwnageAtPwn
  • 431
  • 1
  • 6
  • 21
0
votes
1 answer

How to save a file from database to server in php

I have a database table to store my templates(.docx file). I am using openTbs to work on that templates.My need is that to take out the template and store it in thee server itself, and edit using openTbs. My question is that how I can retrieve…
Vivek Balachandran
  • 79
  • 7
0
votes
1 answer

opentbs how can I update a tag?

I need to output a table and each cell will have a different background colour depending on the value. The ranges might be something like 0-25 will have a red background, 26-50 orange, 51-75 yellow and 76-100 green. My template is a word document…
Matt
  • 251
  • 4
  • 13
0
votes
1 answer

opentbs and jQuery Mobile

I'm making an web app that allow user to input form and generate word document. The form is relatively complex and I use a lot of jQuery and jQuery Mobile framework. I try to plugin the demo from opentbs ut it seems like it doesn't do anything when…
mishxpie
  • 38
  • 8
0
votes
1 answer

OpenTBS: How to dynamically change color of rows in a table

I use a table in docx file with the following rows: [b.num;block=w:tr] [b.name] In PHP, I use $TBS->MergeBlock('b', $data_1); which adds the content from the $data_1 array. The question is, how can I dynamically control the text color in each row,…
vigour
  • 45
  • 1
  • 8
0
votes
1 answer

Inserting a bullet point and styling to [onshow.] entires in openTBS

I was wondering if there was a way to pass through a bullet point and a basic CSS colour styling for the bullet point via the variable that gets applied via onshow. IE $string = '• The rest of the string'; $TBS…
opm881
  • 3
  • 3
0
votes
1 answer

Sample Scatter Excel Chart using OpenTBS

Can anybody give me an example of how to create an Excel Scatter chart using OpenTBS/TinyButStrong? And are there any commercial/non-commercial PHP excel writers that support excel charts? Will really appreciate your help. Thank you for your time!
chums
  • 3
  • 2
0
votes
0 answers

Place images next to eachother in docx

[audit; block=begin; comm=w:p; sub1=image] --PageBreak-- [audit_sub1; block=begin;] ImageElement [audit_sub1.path;ope=changepic;from=[val];default=current;adjust] [audit_sub1; block=end;] [audit; block=end; comm=w:p] What happens in this case, is…
Pim Reijersen
  • 1,123
  • 9
  • 33
0
votes
1 answer

Simplifying subtemplates that use 'getpart' parameter to speed up OpenTBS

As a follow up to my previous question, I am trying to really simplify several xml templates extracted from .docx files created in Word 2010 and used as subtemplates in OpenTBS in order to speed up my document creation. The subtemplates contain an…
Sarah Kemp
  • 2,670
  • 3
  • 21
  • 29
0
votes
2 answers

How does the changepic function in openTBS work?

I'm currently trying out the TinyButStrong library with openTBS plugin to edit an OpenOffice writer template. If I correctly understand, you can change a default picture to something else using…
Resitive
  • 280
  • 1
  • 6
  • 24
1 2 3
…
12
13