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
------------------------------
Comments
-
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 ExcelI am wondering if there is a way to import a table to a text box from an excel spreadsheet?
------------------------------
David Allison
Eargo
------------------------------
0 -
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 ExcelI am wondering if there is a way to import a table to a text box from an excel spreadsheet?
------------------------------
David Allison
Eargo
------------------------------
0