Insert XSLX Datapoints into DOC File

Docs
1

I switched from Windows to Linux and now am relearning the things I want to do in a different software. Any help with my problem is very much appreciated, since I do not know how to do this in ONLYOFFICE.

In want to create a calendar in a DOC File and would like to enter data from my XSLX File into that calender. The calendar has several pages and each page is structured somewhat like this

January [ ] Week 01

Monday 01 [ New Year’s Day ]
Tuesday 02 [ ]
Wednesday 03 [ Moms Birthday ]
…

Now I have an XSLX FIle that has the following rows
MONTH | DAY | WEEKDAY | WEEK | HOLIDAYS | BIRTHDAYS |

January | 01 | Monday | 01 | New Year’s Day |
January | 02 | Monday | 01 | |
January | 03 | Monday | 01 | | Moms Birthday

How do I connect the DOC File and the XSLX File so that the DOC File is filled automatically with all the data in the XSLX File?

I assume I am not the first one to ask this type of question, however I am having trouble finding an answer. So a link to a similar problem with a solution would probably help me as well.

2

Hello @JJB

That’s an interesting use-case. It seems to be a table import query, if I get it right.
You can simply copy the table from XLSX file and paste it into DOCX, then format the table to your liking.

If I misunderstand the case, please share any additional information. In case you have any sample case from any other processor, you can provide it as a reference for the scenario of importing a table.

3

Hey, thank you for your reply.

Coping the table into DOC Format is too inconvenient, since I would have to format every page. I was hoping for a more automatic solution so I could redo the same process next year. I havent found anything for OnlyOffice, so I coded it in Linux-Terminal with ImageMagics.

All the best :slight_smile:

1 Like
4

Thanks for the reply. I’m glad to know that you have found a suitable workaround.