Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Allow inclusion of images/graphs #101

Open
fingertipsy opened this issue Oct 17, 2023 · 1 comment
Open

Allow inclusion of images/graphs #101

fingertipsy opened this issue Oct 17, 2023 · 1 comment
Labels
enhancement New feature or request priority: on ice Do much later, maybe never

Comments

@fingertipsy
Copy link

would it be possible to have sheet_type = image or sheet_type = graph and pass .svg images or ggobjects to be displayed on the worksheet?

@matt-dray
Copy link
Collaborator

Hi, thanks for the question.

You may be aware that this package is built to support the 'Releasing statistics in spreadsheets' guidance by the Government Analysis Function. Regarding images, the guidance says:

Images within spreadsheets should be avoided. Generally the best place for any analysis or data visualisations is in HTML.

Similarly, the 'Accessible spreadsheets: a checklist of the basics' page says:

11. Avoid images in spreadsheets
Images should be avoided as they can disrupt navigation. If you cannot avoid including images, make sure all logos, graphics, charts and any other images within the spreadsheet document have alternative text attached to them.

For these reasons, {a11ytables} currently doesn't support image insertion.

You could, however, insert a new sheet to the Workbook-class object generated by a11ytables::generate_workbook() and use the openxlsx::insertImage() function to insert an image.

@matt-dray matt-dray added enhancement New feature or request priority: on ice Do much later, maybe never labels Oct 30, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request priority: on ice Do much later, maybe never
Projects
None yet
Development

No branches or pull requests

2 participants