Excel
96 TopicsThe pandas code read_excel() does not work in Python/Excel, unlike in native Python.
I have an issue when I try to read a specific workbook in Excel using pandas read_excel() The following code was tested natively and it worked: import pandas as pd pth = "C:/Users/XXXX/Python 101/SUBPATH/" input = "inputworkbook.xlsx" wb = pth + input df1 = pd.read_excel(wb, sheet_name="Sheet1", skiprows=1) When I try to execute it from an excel workbook, I got this error message : FileNotFoundError: [Errno 2] No such file or directory: 'C:/Users/XXXX/Python 101/SUBPATH/inputworkbook.xlsx' Could you explain me why it doesn't work the same ? (Thanks)Solved10KViews1like10Commentshow to know if I should have a function / feature in Excel beta?
Hello, I am new to insider program. I have just set up a beta channel in my excel on a computer and I can happily try out some functions which are only available in beta channel. Now my questions are: - where can I have infos which functions are currently available in beta only? - how come there are functions I've seen from youtubers I can now also try, but others are unavailable. Like I see the REGEX functions, but not the TRANSLATE. Some other features, like the very newly published :. annotation is also missing for me. Thanks, SzilviaSolved322Views0likes2CommentsKeyTips now available in Office for Mac
Microsoft 365 Insiders, Happy Friday! Great news for Office for Mac users! KeyTip support is finally coming to Office for Mac, enhancing navigation and boosting productivity. Want to learn more about these popular keyboard shortcuts? Check out our latest blog post by Hugo Garcia, Product Manager on the Microsoft 365 team: KeyTips now available in Office for Mac KeyTips in Office for Mac are now available to Microsoft 365 Insiders, and they’ll be available to all Office for Mac users in the coming months. Thanks! Perry Sjogren Microsoft 365 Insider Social Media Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android769Views0likes4CommentsDataSource Error Access To The Path is Denied / PowerQuery Mac
I am trying to read a datasource (CSV) into Power Query. I keep getting DataSource error saying that it cannot read the file. This happens whether I try using "Get Data" or just editing an existing query so that it points to a different source. An exception occurred: [DataSource.Error] Access to the path '/my/path/to/the/file.csv' is denied. (Session ID: 6cc4c6b5-96d6-4d58-b68a-f20fcab1aa8f) Sometimes, If I make a copy of the file, then I can import that copy. But if I change the name back to what I want it to be named, then it can't connect. It's the same file, just with a different name. Sometimes when I go to Get Data, all the potential choices (ie.. all the CSV files) are grayed out. But if I rename one of the files then that one will (sometimes) not be greyed out and I can select it. But if I change it back to the name I want, then it grays out again. Very frustrating as a simple duplication task (ie. duplicating a query and then adding a different source) has become very hard indeed. Any ideas why this might be happening?17KViews3likes19CommentsNew Translation Functions in Excel: TRANSLATE and DETECTLANGUAGE
Hey Microsoft 365 Insiders, Great news for Excel enthusiasts! Excel now includes powerful translation functions, allowing you to translate and detect languages directly within your spreadsheets. The new TRANSLATE and DETECTLANGUAGE functions help break down language barriers, making your data more accessible and your workflow smoother. Discover how it works in our latest blog post by Gedion Alemayehu, Product Manager on the Excel team: New Translation Functions in Excel: TRANSLATE and DETECTLANGUAGE NOTE: These are preview functions. Their signature and results may change substantially before being broadly released, based on your feedback. So, we do not recommend using these functions in important workbooks until they are generally available. Thanks! Perry Sjogren Microsoft 365 Insider Social Media Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android4KViews1like5CommentsNew regex modes for XLOOKUP and XMATCH
Microsoft 365 Insiders, Great news for Excel enthusiasts! Get ready to enhance your Excel game with regex modes for XLOOKUP and XMATCH. Whether you’re pulling specific data or locating exact matches, these updates help parse text more easily. Jake Armstrong, Product Manager on the Excel team, breaks it all down for you in our latest blog: New regex modes for XLOOKUP and XMATCH Thanks! Perry Sjogren Microsoft 365 Insider Community Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android315Views1like1CommentEdit tables with ease in Word for the web
Hi, Microsoft 365 Insiders, Great news for Word for the web users! We are excited to announce a new feature that makes editing tables even smoother. You can now quickly and easily modify tables to improve your document's formatting and appearance — no cutting or pasting required! This update allows you to effortlessly edit your tables so you can focus on your content. Check out our latest blog by Anushri Sahu, Product Designer, and Kirti Sahu, Product Manager, from the Word team: Edit tables with ease in Word for the web Thanks! Perry Sjogren Microsoft 365 Insider Community Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android341Views0likes0CommentsRefresh data using Power Query’s From Folder connector in Excel for Mac
Hi, Microsoft 365 Insiders, Great news for Excel for Mac users! We are happy to announce a new feature that makes your data management even smoother. You can now refresh data using Power Query’s From Folder connector in Excel for Mac. This update allows you to effortlessly keep your data current and organized. Check out our latest blog by Gal Zivoni, Product Manager on the Excel team: Refresh data using Power Query’s From Folder connector in Excel for Mac Thanks! Perry Sjogren Microsoft 365 Insider Community Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android314Views0likes0CommentsIntroducing dynamic watermarking for Word, Excel, and PowerPoint
Hi, Microsoft 365 Insiders, Exciting news! Introducing dynamic watermarking, a new feature for sensitivity labels in Word, Excel, and PowerPoint for Windows, Mac, and the web. This feature can deter users from leaking sensitive information and attribute leaks if they occur. Read our latest blog by Camille Birch, Product Manager on the Office Purview team:Introducing dynamic watermarking for Word, Excel, and PowerPoint Thanks! Perry Sjogren Microsoft 365 Insider Community Manager Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android431Views0likes0Comments