• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Is there a way to reference one single Excel cell in another FM file and to update it?

New Here ,
Apr 11, 2018 Apr 11, 2018

Copy link to clipboard

Copied

Hi all,

I'm looking for a solution for the following problem:

I need a smart table that calculates certain values. The result value is supposed to get referenced in several  FM files. When the values in the native smart table get modified the referenced value is supposed to change automatically to the new value.

I tried to insert an Excel table to FM but I have problems referencing one single cell as well as to keep it updated. in specific I managed to reference one cell, but it doesn't look very nice plus the value of the cell always stays the same, no matter how many modification are done in the native Excel table.

I'm interested in a solution for both DITA and unstructured FM. Since in DITA the same problem occurs because I'm not able to reference one single cell with conref. Is there maybe another way to make this working? Also Smart Paste is not working well in this situation.

Thank you in advance for your help!

Kind regards,

Amy

Views

347

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Contributor , Apr 12, 2018 Apr 12, 2018

Unstructured FM:

  1. In the Excel table, add a new tab.
  2. Link the result value to A1 in the new tab.
  3. Save the table (only the new tab) as CSV file.
  4. Import the CSV file in FM (as text inset).

Now the result value is updated in FM every time you open the FM file.

 

Is this what you are looking for?

Votes

Translate

Translate
Adobe Employee ,
Apr 11, 2018 Apr 11, 2018

Copy link to clipboard

Copied

Hi Amy,

you might want to contact Jang Graat: 4everJang. He had done things like this.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Apr 11, 2018 Apr 11, 2018

Copy link to clipboard

Copied

Hello Amy,

As Stefan has already revealed, I have created scripts that pull data into FrameMaker (and writing it back) in both structured and unstructured documents. I have used CSV files and SQL databases in the past. Making the same method work with Excel should be doable but it will not be trivial. If you are interested in getting a solution created and have a budget for this we can discuss the requirements and possibilities. Contact me via jang at jang dot nl

Kind regards from Amsterdam

4everJang

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Contributor ,
Apr 12, 2018 Apr 12, 2018

Copy link to clipboard

Copied

Unstructured FM:

  1. In the Excel table, add a new tab.
  2. Link the result value to A1 in the new tab.
  3. Save the table (only the new tab) as CSV file.
  4. Import the CSV file in FM (as text inset).

Now the result value is updated in FM every time you open the FM file.

 

Is this what you are looking for?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 12, 2018 Apr 12, 2018

Copy link to clipboard

Copied

Works well. Thanks a million, Lothar!

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
Apr 15, 2018 Apr 15, 2018

Copy link to clipboard

Copied

amelieg6457283, if it works, would you mind marking Lothar's answer as "Helpful" and as "Correct Answer"?

Thanks 🙂

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Oct 05, 2022 Oct 05, 2022

Copy link to clipboard

Copied

Hello there
Can you share a video about it? thanks.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 05, 2022 Oct 05, 2022

Copy link to clipboard

Copied

Really? A video? Those instructions of @Lothar_Voigt seem pretty straightforward. What's the issue @Albentug ?

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Oct 10, 2022 Oct 10, 2022

Copy link to clipboard

Copied

thank you
I don't understand what FM is.
Thank you again for your concern.

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Oct 10, 2022 Oct 10, 2022

Copy link to clipboard

Copied

LATEST

FM=FrameMaker

David Creamer: Community Expert (ACI and ACE 1995-2023)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines