Import a table to a text box from Excel

David Allison
David Allison Member, Jama Connect Interchange™ (JCI) Posts: 19

I am wondering if there is a way to import a table to a text box from an excel spreadsheet?

------------------------------
David Allison
Eargo
------------------------------

Comments

  • [Deleted User]
    [Deleted User] Posts: 152
    edited March 2023

    Hi David, 

    To clarify, are you asking if you can import a worksheet from Excel into a single text field in Jama Connect?

    ------------------------------
    Carly Rossi // she/her
    Community Manager // Jama Software
    Portland, OR
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 03-09-2023 15:16
    From: David Allison
    Subject: Import a table to a text box from Excel

    I am wondering if there is a way to import a table to a text box from an excel spreadsheet?

    ------------------------------
    David Allison
    Eargo
    ------------------------------
  • Jeff Abbott
    Jeff Abbott Member, Data Exchange Posts: 31
    edited March 2023

    If you know VBA you can create a graphic from a range of cells in Excel. Then copy that graphic and paste into an empty chart.  The Chart then has an Export function to write graphic to disk. Load that into Jama and then to import Excel data add the <img src={url}> to reference the attachment from a cell, Jama will process that and any many HTML tags.   You may also be able to generate the HTML table and put that into a Cell for Import. Note, that getting Jama to export figures into Excel is something i have not tried.

    ------------------------------
    Jeff Abbott
    Leidos
    Orlando FL
    ------------------------------
    -------------------------------------------
    Original Message:
    Sent: 03-09-2023 15:16
    From: David Allison
    Subject: Import a table to a text box from Excel

    I am wondering if there is a way to import a table to a text box from an excel spreadsheet?

    ------------------------------
    David Allison
    Eargo
    ------------------------------