iZZiSwift

iZZiSwift

Learning by Sharing Swift Programing and more …

  • Swift Programming
    • Swift Language
    • i0S Swift Issue
  • Devices
  • MacOS
  • Python Programming
  • Kotlin Programming
  • Memo

Tag: excel

Putting many python pandas dataframes to one excel worksheet

January 15, 2021 Jeffrey Schneider

Question or problem about Python programming: It is quite easy to add many pandas dataframes into excel work book as long as it is different worksheets. But, it is somewhat tricky to get many dataframes into one worksheet if you want to use pandas built-in df.to_excel functionality.

Continue Reading

Running an Excel macro via Python?

January 14, 2021January 17, 2021 James Cameron

Question or problem about Python programming: I’m trying to run a macro via python but I’m not sure how to get it working…

Continue Reading

xls to csv converter

January 6, 2021 Andrew Rocky

Question or problem about Python programming: I am using win32.client in python for converting my .xlsx and .xls file into a .csv. When I execute this code it’s giving an error. My code is:

Continue Reading
Functions Defined The core of extensible programming is defining functions. Python allows mandatory and optional arguments, keyword arguments, and even arbitrary argument lists.

How do I read a date in Excel format in Python?

December 31, 2020 Simon Abital

Question or problem about Python programming: How can I convert an Excel date (in a number format) to a proper date in Python?

Continue Reading

Refresh QueryTable throwing “General ODBC error” – VBA Excel 2011 for Mac

December 30, 2020 Ogima Cooper

Question or issue on macOS: EDIT: New mistake found?

Continue Reading

Excel exporting hundreds of empty columns on CSV export

December 30, 2020 Abreonia Ng

Question or issue on macOS: Before I begin, I’m using Excel for Mac 2011. I’m having a problem with a particular Excel spreadsheet. When I export any of the active worksheets to CSV (windows CSV format), it exports ~200 blank columns along with the 7 or 8 populated columns. I’ve had a similar issue in […]

Continue Reading

Save embedded Word Doc as PDF

December 25, 2020 Andrew Rocky

Question or issue on macOS: SCENARIO

Continue Reading

Insert a Newline in Excel Formula (MacOS)

December 23, 2020 Odhran Miss

Question or issue on macOS: I am using MS Excel on a Mac. I have a formula, and I wish to insert a newline into it: Guests!A1 & ” ” & Guests!B1 & [newline here] Guests!C1 How can I do this? How to solve this problem? Solution no. 1: CHAR() is the appropriate function for […]

Continue Reading

Opening csv files in MicroSoft Excel on a mac

December 23, 2020 Aba Tayler

Question or issue on macOS: I am having trouble opening csv files correctly in Microsoft Excel for Mac 2011, Version 14.1.0. The files will open but the dialog box to set the delimiter as a comma does not come up and thus all the columns are concatenated with commas. Is there a way to get […]

Continue Reading

How to check which line of VBA code is causing errors

December 18, 2020 Ogima Cooper

Question or issue on macOS: I am trying to debug a long code I wrote and I need to step line by line.

Continue Reading

Posts navigation

Older posts

Same Catagory Posts

    iZZiSwift | Developed by iZZi Team from 2017