Can Python be used as a macro language for excel, Word, etc.?

[CynthiaMoore]

Yes python can be used.
please post a small excel file with output requirements, for an example.

In the mean time, you can look through excel related packages here: https://pypi.org/search/?q=excel
also look at openpyxl: https://pypi.org/project/openpyxl/
and it's doc page: https://openpyxl.readthedocs.io/en/stable/

I have attached an Excel workbook that uses a VBA function to format a time interval in the smallest units that is <= 1. Sheet 2 has the actual worksheet code. It will not work because the VBA function is in an add-in. Sheet 1 has the literal values.

The VBA function syntax is:

=FmtTime(pTime, [pDP|1], [pInUnits|"Days"])

• pTime is the time interval to be formatted
  
• pDP is the number of decimal places to return
  
• pInUnits is the units of pTime
  

Thanks


  Format Time.xlsx (Size: 12.84 KB / Downloads: 121)