Forum Discussion
KeithJusas
7 years agoQrew Captain
Josh,
we have another add-on called XL Docs which generates Excel files from your quick base data. It works very similar to EF+ where you start with an Excel template file and we merge that file with data from your table(s). We have a lot of clients creating some very complex Excel files using this add-on. You get the full capabilities of Excel so you can use all of the charting and graphing capabilities as you need.
Here is a link to our demo app: https://juicedtech.quickbase.com/db/bj446yrpq
also, here is a link to an output excel file from XL Docs that uses some charts. It handles multiple worksheets as well
https://juicedtech.quickbase.com/up/bdhzeparp/g/rgt/eg/vb/Sample%20Excel%20File.xlsx
we have another add-on called XL Docs which generates Excel files from your quick base data. It works very similar to EF+ where you start with an Excel template file and we merge that file with data from your table(s). We have a lot of clients creating some very complex Excel files using this add-on. You get the full capabilities of Excel so you can use all of the charting and graphing capabilities as you need.
Here is a link to our demo app: https://juicedtech.quickbase.com/db/bj446yrpq
also, here is a link to an output excel file from XL Docs that uses some charts. It handles multiple worksheets as well
https://juicedtech.quickbase.com/up/bdhzeparp/g/rgt/eg/vb/Sample%20Excel%20File.xlsx
JoshWeeman
7 years agoQrew Assistant Captain
Thanks for the reply Keith, but Excel doesn't really work for us. Our reports are varying mixes of graphics, tables, headers/footers, and bodies of text with specific formatting needs, so we need the word-processing and layout power of Word.
Do you have any other suggestions, perhaps more progress on the dataURL workflow you mentioned previously? Above you said you already had at least one client using dataURLs to insert charts into subtable reports, and that you still needed to make some tweaks to get it to work in EFP overall. What's the current status of that?
Unfortunately I still have not uncovered an existing or easily scriptable method of encoding a HighChart image to a dataURL on the fly from within QB, so that hurdle still exists.
Thanks.
Do you have any other suggestions, perhaps more progress on the dataURL workflow you mentioned previously? Above you said you already had at least one client using dataURLs to insert charts into subtable reports, and that you still needed to make some tweaks to get it to work in EFP overall. What's the current status of that?
Unfortunately I still have not uncovered an existing or easily scriptable method of encoding a HighChart image to a dataURL on the fly from within QB, so that hurdle still exists.
Thanks.