Including tables from other applications inside an XLingPaper document

[ryan_klint]

Has anyone figured out a way to include a spreadsheet generated in another application in your XLingPaper document?

I have a few spreadsheets that I want to include as appendices in my XLingPaper document and I want their page numbering to line up with the rest of the thesis.  I tried exporting my spreadsheet as a pdf and then grabbing the xml source formatting out of that,  but I can't seem to figure out how to paste that into XLingPaper.

[Hugh Paterson III]

Hi Ryan,

What I had to do, for content I could not format directly as a table, was to include it as a figure. I would then make sure the fonts used in my figures matched those used by XLingPaper or other figures in my document to make it look native. Sometimes my "table" was also a PDF with a zero margin (so I could get it as large as possible in the final document). This is also why there is the option in XLingPaper to format the numbering of figures as tables.... because the internals for Xlingpaper for figures are used but we really want the reader to interact with it as a table not a figure.

Smoke and Mirrors goes a long way ;-)

- Hugh

On Sun, Dec 22, 2024 at 12:14 PM 'ryan_klint' via XLingPaper <xling...@googlegroups.com> wrote:

Has anyone figured out a way to include a spreadsheet generated in another application in your XLingPaper document?

I have a few spreadsheets that I want to include as appendices in my XLingPaper document and I want their page numbering to line up with the rest of the thesis.  I tried exporting my spreadsheet as a pdf and then grabbing the xml source formatting out of that,  but I can't seem to figure out how to paste that into XLingPaper.

--
You received this message because you are subscribed to the Google Groups "XLingPaper" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xlingpaper+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/xlingpaper/30349625-904d-4fd8-93cf-c0cc9ecda815n%40googlegroups.com.

[Ryan Klint]

That’s good advice, Hugo. I have done that before, but the table in my appendix is a huge table of inflectional paradigms of over 600 verbs, so it is over 200 pages long. My back up plan is to just manually pasting the table into the appropriate spot and adjust the page numbering manually.

Sent from my iPhone

On Dec 22, 2024, at 2:42 PM, Hugh Paterson III <sil.li...@gmail.com> wrote:



To view this discussion visit https://groups.google.com/d/msgid/xlingpaper/CAE%3D3Ky_Ba2D6bBYyFwecFp%3DufuW2vaxsMuh-7Og3XmwWt21zyg%40mail.gmail.com.

[Hugh Paterson III]

Well here's a trick if you have that table as a LaTeX table, and the data and format are set, then you could run XLingPaper once and let it generate its PDF and .tex file, then go in and upload the .tex file to Overleaf, add the table in directly in the TeX code and allow overleaf to generate the new PDF with the appendix.  httls://www.overleaf.com

To view this discussion visit https://groups.google.com/d/msgid/xlingpaper/30538444-E60C-4B40-B41F-13E0736D7873%40sil.org.

[XLingPaper]

Another possibility is to copy and paste (portions of?) the spreadsheet using what is documented in section 11.53 of the user documentation:

---

11.53 Convert Word or Excel Table to XLingPaper?

If you have an existing table in a file created via a word processing program like Microsoft Word, a spreadsheet program like Excel, or in a web page, you may be able to copy it, run an XLingPaper special command, and then paste a draft form of the table into XLingPaper. The result is very unlikely to be perfect, but it may save you the trouble of having to rekey the table completely by hand.

In particular, the following will probably not come through correctly:

• Header columns may come through as td elements instead of th elements. You can fix these, though, by starting with the leftmost cell and using the Edit / Convert command to change the td to a th element, one-by-one across the row.
• You will have to manually convert text to langData, gloss, or object elements. See sections 11.41–11.42.
• You may have to adjust some td, th, tr or table attributes to get what you want.

To use this process, follow these steps:

1. In XMLmind XML Editor, open your XLingPaper paper document.
2. In your other document (e.g., Microsoft Word, Microsoft Excel, or web page), copy the table.
3. Use Tools menu item / Execute Command....[39]
4. In the dialog box that comes up, in the “Command” text box, type “T” (it should then fill in “TableToXLingPaper” for you).
5. Press the Enter key or click on OK.
6. In your XLingPaper document, place the cursor where a table can go or where a table could be pasted before or after. Do the paste.

You should now have an XLingPaper version of the table.

Another thing to note is that sometimes this process leaves a temporary file in the same directory where your document is. The name of this file will be “XLingPaperTempTable.html” and will have the raw data from the original copy. You may not be able to delete it until after you close the XMLmind XML Editor program

---

You could use XXE's macro capability to save some manual effort.  Here's some documentation on that:

---

you can save yourself some time and work by making a keyboard macro. Do these steps (remember that you need to release the Esc key after pressing it in all of these before you press the next key):

1. Type Esc-m to start recording the macro..
2. Type Esc-g to find the next instance.
3. Type F11 to bring up the chooser.
4. Type the new abbreviation you want.
5. Press the Enter key.
6. Type Esc-m to end recording the macro.

To run the macro, type Esc-p (I think the m above is for "macro" and the p here is for "play" - as in "play the macro").

---

--Andy

To view this discussion visit https://groups.google.com/d/msgid/xlingpaper/30538444-E60C-4B40-B41F-13E0736D7873%40sil.org.

[ryan_klint]

Thanks Andy! That is exactly what I was hoping to find.  I just did it and unfortunately, it didn't preserve any of the formatting from the xls document. But a huge step forward, thank you!