Feb 17 2021 03:14 PM
Hi – I have some questions about generating accessible (to visually impaired persons) PDFs from Excel files. I have little-to-no expertise in this realm and am not finding much helpful information online.
The basic scenario is:
My goal is to be able to generate a single PDF from this workbook which:
This report will be generated on an annual basis so, with 60+ data tables, I want to eliminate as much manual intervention as possible, i.e., get the source document configured so that the PDF is tagged correctly. If there needs to be an intermediate step (eg importing Excel tables into Word?) I’m open to that… but I don’t know if there would be any benefit to doing it.
Please see the attached spreadsheet (one simple worksheet / report – no database functionality), the corresponding PDF (generated using Save As / PDF) and 2 screenshots showing results of the accessibility check.
The resulting reading order is correct (now that I’ve converted the data cells to a table).
However, the tags for the table title and all of the annotations are problematic. (The PDF accessibility checker generates header errors). I’ve tried various cell formats for both the table title cells as well as the annotation cells (e.g., Header1 for the table title cells) but the results are the same. Note: I don’t mind if I need to unmerge report title or annotation cells, but I did try it and the results were essentially the same.
Questions:
Really struggling to come up with the most automated approach to this task... Turns out pulling all the data in is the easy part! But the accessibility stuff is looking to be a bear ...
Thanks,
Carol