Excel中嵌入式Python的问题或者说如何用Pandas碾压Excel.pdf

1、#BHAS BlackHatEventsThe Problems of Embedded Python in Excel(How to excel in pwning pandas)#BHAS BlackHatEventsWho are we?Shalom CarmelCIO GlobalDOfir CarmelCS Student#BHAS BlackHatEventsTL;DRThe facts Excel 365 runs python which refers to spreadsheet data The python code and the data are sent over

2、to Microsoft for processingI found out that We can play with and modify the PY cloud runtime environment PY cloud runtime environments seem to be shared between sessions11 See March 27,2025 update#BHAS BlackHatEventsWork In Progress/Proof Of Concepthttps:/ BlackHatEventsThank you,GlobalDots HRHR mad

3、e me take PTO near the end of the year.My wife told me to fix the shed.I pleaded for a couple of hours to look at some new productivity stuff.This is the result,some days and nights later#BHAS BlackHatEventsTimeline Introduction The PY environment Execution of remote server code Shared user sessions

4、(?)Uploading of custom binary files Live demo Summary Q&A#BHAS BlackHatEventsIntroduction Excel is used by millions worldwide,and Excel 365 supports python The Python environment is geared at heavy data processing business and academia users It is expected to be a secure and private environment Prev

5、alence of VB macros&automation in the finance sector#BHAS BlackHatEventsExcel-specific embedded Python extensions=PY()Excel formula The xl()python function refers to Excel cells and ranges CTRL+Enter sends the code to execution Input options:cells,ranges,named ranges,tables Output options:pandas dat

6、aframes,lists,discrete values,python objects#BHAS BlackHatEventsHow it works?https:/ BlackHatEventsHow it works?#BHAS BlackHatEventsArchitecture365EntitlementData+py CodeResults#BHAS BlackHatEventsPython in Excel Security*The container has Python and a curated set of secured libraries provided by An