How to use an "Anaconda Code Object" dataset in Anaconda Code

Paul24 · November 30, 2025, 2:43am

Hi,

I am using Anaconda Toolbox/Code in Excel 2024 with a perpetual license (hence no Microsoft Python =PY).

I have successfully uploaded a small (10,000 row) dataset to the Anaconda Toolbox, and I now want to test using that dataset from within Anaconda’s Toolbox.

Since I don’t have the Office 365 version of excel, I can only download as an ‘Anaconda Code Object’. That part works OK. You can see from the screenshot that it was successfully placed on cell A1 of my Sheet4 tab.

However, I now have no clue how to view, read or access the ‘Anaconda Code Object’. Can somebody who has been successul at doing this from Anaconda Code please provide an example of how you would access that data (for example access and print the first 5 rows)?

Nothing I try works. Hours on ChatGPT and Gemini AI have attempted many ways to access with no success. The Anaconda Toolbar manual discusses the fact that such an object (Anaconda Code Object) can be created, but it doesn’t explain how to use it.

Below is an image showing how the ‘Anaconda Code Object’ showns on cell A1, the metadata page shows when I hover my house on top of it. I hope somebody can help.

Paul24 · November 30, 2025, 10:58am

After hours of trial and error, I was able to finally solve the problem with the code shown in the enclosed screenshot.

However, this was only possible after changing the date columns to numbers in the source data. For some strange reason Anaconda Toolbar is unable to import columns in this format 30/11/2025, and many attempts to change the import to string failed. So this is something that the Anaconda Team should look into, as it is going to cause a lot of people to think it is impossible to import data (after all most data contains dates).

I tried to import in both CVS and Excel format; it failed on both.

If somebody wants to replicate this, feel free to download the following public file and give it a short. You will see that it is impossible to import unless you change the date format in the source file to excel date number format

gist.github.com

https://gist.github.com/nnbphuong/38db511db14542f3ba9ef16e69d3814c

Superstore.csv

Row ID,Order ID,Order Date,Ship Date,Ship Mode,Customer ID,Customer Name,Segment,Country,City,State,Postal Code,Region,Product ID,Category,Sub-Category,Product Name,Sales,Quantity,Discount,Profit
1,CA-2017-152156,2017-11-08,2017-11-11,Second Class,CG-12520,Claire Gute,Consumer,United States,Henderson,Kentucky,42420,South,FUR-BO-10001798,Furniture,Bookcases,Bush Somerset Collection Bookcase,261.96,2,0,41.9136
2,CA-2017-152156,2017-11-08,2017-11-11,Second Class,CG-12520,Claire Gute,Consumer,United States,Henderson,Kentucky,42420,South,FUR-CH-10000454,Furniture,Chairs,"Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back",731.94,3,0,219.582
3,CA-2017-138688,2017-06-12,2017-06-16,Second Class,DV-13045,Darrin Van Huff,Corporate,United States,Los Angeles,California,90036,West,OFF-LA-10000240,Office Supplies,Labels,Self-Adhesive Address Labels for Typewriters by Universal,14.62,2,0,6.8714
4,US-2016-108966,2016-10-11,2016-10-18,Standard Class,SO-20335,Sean O'Donnell,Consumer,United States,Fort Lauderdale,Florida,33311,South,FUR-TA-10000577,Furniture,Tables,Bretford CR4500 Series Slim Rectangular Table,957.5775,5,0.45,-383.031
5,US-2016-108966,2016-10-11,2016-10-18,Standard Class,SO-20335,Sean O'Donnell,Consumer,United States,Fort Lauderdale,Florida,33311,South,OFF-ST-10000760,Office Supplies,Storage,Eldon Fold 'N Roll Cart System,22.368,2,0.2,2.5164
6,CA-2015-115812,2015-06-09,2015-06-14,Standard Class,BH-11710,Brosina Hoffman,Consumer,United States,Los Angeles,California,90032,West,FUR-FU-10001487,Furniture,Furnishings,"Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood",48.86,7,0,14.1694
7,CA-2015-115812,2015-06-09,2015-06-14,Standard Class,BH-11710,Brosina Hoffman,Consumer,United States,Los Angeles,California,90032,West,OFF-AR-10002833,Office Supplies,Art,Newell 322,7.28,4,0,1.9656
8,CA-2015-115812,2015-06-09,2015-06-14,Standard Class,BH-11710,Brosina Hoffman,Consumer,United States,Los Angeles,California,90032,West,TEC-PH-10002275,Technology,Phones,Mitel 5320 IP Phone VoIP phone,907.152,6,0.2,90.7152
9,CA-2015-115812,2015-06-09,2015-06-14,Standard Class,BH-11710,Brosina Hoffman,Consumer,United States,Los Angeles,California,90032,West,OFF-BI-10003910,Office Supplies,Binders,DXL Angle-View Binders with Locking Rings by Samsill,18.504,3,0.2,5.7825

This file has been truncated. show original

Here is a more formal bug report for Anaconda:

Environment: Excel 2024 (Perpetual License), Anaconda Toolbox Add-in.

Error: TypeError: e.gettime is not a function

Description: When attempting to view/spill a DataFrame that contains standard Date columns using to_df(), the Add-in crashes with the JavaScript error above.

Observation: The Python code runs successfully (creating the object), but the visual renderer fails to handle the Python Date Object.

Workaround: I had to manually convert all dates to Excel Serial Numbers (integers) in the source file to prevent the crash. Request: Please patch the JavaScript renderer to handle Date objects or NaT values gracefully without crashing the UI.

Jim_Kitchen · December 1, 2025, 2:40pm

Paul,

I’m glad you were able to figure out how to access your uploaded dataset. It sounds like the docs definitely need some improvement in this area.

Thank you for the detailed bug report about the date columns. I will add it to the backlog of things to fix.

Topic		Replies	Views
Getting data located in another workbook Python in Excel	3	79	August 26, 2024
About the Anaconda Code category Anaconda Code	2	304	August 9, 2024
Get Anaconda Toolbox Anaconda Toolbox	0	467	March 16, 2024
About the Python in Excel category Python in Excel	9	3424	April 18, 2024
Just trying to write my first line of code in Python Getting Started	0	343	February 14, 2023

How to use an "Anaconda Code Object" dataset in Anaconda Code

Related topics