I'm using Web Designer 11 Premium Windows 10 . Have list of events in Excel, have converted to Word and trying to "Import" and then link a word in a cell to a specific page. Having great problems in position Table in Web designer. I have asked this question before but cannot locate answers, any help please, am I using the correct approach. Terry
15 March 2018, 11:26 AM
Boy
Re: Importing Word Table and linking a word in a cell
Did you try to drag & drop the file from Explorer into your web file and soft grouping it?
15 March 2018, 02:38 PM
Egg Bramhill
Re: Importing Word Table and linking a word in a cell
Re: Importing Word Table and linking a word in a cell
Thanks Boy Have tried your solution with a number of variations but does not seem to resolve the problem.
15 March 2018, 04:34 PM
golfertel
Re: Importing Word Table and linking a word in a cell
Egg I don't how you did that but thanks that's the one. Working my way through suggestions, will come back to you later. Terry
15 March 2018, 06:02 PM
Egg Bramhill
1 Attachment(s)
Re: Importing Word Table and linking a word in a cell
Great.
Not magic, I keep a notepad file on my desktop called 'Search'. It has the following text line. Just change the search criteria after the plus sign, Ctrl+A, and paste it into a search box.
15 March 2018, 07:36 PM
Acorn
Re: Importing Word Table and linking a word in a cell
Quote:
Originally Posted by Egg Bramhill
Great.
Not magic, I keep a notepad file on my desktop called 'Search'. It has the following text line. Just change the search criteria after the plus sign, Ctrl+A, and paste it into a search box.
Egg, the original Thread is still etched in my heart.
Acorn
15 March 2018, 08:03 PM
golfertel
Re: Importing Word Table and linking a word in a cell
I can well imagine it did go on a bit, and I hate to say I never really resolved the matter. I have just come back to this site and I have been running around in circles again hence my request to Egg. Having looked through all replies I think I'm nearly there. I will tell you tomorrow how/if I resolve the problems I have had. If you would then look over the end result (homework) and comment accordingly please.
Thanks for the Search magic. Terry
15 March 2018, 10:54 PM
Acorn
Re: Importing Word Table and linking a word in a cell
Quote:
Originally Posted by golfertel
I can well imagine it did go on a bit, and I hate to say I never really resolved the matter. I have just come back to this site and I have been running around in circles again hence my request to Egg. Having looked through all replies I think I'm nearly there. I will tell you tomorrow how/if I resolve the problems I have had. If you would then look over the end result (homework) and comment accordingly please.
Thanks for the Search magic. Terry
Terry, we genuinely want to get this resolved so do come back.
Acorn
16 March 2018, 03:33 AM
Egg Bramhill
Re: Importing Word Table and linking a word in a cell
ditto
16 March 2018, 11:11 AM
golfertel
Re: Importing Word Table and linking a word in a cell
Hi Egg and Acorn, many thanks for that, appreciated. I'm out and about quite a lot so that is why my attempts are a bit disjointed.
This is where I'm up to. I have an excel sheet of about 150 rows and 6 columns. I copy this and paste it into a blank word document. I orientate it to Landscape and extend some of the columns and try to match the width of WD page so I do not have to extend it in WD because that does not appear to work very well. I then "import" the word document into WD. The layout is quite acceptable and I can then link individual words to pages and it works well.
The problem I have at the moment is that WD will only import about 30 lines, which I assume is about one page of the word document. Going into "Custom" page size in word has a limited size and does not cover all rows.
Two things, am I taking the correct approach and any help on the import size. Many thanks Terry
16 March 2018, 01:24 PM
Acorn
1 Attachment(s)
Re: Importing Word Table and linking a word in a cell
Terry, I have created an Excel sheet with 6 columns and 150 rows with a header row.
I copied from Excel and in Xara, I used Paste > Paste > Rich Text Format.
Font, size, alignment, padding all came across into an A4 page, a page with a single column and also a web page.
All extended beyond the height and width of the page. I changed that to 30 cm W x 120 cm H.
What didn't come across was any cell background colour; easy to add in Xara.
All the rows come in as 151 groups.
Double-clicking a row opens the group into an edit Inside view.
There I added any number of hyperlinks.
As sets of rows are selectable, it is easy to split the table up as you see fit and add a repeating header if needed.
Re: Importing Word Table and linking a word in a cell
Acorn Sounds a far better way than what I'm doing. Will attempt later today, thanks for your efforts. Terry
17 March 2018, 06:45 AM
golfertel
Re: Importing Word Table and linking a word in a cell
Acorn and Egg I have spent some hours working through your suggestions and have to a degree been partially successful but I have problems in positioning and getting the table to look how I want it. Much of our work on the site is putting up linked tables sent in by committee members on a daily basis and the the time spent in adjusting each table by either myself and others is not acceptable. It with regret that I have concluded that we will not be continuing using Xara. It has all the graphic design features that I wanted but importing/pasting tables is too complex.
Your assistance has been outstanding and I cannot thank you enough, good luck to you both. Best Regards Terry
17 March 2018, 07:43 AM
Acorn
Re: Importing Word Table and linking a word in a cell
Quote:
Originally Posted by golfertel
Acorn and Egg I have spent some hours working through your suggestions and have to a degree been partially successful but I have problems in positioning and getting the table to look how I want it. Much of our work on the site is putting up linked tables sent in by committee members on a daily basis and the the time spent in adjusting each table by either myself and others is not acceptable. It with regret that I have concluded that we will not be continuing using Xara. It has all the graphic design features that I wanted but importing/pasting tables is too complex.
Your assistance has been outstanding and I cannot thank you enough, good luck to you both. Best Regards Terry
Terry, sorry to hear but as your requirement has unfolded, there are other possibilities you might consider.
Keeping the tables in GoogleDocs and adding them as Placholders will not alter the layout.
If you are all using MS Excel, you can export sheets as web pages. Not my favourite but doable.
Also if layout, text, colouring and links are all essential, them export as PDF and work that way.
I will be interested in your final solution.
Acorn
17 March 2018, 07:32 PM
Egg Bramhill
Re: Importing Word Table and linking a word in a cell
Tel, I'm very sorry to hear that you are considering abandoning Xara due to it's lack of table support.
Just give me one more chance to suggest my route of using Google Sheets to create dynamic tables.
1: You can import a MS xls spreadsheets into Google Drive.
2: You can publish them as Google Drive webpages
3: You can link to these Google webpages using Placeholders
4: You're committee members can amend these spreadsheets without opening any Xara files which update the website content within minutes
5: If required you can publish linked spreadsheets
6: You're no longer needing to adjust/amend imported tables within the Xara files and republish.
Here's a video of using my table insertion in practice. The video is 17 minutes but that's partly due to the video creation. I can insert a DYNAMIC table within a placeholder within 10 minutes which I never need to open Xara again to edit.
Please feel free to use the Edit button to amend the spreadsheets content, just remember it takes a few minutes to show changes ;)
18 March 2018, 12:15 PM
Egg Bramhill
1 Attachment(s)
Re: Importing Word Table and linking a word in a cell
Here is the text required to be appended to the Google Drive html ifame, between headers=false" & the closing >
Re: Importing Word Table and linking a word in a cell
Hi Both Once again thanks for your efforts. Not ignoring your suggestions, give me a couple of days to try out your proposals. Terry
18 March 2018, 09:28 PM
ss-kalm
Re: Importing Word Table and linking a word in a cell
it seems like Egg's solution may be perfect for your requirements golfertel.
18 March 2018, 09:59 PM
golfertel
Re: Importing Word Table and linking a word in a cell
Hi both. My last reply did not seem to register so this is a resend. I will be frank, I have been looking at a number of designer apps and I was surprised that all suffered from the same problem, cannot import Word or Excel files whereas Xara will import Word docs. Having used Dreamweaver CS3 which will specifically import Word and Excel docs I have been spoilt. However graphics are not good and we are not prepared to pay current annual price of Dreamweaver. You have seriously made me reconsider Xara, thank you. I feel I have three options to inserting the excel docs.
1. Consider what Egg has suggested using Google docs, the video was great thanks for your patient efforts. However whilst the end result is good I found it very complex and would take considerable time in the number of documents we deal with.
2. Use the copy and paste as suggested by Acorn which I was surprised is editable and can have hyperlinks. Downside we loose all formatting such as colours and padding. But it works. Well it does now using Rich Text Format, wasn't doing that before.
3. Convert Excel into word Table and then "Import" it retains all formatting but takes a little time as it does not capture whole table and you have to take a second bite at it to capture complete Table.
Out of 2 and 3 I have problems in placing it in Xara, some advice required on that please.
You have both put a great effort in solving the problem, it is appreciated. Unless you come up with any else I will let you know how things go. Out of interest the page that requires links to chosen competitions, the site is still being constructed by me. Terry
Link http://rutlandcountyseniors.com/events%20diary.htm
19 March 2018, 02:46 PM
Acorn
Re: Importing Word Table and linking a word in a cell
Keith, sorry to keep bombarding you but the PDF option seems suitable too, having seen your website.
Presently, however, you have done something to ensure the table goes out as a bitmap! Links will then fail. http://rutlandcountyseniors.com/inde...files/1812.png.
You need to ensure you are not grouping the Excel import with anything else or itself.
If you must group, you need to soft-group.
Acorn
19 March 2018, 03:34 PM
golfertel
Re: Importing Word Table and linking a word in a cell
Acorn That site view was only representive of what we do. I have just quickly updated with some links and it appears to work OK. Will you check please. www>rutlandcountyseniors.com "Events" page. After you come back can we also discuss the PDF approach. Terry
19 March 2018, 05:17 PM
Acorn
Re: Importing Word Table and linking a word in a cell
Quote:
Originally Posted by golfertel
Acorn That site view was only representive of what we do. I have just quickly updated with some links and it appears to work OK. Will you check please. www>rutlandcountyseniors.com "Events" page. After you come back can we also discuss the PDF approach. Terry
Terry, the links are fine. were thay added in Xara or Excel?
The PDF approach would be twofold.
EXCEL
Maintain the detail and links in Excel.
Select the entire list and set Page Layout > Print Area to that. This gives you one long list. You repeat this for each row increase of the list.
I personally would set Page breaks on each month and repeat the headings row for each but I don't know you or your co-editors Excel experience.
Page Layout > Print Titles: pick the heading row.
Page Setup > Page: A4 Portrait, Fit to 1 page wide (leave tall blank).
File > Export > Create PDF/XPS Document and Publish.
Minimum size.
Options: Selection.
If that is then uploaded to an area that is now the Xara publish area, this saves web re-publishing as all you are changing is the content of the list.
XARA
Drag and drop the PDF onto your Xara page and pick the Add Link option.
This ensures Xara knows the filename of the PDF.
We can use this for downloading the list separately.
If you use an FTP tool like Filezilla, you need never touch the Xara file after the first upload.
All the editor does is make the changes to the list, save in Excel and Publish as PDF and upload to the same location, keeping the same filename.
If you don't want an FTP tool than you delete the PDF link, drop the updated PDF back onto the page and Smart Publish the Xara site.
Acorn
19 March 2018, 07:02 PM
golfertel
Re: Importing Word Table and linking a word in a cell
Acorn I converted the excel file to a word document and then imported to Xara, it maintained all the formatting. It allowed me to edit and make links in Xara.
I will be looking at your solution later and will come back to you, once again thank you for your efforts. Terry
20 March 2018, 07:19 AM
golfertel
Re: Importing Word Table and linking a word in a cell
Acorn I'm lost. I produced PDF file but could not drop and drag into Xara. I imported and chose "Add Link" this produced an Adobe icon on the page. Produced large placeholder, from there I'm stuck. Help.
20 March 2018, 05:16 PM
Acorn
Re: Importing Word Table and linking a word in a cell
Quote:
Originally Posted by golfertel
Acorn I'm lost. I produced PDF file but could not drop and drag into Xara. I imported and chose "Add Link" this produced an Adobe icon on the page. Produced large placeholder, from there I'm stuck. Help.
The Add Link is great. Xara now has the file in index_htm_files/folder. What is its filename? You take the Filename, less its pdf extension, and replace the code I provided in Post #23 above in the two indicated places. Save and Preview.
Acorn
26 March 2018, 04:57 AM
golfertel
Re: Importing Word Table and linking a word in a cell
Acorn Apologies have been out of circulation for a few days. Have changed file names as below. Page ends up with code as below and an Adobe icon. Save and preview and same page as described is displayed, all other pages are OK. Any ideas what I'm doing wrong. I'm just pasting the code into the page like text, this does not seem correct to me. Terry
<object data="index html _files/Copy of Events & Fixtures 2018 14th March 2018 PDF.pdf" type="application/pdf" width=100% height=100%> <iframe src="index_htm_files/Copy of Events & Fixtures 2018 14th March 2018 PDF.pdf&embedded=true"></iframe></object>
26 March 2018, 06:38 AM
Acorn
Re: Importing Word Table and linking a word in a cell
Quote:
Originally Posted by golfertel
Acorn Apologies have been out of circulation for a few days. Have changed file names as below. Page ends up with code as below and an Adobe icon. Save and preview and same page as described is displayed, all other pages are OK. Any ideas what I'm doing wrong. I'm just pasting the code into the page like text, this does not seem correct to me. Terry
<object data="index html _files/Copy of Events & Fixtures 2018 14th March 2018 PDF.pdf" type="application/pdf" width=100% height=100%> <iframe src="index_htm_files/Copy of Events & Fixtures 2018 14th March 2018 PDF.pdf&embedded=true"></iframe></object>
If you open that icon's Placeholder code, is the src information in quotes exactly that of the one you have typed in in the object data quotes above?
The detail you provided is missing an underscore between index and html_files.
Acorn
26 March 2018, 04:39 PM
golfertel
Re: Importing Word Table and linking a word in a cell
Acorn
1) I did not drag PDF file onto page because of using Tablet at the time, I imported it and the Went into "WEB properties"
2) When double click on the icon it goes into "Web Properties.
3) Putting code etc onto the "Events" where I want the listing NOT in the "index" page!!!
4) Do I need the full path of the PDF file and not just the name.
5) Have amended code with underscore as instructed.
A lot of questions. Terry
26 March 2018, 04:48 PM
Acorn
Re: Importing Word Table and linking a word in a cell
Quote:
Originally Posted by golfertel
Acorn
1) I did not drag PDF file onto page because of using Tablet at the time, I imported it and the Went into "WEB properties"
2) When double click on the icon it goes into "Web Properties.
3) Putting code etc onto the "Events" where I want the listing NOT in the "index" page!!!
4) Do I need the full path of the PDF file and not just the name.
5) Have amended code with underscore as instructed.
A lot of questions. Terry
Terry
Dragging the PDF onto the page ensures it is uploaded into the index_htm(l)_files/ folder.
Drag the PDF onto the Events page as this gives you the opportunity to download from that icon. It could have been to anywhere on your site as it is saved as above.
you need the relative path to the index_htm(l)_files/ folder:
If your site is htm-based, use<object data="index_htm_files/filename.pdf" type="application/pdf" width=100% height=100%> <iframe src="index_htm_files/filename.pdf&embedded=true"></iframe></object>
If your site is html-based, use<object data="index_html_files/filename.pdf" type="application/pdf" width=100% height=100%> <iframe src="index_html_files/filename.pdf&embedded=true"></iframe></object>
Acorn
26 March 2018, 06:55 PM
golfertel
Re: Importing Word Table and linking a word in a cell
Many thanks Acorn I will persevere. Terry
28 March 2018, 03:32 PM
golfertel
Re: Importing Word Table and linking a word in a cell
Hi Acorn and Egg I have had moderate success with your suggestions which I had to try. However after a lot of experimenting I have decided that as we are inserting about 6 or 7 new linked documents a week these methods will take too long as those that look after the site do this on a voluntary part time basis. Will be using Excel to Word route and import/paste as you suggested early on in your replies, so many thanks. I must say that Eggs videos are great.
JUST ONE LAST SIMPLE QUESTION HOW DO YOU POSITION A PASTED/IMPORTED DOCUMENT INTO A SPECIFIC POSITION ON A PAGE, AT THE MOMENT IT GOES CENTRALLY TO THE TOP OF A PAGE AND IT'S A BIT OF A PAIN TRYING TO DRAG INTO A POSITION LOWER ON THE PAGE. TRYING TO PASTE INTO A RECTANGLE DOES NOT APPEAR TO WORK FOR ME. Terry
28 March 2018, 04:28 PM
Acorn
Re: Importing Word Table and linking a word in a cell
Quote:
Originally Posted by golfertel
Hi Acorn and Egg I have had moderate success with your suggestions which I had to try. However after a lot of experimenting I have decided that as we are inserting about 6 or 7 new linked documents a week these methods will take too long as those that look after the site do this on a voluntary part time basis. Will be using Excel to Word route and import/paste as you suggested early on in your replies, so many thanks. I must say that Eggs videos are great.
JUST ONE LAST SIMPLE QUESTION HOW DO YOU POSITION A PASTED/IMPORTED DOCUMENT INTO A SPECIFIC POSITION ON A PAGE, AT THE MOMENT IT GOES CENTRALLY TO THE TOP OF A PAGE AND IT'S A BIT OF A PAIN TRYING TO DRAG INTO A POSITION LOWER ON THE PAGE. TRYING TO PASTE INTO A RECTANGLE DOES NOT APPEAR TO WORK FOR ME. Terry
Terry a pasted document is centred on the viewport to the application so use a smaller window and use the scrollbars.
A cleaner way might be to have a rectangle in place and select it and copy the contents of the MS Word document and then Paste replacing selection > Rich Text Format.
Acorn
14 April 2018, 09:36 AM
golfertel
Re: Importing Word Table and linking a word in a cell
Hi Some time since I was on this subject and I know it most probably drives you mad, but it is not for the want of me trying. The subject of linking a page in Xara to a PDF or Word Page. The code that Acorn gave me I cannot get to work, hence coming back.
I have some simple questions first please:
1. When the code is copied onto a Xara page will I see the target straight away or will I only see it when I go into Preview.
2. Is it possible to link to a Word document rather than a PDF document.
3. I assume this process is called “Linking” rather than “Embedding”
4. Does Linking take up less space than embedding.
5. This is the full name of the PDF file, would you mind writing this into the code so I can start again "C:\Users\terry\Documents\0 Rutlandcountyseniors dot com\Copy of Events & Fixtures 2018 14th March 2018 PDF.pdf"
Apologies for the protracted question but I really want this to work. Terry
14 April 2018, 10:25 AM
Acorn
Re: Importing Word Table and linking a word in a cell
Quote:
Originally Posted by golfertel
Hi Some time since I was on this subject and I know it most probably drives you mad, but it is not for the want of me trying. The subject of linking a page in Xara to a PDF or Word Page. The code that Acorn gave me I cannot get to work, hence coming back.
I have some simple questions first please:
1. When the code is copied onto a Xara page will I see the target straight away or will I only see it when I go into Preview.
2. Is it possible to link to a Word document rather than a PDF document.
3. I assume this process is called “Linking” rather than “Embedding”
4. Does Linking take up less space than embedding.
5. This is the full name of the PDF file, would you mind writing this into the code so I can start again "C:\Users\terry\Documents\0 Rutlandcountyseniors dot com\Copy of Events & Fixtures 2018 14th March 2018 PDF.pdf"
Apologies for the protracted question but I really want this to work. Terry
OK, all the way back to Post#23.
from windows Explorer, open into the C:\Users\terry\Documents\0 Rutlandcountyseniors dot com\ folder.
Locate Copy of Events & Fixtures 2018 14th March 2018 PDF.pdf and drag it into your Xara Design page.
Accept the Add Link option.
Alternatively, use File > Import and ensure the file type is PDF placeholder (*.PDF) and not PDF (*.pdf).
You will now have a PDF icon on your page. You need to keep this on the page and I advise you could make it available for viewers wanting to download it directly to their device.
If you now open the PDF Placeholder HTML code (body), you will see code like this:
<a href="index_htm_files/Copy of Events & Fixtures 2018 14th March 2018 PDF.pdf"><img src="http://webdesigner.xara.com/pdficon_large.png" border="0"></a>
You then create a large rectangle and into its Placeholder HTML code (body) add:
<object data="index_htm_files/Copy of Events & Fixtures 2018 14th March 2018 PDF.pdf" type="application/pdf" width=100% height=100%> <iframe src="index_htm_files/Copy of Events & Fixtures 2018 14th March 2018 PDF.pdf&embedded=true"></iframe></object>
The document will only appear in Preview.
If you link to anything, you use Link > Link to file. That actually embeds the file into the index_html_files/ folder.
Browsers have PDF viewing as part of their design; MS word viewers are not commonly available.
Upload the PDF file and I will create a Xara page for it.
Acorn
14 April 2018, 06:28 PM
golfertel
Re: Importing Word Table and linking a word in a cell
Well done Acorn I'm sure now I have the basic principle I can modify accordingly. Details of link to page and code I put in. Not too sure what you meant by producing a Xara page.
<object data="index_htm_files/Copy of Events & Fixtures 2018 14th March 2018 PDF.pdf" type="application/pdf" width=100% height=100%> <iframe src="index_htm_files/Copy of Events & Fixtures 2018 14th March 2018 PDF.pdf&embedded=true"></iframe></object>
Terry
14 April 2018, 07:28 PM
Acorn
Re: Importing Word Table and linking a word in a cell
Quote:
Originally Posted by golfertel
Well done Acorn I'm sure now I have the basic principle I can modify accordingly. Details of link to page and code I put in. Not too sure what you meant by producing a Xara page. http://rutlandcountyseniors.com/new%20button.htm
<object data="index_htm_files/Copy of Events & Fixtures 2018 14th March 2018 PDF.pdf" type="application/pdf" width=100% height=100%> <iframe src="index_htm_files/Copy of Events & Fixtures 2018 14th March 2018 PDF.pdf&embedded=true"></iframe></object>
Terry
Terry, i was offering to do the heavy-lifting for you but you've managed already.
Acorn
14 April 2018, 07:43 PM
golfertel
Re: Importing Word Table and linking a word in a cell
Acorn Your help and patience is very much appreciated, and I like someone with a sense of humour. Terry
14 April 2018, 07:47 PM
Acorn
Re: Importing Word Table and linking a word in a cell
Quote:
Originally Posted by golfertel
Acorn Your help and patience is very much appreciated, and I like someone with a sense of humour. Terry
Me too but Rutland takes the biscuit. My good Lady's from them parts.
Acorn
14 April 2018, 08:18 PM
Egg Bramhill
1 Attachment(s)
Re: Importing Word Table and linking a word in a cell