Welcome to TalkGraphics.com
Results 1 to 10 of 40

Threaded View

  1. #31
    Join Date
    Aug 2000
    Location
    Harwich, Essex, England
    Posts
    19,442

    Default Re: Link text fields in Designer 10 with cells in Excel or Word (table)?

    Hi again Mark,

    So you are linking the Google spreadsheet to the .xar file in some way???
    Very definitely.

    Google Drive, including Google Sheets is great. You can create a spreadsheet directly in Google Drive or you can upload an Excel sheet to Google Drive.

    Once created you can File / Export to Web.

    Google gives you a link to the sheet which you can then use on your site.

    Here's a link to the Google sheet showing the North section of your parking lot:

    https://docs.google.com/spreadsheets...=0&single=true

    Now open Xara and on layer MouseOff create a rectangle with the iframe link. Don't tick the regenerate bitmap copy at present, click Apply.

    <iframe src="https://docs.google.com/spreadsheets/d/1mvfL3m72wQmTj5xaTBGsnsLMhGi-0o0rLPlSBRV6xq0/pubhtml" height=1300 width=860 scrolling=0>
    <p>Your browser does not support iframes.</p>
    </iframe>
    NOTE I've removed the "?gid=0&single=true" end section of the url.

    The Height & Width values need to be altered until they fit the content, but only once they no longer need amending.

    Once you've previewed the content and are happy the required fields are being displayed, on the preview, reselect the placeholder, select "regenerate bitmap copy" and you'll get a true copy of the parking lot.

    Now create a new layer for the overlay map. Create an overlay map with holes to show the under-laid iframe.

    Preview & Print.

    To test it, download the attached xar and preview.

    If you want to edit the underlying spreadsheet:

    https://docs.google.com/spreadsheets...it?usp=sharing

    Amend the details in N3 section and wait a few moments and re publish the xar file. It will reflect your changes. The other cells have code to avoid me having to type in multiple values in this example.
    Attached Files Attached Files
    Last edited by Egg Bramhill; 03 August 2015 at 09:47 PM.
    Egg

    Intel i7 - 4790K Quad Core + 16GB Ram + 232 GB SSD + 250 GB SSD portable drive
    Xara Designer Pro X 16

 

 

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •