WebAIM - Web Accessibility In Mind

E-mail List Archives

Re: Save Excel Table as Tagged PDF?

for

From: Philip Kiff
Date: Nov 8, 2019 8:28AM

And this actually surprises me: if I indicate "First Column" as well as
"Header Row" in the "Table Style Options", I also get properly formatted
TH tags for each cell in the first column. I didn't realize Excel could
even do that until now.

Phil.

On 2019-11-08 10:22, Philip Kiff wrote:
> You might try re-applying a default "Table Style" to your table? Or
> cut and paste just your table data into a fresh table, and then select
> your data and apply a fresh Table Style to it, and indicate in the
> pop-up modal that your table has a heading row?
>
> When I tested this just now to a fresh, bare new Excel with 3 rows and
> 3 columns, and used the Microsoft Office 2016 built-in Export ->
> Create PDF/XPS Document function, I get a properly tagged PDF with a
> Table tag,  THead and TBody tags, and with proper TH's nested in a
> single TR in the THead.
>
> Phil.
>
> On 2019-11-08 09:49, Joseph Sherman wrote:
>> Hi Jon,
>>
>> I am on a Windows PC, and have tried saving the Excel to PDF in
>> numerous ways. Each way gives me only <TD> cells with no <TH> cells.
>>
>>
>> Joseph
>>
>>
>> -----Original Message-----
>> From: WebAIM-Forum < <EMAIL REMOVED> > On Behalf
>> Of Jonathan Whiting
>> Sent: Thursday, November 7, 2019 12:05 PM
>> To: WebAIM Discussion List < <EMAIL REMOVED> >
>> Subject: Re: [WebAIM] Save Excel Table as Tagged PDF?
>>
>> ***ATTENTION: This email came from an external source. Do not open
>> attachments or click on links from unknown senders or unexpected
>> emails.***
>>
>> Joseph,
>>
>> Are you by any chance on a Mac, and using the "Acrobat" tab in Excel?
>> If so, try creating the PDF within Acrobat (File > Created > PDF from
>> File).
>> Does that fix it?
>>
>> See https://webaim.org/techniques/acrobat/converting for more info on
>> converting files in Office to PDFs.
>>
>> Jon
>>
>>
>>
>> On Tue, Nov 5, 2019 at 10:52 AM L Snider < <EMAIL REMOVED> > wrote:
>>
>>> On Mac (and I found this on PC last month), this is now common...I do
>>> all the right things in Word (2019/365) and Acrobat then just shows
>>> all THs, annoying as anything, which is why I am now testing out
>>> other PDF programs.
>>> I have also had the all TDs as well. I haven't tested it on Excel for
>>> a month, but I am sure it is the same...
>>>
>>> Cheers
>>>
>>> Lisa
>>>
>>> On Tue, Nov 5, 2019 at 1:32 PM Joseph Sherman
>>> < <EMAIL REMOVED> >
>>> wrote:
>>>
>>>> Is there a way to save an Excel Table as a Tagged PDF with <TH>
>>>> column
>>> and
>>>> row cells? I have a simple table formatted as a Table in Excel, with
>>> Header
>>>> Row and First Column checked. But when I save as PDF, all the cells
>>>> are <TD>. Am I doing something wrong or must I manually tag every
>>>> excel
>>> table?
>>>>
>>>> Joseph
>>>>
>>>> >>>> >>>> archives at http://webaim.org/discussion/archives
>>>> >>>>
>>> >>> >>> archives at http://webaim.org/discussion/archives
>>> >>>
>> >> >> archives at http://webaim.org/discussion/archives
>> >> >> >> >> > > > >