mbleron
readme - p_excludeCols parameter not documented
The documentation lacks the description of a parameter p_excludeCols in procedures addSheetFromQuery, addSheetFromCursor and addTable.
Was this intentional (maybe left only for testing purpose)?
I tried it today and found it pretty useful though.
Yes, I left that one out on purpose, and since it's not documented, I won't encourage you to use it. I added it when I first tried to implement hyperlinks (issue #6), so that we could generate a display value or target URL based on columns from the query without having to actually output them in the sheet.
This was all going well until I realized the complexity of formula implementation in the XLSB format. That requires a formula parser and RPN compiler, both of which I'm familiar with but it was still a lot of work back then. That's why the hyperlink enhancement was put on hold, and the new parameter left in place because all the wiring was already done internally.
Since then, I've started to work on formulas again and hope to have something working soon.
Thank you for clarification.
Will this (or some similar) parameter still be available after the formulas are implemented?
Use case:
the query which creates an Excel table has an additional column that contains a CSS-Style for highlighting specific rows (through setTableRowProperties).
This column have a standard name and shouldn't be displayed.
Yes, the parameter will be there and documented. For your use case, you'll also be able to use Excel's native conditional formatting (issue #2) which depends on formulas as well.