Forum Discussion
Export mixed text and tabular Excel to PDF
I have a sheet that I need to export from Excel to PDF. The sheet contains text and tabular data. Ideally, I'd like large bold text to export as heading tags, text as paragraph tags, and the tabular data as a table. Currently, any group of cells containing data that are surrounded with blank cells export as a table, even if they don't contain what a human would consider tabular data. I haven't selected the tabular data and chosen Import > Table. I'm not sure if that would help or not.
How can I export mixed text and tabular data from Excel and have it be tagged as desired in the resulting PDF?
1 Reply
You can export mixed text and tabular Excel data to PDF directly using Excel’s ‘Save As’ or ‘Export’ option. Just adjust the print area first so both text and tables are properly aligned, then choose PDF format. If formatting is important, using ‘Print to PDF’ after setting page layout usually gives better results.
