1 person found this helpful
OK, so I didn't come across this at first in another search of this forum, but I think my issue was partially solved by the suggestion in Response #3 in this discussion to copy-paste first from the InDesign table into MS Word, then to copy-paste that table from Word to Excel. The paragraph breaks within a cell are retained in the table in Word, however they are still split into separate cells in Excel. At least doing it this way though the paragraphs remain the correct column and it seems to merge the rows for adjacent cells that are empty.
So, if anyone has further solution - how to get a table with paragraph breaks within each cell into Excel with those same paragraph breaks within the cells in Excel, please chime in. Might be helpful for others in the future. Thanks!
Table in ID:
Table in Acrobat, export out as either an Excel file or an XML.
Open the export from the PDF in Excel. Whether you use the Excel or XML export from the highlighted table in the PDF, it will come in the same.
Do note that the paragraph breaks in the ID table are not 100% translated in the file. All in the correct cell though. As well as the table colors...
MW Design showed a correct way.
Additional: From Acrobat to Excel you can also drag and drp a table into the Excel sheet.
Willi--at least in Windows, dragging and dropping doesn't work correctly. Here using Acrobat XI and Office 2010. Everything ends up in a single column.