Best way to grab rows from a column and add their value to a list or dictionary in Python?
There is a column populated with email addresses that I am trying to grab the values of for a script in python. I've managed to grab the sheet object. How do I go about adding the values from the column to a dictionary?
Answers
-
Genevieve P. Employee AdminIt sounds like you're using Get Sheet to grab the sheet content, is that correct?
If so, you can then use the Column ID to get data from that specific column. If it's a Contact column, the email in each cell will show up as the "value" under that Column ID in the Rows array (with the name associated with the contact set as the "displayValue").
Here's the API documentation on this:https://smartsheet.redoc.ly/tag/sheets#operation/getSheet
Cheers,
Genevieve
Categories
The Smartsheet API does not possess a native method to directly fetch or incorporate clickable row permalinks when you export a sheet to an Excel file. So, users need more intuitive, clickable links within their exported Excel sheets.<\/p>
To address this, I have implemented a workaround:<\/p>
(I used Smartsheet SDK to implement the workaround)<\/p>
<\/p>
Fetching Permalinks:<\/strong> The code interacts with the Smartsheet API to retrieve each row's permalink values.<\/p> Incorporating into the sheet:<\/strong> These permalink values are then populated into a designated column. When you export the sheet as an Excel file, you'll notice a column filled with URLs corresponding to the permalinks for each row in Smartsheet.<\/p> Making the Links Clickable:<\/strong> As a final step, to enhance user experience and ease of access, the code processes the Excel file to convert these plain URL texts into clickable hyperlinks. Thus, when users click these links in the Excel sheet, they're directed to the appropriate Smartsheet row online.<\/p> With the implemented code, users can easily navigate to Smartsheet rows directly from their Excel sheets.<\/p>![\"export](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/PP3VBW3I0K76\/export-to-excel-with-row-permalink.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
![\"expoerted](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/6B6GEV3BMXO6\/expoerted-excel-file.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
