Layout make table with bom
-
how i add attribute as a weight?
-
@dave r said:
Yes, you can make that table. Start in Excel to make the table, copy it to word and save it as RTF. Then you can insert the RTF file into LayOut. The borders/lines may be a challenge because the RTF file doesn't do a good job of saving borders.
I've found a way to bring the files in by their tab lengths, without bringing in the borders, which I was having trouble with.
In my case I'm taking an excel file and copying and pasting the table into Word. I then select the entire table and click on the developer tab that lights up in the main bar. There is a button there that converts the table to text! Save the word file as RTF and link inside layout for a relatively seamless workflow.
-
Although I don't use the Developer tab, I do much the same. I copy the table from Excel into Word, convert table to tab-separated text and save as RTF. Actually there's often a bit of editing in word for formatting and setting tabs and so on. I did two of those today, in fact.
-
you can copy and paste excel tables straight into layout.
-
Yeah, but they're ugly.
-
They look just like that...
@dave r said:
Yes, you can make that table. Start in Excel to make the table, copy it to word and save it as RTF. Then you can insert the RTF file into LayOut. The borders/lines may be a challenge because the RTF file doesn't do a good job of saving borders.
-
I'm not finding anything you guys have in Word on a Mac (insert button with link submenu?) If I choose insert file and pick a box in the open dialog "insert as link" I get an error not valid file name....
Anyway is LO reference supposed to be able to update when you update the Excel this way (rtf)? or do you also have to do something with the rtf file?
I use an alternate method myself.
I update the excel then print to pdf, Iinsert pdf to LO.
Later if I change the excel file, I print to pdf and over-write the same pdf file
The LO file can then update ther reference. Is this more steps?? If you use macs the print to pdf will use the excel name so you don't even have to worry about the name--if you are in the right folder.Regarding OP I think the missing step is using ruby to export the information about his DC to the csv file. Just guessing.
Advertisement