将背景图像插入Excel
Contents
[
Hide
]
通过添加图片作为工作表背景,你可以使工作表更具吸引力。如果你有一个特殊的公司图形,它可以在不遮挡工作表数据的情况下为背景增添一丝色彩。你可以使用Aspose.Cells API设置工作表的背景图片。
在Microsoft Excel中设置工作表背景
在Microsoft Excel(例如Microsoft Excel 2019)中设置工作表的背景图片:
-
从页面布局菜单中找到页面设置选项,然后点击背景选项。
-
选择一张图片来设置工作表的背景图片。
设置工作表背景
使用Aspose.Cells设置工作表背景
下面的代码使用从流中读取的图像设置了一个背景图像。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET | |
// Create a new Workbook. | |
Workbook workbook = new Workbook(); | |
// Get the first worksheet. | |
Worksheet sheet = workbook.Worksheets[0]; | |
// Set the background image for the worksheet. | |
sheet.BackgroundImage = File.ReadAllBytes("background.jpg"); | |
// Save the Excel file | |
workbook.Save("outputBackImageSheet.xlsx"); | |
// Save the HTML file | |
workbook.Save("outputBackImageSheet.html", SaveFormat.Html); |