Support

 View Only

  • 1.  Import a table to a text box from Excel

    Posted 03-09-2023 15:17

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



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


  • 2.  RE: Import a table to a text box from Excel

    Posted 03-27-2023 17:06

    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


  • 3.  RE: Import a table to a text box from Excel

    Posted 03-27-2023 17:38

    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