管理图片

Aspose.Cells 允许开发人员在运行时向电子表格添加图片。此外，可以在运行时控制这些图片的定位，这将在接下来的部分中进行更详细的讨论。

本文介绍了如何添加图片，以及如何插入显示特定单元格内容的图像。

添加图片

将图片添加到电子表格非常容易。它只需要几行代码：只需调用添加的方法图片集合（封装在工作表目的）。这添加方法采用以下参数：

	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
	// The path to the documents directory.
	string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

	// Create directory if it is not already present.
	bool IsExists = System.IO.Directory.Exists(dataDir);
	if (!IsExists)
	System.IO.Directory.CreateDirectory(dataDir);

	// Instantiating a Workbook object
	Workbook workbook = new Workbook();

	// Adding a new worksheet to the Workbook object
	int sheetIndex = workbook.Worksheets.Add();

	// Obtaining the reference of the newly added worksheet by passing its sheet index
	Worksheet worksheet = workbook.Worksheets[sheetIndex];

	// Adding a picture at the location of a cell whose row and column indices
	// Are 5 in the worksheet. It is "F6" cell
	worksheet.Pictures.Add(5, 5, dataDir + "logo.jpg");

	// Saving the Excel file
	workbook.Save(dataDir + "output.xls");

使用Aspose.Cells控制图片的定位有两种可能的方式：

开发人员可以使用上DeltaX和上三角洲的属性Aspose.Cells.Drawing.Picture目的。一种图片对象可以从图片通过传递其图片索引来收集。此示例将图像放置在 F6 单元格中。

	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
	// The path to the documents directory.
	string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

	// Create directory if it is not already present.
	bool IsExists = System.IO.Directory.Exists(dataDir);
	if (!IsExists)
	System.IO.Directory.CreateDirectory(dataDir);

	// Instantiating a Workbook object
	Workbook workbook = new Workbook();

	// Adding a new worksheet to the Workbook object
	int sheetIndex = workbook.Worksheets.Add();

	// Obtaining the reference of the newly added worksheet by passing its sheet index
	Worksheet worksheet = workbook.Worksheets[sheetIndex];

	// Adding a picture at the location of a cell whose row and column indices
	// Are 5 in the worksheet. It is "F6" cell
	int pictureIndex = worksheet.Pictures.Add(5, 5, dataDir + "logo.jpg");

	// Accessing the newly added picture
	Aspose.Cells.Drawing.Picture picture = worksheet.Pictures[pictureIndex];

	// Positioning the picture proportional to row height and colum width
	picture.UpperDeltaX = 200;
	picture.UpperDeltaY = 200;

	// Saving the Excel file
	workbook.Save(dataDir + "book1.out.xls");

开发者还可以通过使用剩下和最佳的属性图片目的。此示例将图像放置在单元格 F6 中，距离单元格左侧 60 像素，距离单元格顶部 10 像素。

	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
	// The path to the documents directory.
	string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

	// Instantiating a Workbook object
	Workbook workbook = new Workbook();

	// Adding a new worksheet to the Workbook object
	int sheetIndex = workbook.Worksheets.Add();

	// Obtaining the reference of the newly added worksheet by passing its sheet index
	Worksheet worksheet = workbook.Worksheets[sheetIndex];

	// Adding a picture at the location of a cell whose row and column indices
	// Are 5 in the worksheet. It is "F6" cell
	int pictureIndex = worksheet.Pictures.Add(5, 5, dataDir + "logo.jpg");

	// Accessing the newly added picture
	Aspose.Cells.Drawing.Picture picture = worksheet.Pictures[pictureIndex];

	// Absolute positioning of the picture in unit of pixels
	picture.Left = 60;
	picture.Top = 10;

	// Saving the Excel file
	workbook.Save(dataDir + "book1.out.xls");

Aspose.Cells 允许您以图像形状显示工作表单元格的内容。您可以将图片链接到包含要显示的数据的单元格。由于单元格或单元格区域链接到图形对象，因此您对该单元格或单元格区域中的数据所做的更改会自动出现在图形对象中。

通过调用将图片添加到工作表添加图片的方法形状集合集合（封装在工作表目的）。使用指定单元格范围公式的属性图片目的。

	// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
	// The path to the documents directory.
	string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);

	// Instantiate a new Workbook
	Workbook workbook = new Workbook();
	// Get the first worksheet's cells collection
	Cells cells = workbook.Worksheets[0].Cells;

	// Add string values to the cells
	cells["A1"].PutValue("A1");
	cells["C10"].PutValue("C10");

	// Add a blank picture to the D1 cell
	Picture pic = workbook.Worksheets[0].Shapes.AddPicture(0, 3, 10, 6, null);

	// Specify the formula that refers to the source range of cells
	pic.Formula = "A1:C10";

	// Update the shapes selected value in the worksheet
	workbook.Worksheets[0].Shapes.UpdateSelectedValue();

	// Save the Excel file.
	workbook.Save(dataDir + "output.out.xls");