将 NumPy 转换为 Excel

使用 Aspose.Cells for Python via .NET API，您可以将 NumPy 数组转换为 Excel、OpenOffice、Pdf、Json 和许多不同的格式。

将 NumPy 数组转换为 Excel

下面是一个示例代码片段，演示如何使用 Aspose.Cells for Python via .NET 将数据从 NumPy 数组导入到 Excel 文件：

	import numpy as np
	from aspose.cells import Workbook, Worksheet

	def put_value(cells, raw_value, row , column):
	cell = cells.get(row , column)
	dtype = type(raw_value)
	match dtype:
	case np.bool_ :
	value = bool(raw_value)
	case np.int_ :
	value = int(raw_value)
	case np.intc :
	value = int(raw_value)
	case np.intp :
	value = int(raw_value)
	case np.int8 :
	value = int(raw_value)
	case np.int16 :
	value = int(raw_value)
	case np.int32 :
	value = int(raw_value)
	case np.int64 :
	value = int(raw_value)
	case np.uint8 :
	value = int(raw_value)
	case np.uint16 :
	value = int(raw_value)
	case np.uint32 :
	value = int(raw_value)
	case np.uint64 :
	value = int(raw_value)
	case np.float_:
	value = int(raw_value)
	case np.float16:
	value = float(raw_value)
	case np.float32:
	value = float(raw_value)
	case np.float64:
	value = float(raw_value)
	case np.single:
	value = float(raw_value)
	case np.double:
	value = float(raw_value)
	case np.datetime64 :
	ts = pd.to_datetime(str(raw_value))
	value = ts.strftime('%Y.%m.%d')
	case _:
	value = raw_value
	cell.put_value(value)
	pass

	# Create a sample NumPy array
	data = np.array([[1, 2, 3], [4, 5, 6], [7, 8, 9]])


	# Create a new Aspose.Cells Workbook
	workbook = Workbook()

	# Access the first (default) worksheet
	worksheet = workbook.worksheets[0]

	# Get the cells
	cells = worksheet.cells

	# Import data from NumPy array to the worksheet
	rowindex = -1
	colindex = 0
	for row in data:
	rowindex += 1
	colindex = 0
	for item in row:
	put_value(cells, item, rowindex, colindex)
	print(item)
	colindex += 1

	# Save the Excel file
	workbook.save("out.xlsx")