How to import an MS EXcel sheet, with embedded links in cells?

srinis

srinis ✭✭

03/25/22 in API & Developers

How to import an MS EXcel sheet, with embedded links in cells?

0 ·

Answers

Intern98 ✭✭✭

03/28/22

Convert all embedded links into text in excel,
import to SS and change it to web Link in the options

0 · Share on Facebook Share on Twitter
Gia Thinh ✭✭✭✭✭✭

03/28/22 edited 03/28/22

Hi srinis,
Just using "Import Microsoft Excel" menu as below, then all the embedded links in Excel cells will be there in your new Smartsheet sheet.

Gia Thinh Technology - Smartsheet Solution Partner.
0 · Share on Facebook Share on Twitter

Categories

Trending in API & Developers

Newly Received 404 with Error Code 1006 on DELETE sheets/{sheetId}/rows API with ignoreRowsNotFound
Hey there, Was a recent breaking change pushed to the smartsheets API? Previously, when calling the DELETE Request to the rows endpoint, I would receive a 200 with a valid response. Now, when requesting a valid sheet, with a valid row, I am unable to get a 200 response and am only receiving 404 with error code 1006 in…
When I Copy Workspace, Everything Copies Fine Except for CellLinking
Hi, Using the API documentation, I'm able to copy entire workspaces which has been great for scalability. I've been noticing that the only thing that doesn't work correctly out of all the sheets, reports, and sights, is the cellLinks in my sheet. In the instructions, you can tell it all the different things to pull in. I'm…
What is the proper Content-Type string for an Excel (xlsx) file row attachment?
Hello, I have an Excel document (xlsx) that I want to upload to a row through the API. My code does successfully upload the file as a row attachment. However, when I download the file through Smartsheet and try to open it, I get an error "Excel cannot open the file 'file_name.xlsx' because the file format or file extension…