python xlwings chart 横坐标标题位置TickLabelPosition

In xlwings, you can use the xlwings.Chart object to create and manipulate charts in Excel. To change the position of the horizontal axis title, you can use the TickLabelPosition property.

Here's an example of how to change the position of the horizontal axis title using xlwings:

import xlwings as xw

# Connect to Excel
wb = xw.Book('path/to/your/workbook.xlsx')
sheet = wb.sheets['Sheet1']

# Create a chart
chart = sheet.charts.add()

# Set the range for the chart data
chart.set_source_data(sheet.range('A1:B10'))

# Set the chart type to a line chart
chart.chart_type = 'xlLine'

# Change the position of the horizontal axis title
chart.api.Axes(xlCategory, xlPrimary).AxisTitle.TickLabelPosition = 'xlTickLabelPositionLow'

# Save the workbook
wb.save()
wb.close()

In the above example, xlTickLabelPositionLow is used to set the position of the horizontal axis title to the bottom of the chart. You can also use other values like xlTickLabelPositionHigh for the top, xlTickLabelPositionNextToAxis for next to the axis, or xlTickLabelPositionNone to hide the title.

Make sure to replace 'path/to/your/workbook.xlsx' with the actual path to your workbook and 'Sheet1' with the name of your worksheet